Opened 4 years ago

Closed 4 years ago

#10399 closed Task/To do item (fixed)

New postgreSQL database on ossie

Reported by: https://id.mayfirst.org/gripuqam Owned by: Jamie McClelland
Priority: Medium Component: Tech
Keywords: ossie.mayfirst.org, postgresSQL Cc:
Sensitive: no

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

I need a new UTF8 postgreSQL database on ossie for the UNIX user ladepense-carrefouralim-webadmin.

postgres@ossie:~$ createuser -D -R -S fonciersolidaire-webadmin
postgres@ossie:~$ createdb -O fonciersolidaire-webadmin --encoding=UTF8 fonciersolidaire-web
postgres@ossie:~$ psql fonciersolidaire-web --command="\l"

It should have similar UTF8 as 10322.

Change History (5)

comment:1 Changed 4 years ago by Dana

Description: modified (diff)
Keywords: ossie.mayfirst.org postgresSQL added
Owner: set to Dana
Status: newassigned

Thanks for the ticket. Am referencing #10322 and looping Jamie in on this.

comment:2 Changed 4 years ago by Dana

Owner: changed from Dana to Jamie McClelland

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

Description: modified (diff)

comment:4 Changed 4 years ago by Jamie McClelland

Resolution: fixed
Status: assignedfeedback

Hi -

You should be set now. I ran your commands, except the UTF8 part (since our templates are now ut8 this should be the default).

Here is the output:

postgres@ossie:~$ psql fonciersolidaire-web --command="\l"
                                                        List of databases
              Name              |              Owner               | Encoding  |  Collate   |   Ctype    |   Access privileges   
--------------------------------+----------------------------------+-----------+------------+------------+-----------------------
 apcwomen_media                 | apcwomen                         | UTF8      | C          | C          | 
 fonciersolidaire-web           | fonciersolidaire-webadmin        | UTF8      | en_US.UTF8 | en_US.UTF8 | 
 ladepense-carrefouralimentaire | ladepense-carrefouralim-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 | 
(6 rows)

postgres@ossie:~$ 

let me know if you have any problems.

jamie

comment:5 Changed 4 years ago by automatic

Status: feedbackclosed

No news is good news (we hope)! Given the lack of feedback, we think this ticket can be closed.

Please login to add comments to this ticket.

Note: See TracTickets for help on using tickets.