Opened 3 years ago

Closed 3 years ago

#10968 closed Task/To do item (fixed)

New postgreSQL database 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

I need a new UTF8 postgreSQL database on floriberto for the UNIX user alimentsdici-webadmin.

postgres@floriberto:~$ createuser -D -R -S alimentsdici-webadmin
postgres@floriberto:~$ createdb -O alimentsdici-webadmin alimentsdici-webadmin
postgres@floriberto:~$ psql alimentsdici-webadmin --command="\l"

It should have similar UTF8 as 10322. The UNIX account alimentsdici-webadmin has just been created on floriberto.

Change History (5)

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

  • Keywords GRIP-UQAM added

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

  • Keywords GRIP-UQAM removed
  • Owner set to https://id.mayfirst.org/jaimev
  • Status changed from new to assigned

Done. At first the database was created as ASCII encoding. I had to drop it, change the template databases from ASCII to UTF8 following the same commands jamie documented in #10322 , and recreate it with UTF8 encoding.

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

It works perfectly. It was a good idea to name the DB after the UNIX user name. I am not sure to understand why my keyword has to be removed, I may have to way I find and follow my tickets.

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

Do you mean the keywords associated with the ticket? You should be able to add any keyword you like to the ticket.

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

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

Please login to add comments to this ticket.

Note: See TracTickets for help on using tickets.