Opened 4 years ago

Closed 4 years ago

#10399 closed Task/To do item (fixed)

New postgreSQL database on ossie

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

Description (last modified by

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

  • Description modified (diff)
  • Keywords postgresSQL added
  • Owner set to
  • 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

  • Owner changed from to

comment:3 Changed 4 years ago by

  • Description modified (diff)

comment:4 Changed 4 years ago by

  • 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)


let me know if you have any problems.


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.