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: https://id.mayfirst.org/jamie
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 https://id.mayfirst.org/dskallman

  • Description modified (diff)
  • Keywords ossie.mayfirst.org postgresSQL added
  • Owner set to https://id.mayfirst.org/dskallman
  • Status changed from new to assigned

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

comment:2 Changed 4 years ago by https://id.mayfirst.org/dskallman

  • Owner changed from https://id.mayfirst.org/dskallman to https://id.mayfirst.org/jamie

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

  • Description modified (diff)

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

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

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 changed from feedback to closed

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.