Opened 4 years ago

Closed 4 years ago

#10968 closed Task/To do item (fixed)

New postgreSQL database on floriberto

Reported by: Owned by: JaimeV
Priority: Medium Component: Tech
Keywords: Cc:
Sensitive: no


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 4 years ago by

Keywords: GRIP-UQAM added

comment:2 Changed 4 years ago by JaimeV

Keywords: GRIP-UQAM removed
Owner: set to JaimeV
Status: newassigned

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 4 years ago by

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 4 years ago by 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 4 years ago by JaimeV

Resolution: fixed
Status: assignedclosed

Please login to add comments to this ticket.

Note: See TracTickets for help on using tickets.