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

[Sebastian Hilbert]

Am Donnerstag 01 Juli 2010, 11:46:12 schrieb 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/postgre
>                                                      : s
> 
>  template1 | postgres | UTF8     | en_CA     | en_CA | =c/postgres
> 
>                                                      : postgres=CTc/postgre
>                                                      : s
> 
> (3 rows)
> 
In that case it would have been safe to continue. Maybe we can make use of 
this information as well.

If we parse psql -l or have some other way to get the encoding this would let 
us continue even if we have the above situation.

Sebastian