Re: [Gnumed-devel] Postgres 8.4.4-1 (Enterprise db) problems -- system hosed?

[Jim Busser]

On 2010-07-01, at 2:16 AM, Sebastian Hilbert wrote:

> If you have a chance and still the en_CA local installed please report what
> 
> psql -l is reporting.
> 
> I wonder if there is a way to find out if en_CA is utf8 and not fail in the 
> bootstrapper.


MacBook:/ djb$ sudo su postgres
Password:
bash-3.2$ psql -l
Password: 
                              List of databases
   Name    |  Owner   | Encoding | Collation | Ctype |   Access privileges   
-----------+----------+----------+-----------+-------+-----------------------
 postgres  | postgres | UTF8     | en_CA     | en_CA | 
 template0 | postgres | UTF8     | en_CA     | en_CA | =c/postgres
                                                     : postgres=CTc/postgres
 template1 | postgres | UTF8     | en_CA     | en_CA | =c/postgres
                                                     : postgres=CTc/postgres
(3 rows)

bash-3.2$ 

-- Jim