Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#11366 closed Task/To do item (fixed)

New postgreSQL databases on floriberto

Reported by: https://id.mayfirst.org/gripuqam Owned by: https://id.mayfirst.org/jaimev
Priority: Medium Component: Tech
Keywords: Cc:
Sensitive: no

Description (last modified by https://id.mayfirst.org/gripuqam)

I need a new UTF8 postgreSQL database on floriberto for the UNIX user castor-webadmin, who is already a postgres user.

postgres@floriberto:~$ createdb -O castor-webadmin castor-orm
postgres@floriberto:~$ psql castor-orm --command="\l"

It should have similar UTF8 as 10322. The UNIX accounts castor-webadmin has already castor-webadmin db, but it needs two of them.

Change History (3)

comment:1 Changed 3 years ago by https://id.mayfirst.org/jaimev

  • Owner set to https://id.mayfirst.org/jaimev
  • Status changed from new to assigned

This is the new ouput.

postgres@floriberto:~$ createdb -O castor-webadmin castor-orm
postgres@floriberto:~$ psql castor-orm --command="\l"
                                              List of databases
         Name          |         Owner         | Encoding  |  Collate   |   Ctype    |   Access privileges   
-----------------------+-----------------------+-----------+------------+------------+-----------------------
 alimentsdici-webadmin | alimentsdici-webadmin | UTF8      | en_US.UTF8 | en_US.UTF8 | 
 castor-orm            | castor-webadmin       | UTF8      | en_US.UTF8 | en_US.UTF8 | 
 castor-webadmin       | castor-webadmin       | UTF8      | en_US.UTF8 | en_US.UTF8 | 
 pollux-webadmin       | pollux-webadmin       | UTF8      | en_US.UTF8 | en_US.UTF8 | 
 postgres              | postgres              | SQL_ASCII | C          | C          | 
 template0             | postgres              | UTF8      | en_US.UTF8 | en_US.UTF8 | =c/postgres          +
                       |                       |           |            |            | postgres=CTc/postgres
 template1             | postgres              | UTF8      | en_US.UTF8 | en_US.UTF8 | 
(7 rows)

comment:2 Changed 3 years ago by https://id.mayfirst.org/gripuqam

  • Resolution set to fixed
  • Status changed from assigned to closed

Thanks! It works very good!

comment:3 Changed 3 years ago by https://id.mayfirst.org/gripuqam

  • Description modified (diff)

Please login to add comments to this ticket.

Note: See TracTickets for help on using tickets.