gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Restoring a database under Debian - invalid locale na


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Restoring a database under Debian - invalid locale name "en_CA"
Date: Sat, 24 Jan 2015 00:06:34 +0100
User-agent: Mutt/1.5.23 (2014-03-12)

On Sat, Jan 24, 2015 at 12:04:12AM +0100, Karsten Hilbert wrote:

> > psql -p 5433 -l
> >                                   List of databases
> >    Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access 
> > privileges   
> > -----------+----------+----------+-------------+-------------+-----------------------
> >  postgres  | postgres | UTF8     | en_CA.UTF-8 | en_CA.UTF-8 | 
> >  template0 | postgres | UTF8     | en_CA.UTF-8 | en_CA.UTF-8 | =c/postgres  
> >         +
> >            |          |          |             |             | 
> > postgres=CTc/postgres
> >  template1 | postgres | UTF8     | en_CA.UTF-8 | en_CA.UTF-8 | =c/postgres  
> >         +
> >            |          |          |             |             | 
> > postgres=CTc/postgres
> > (3 rows)
> > 
> > /usr/lib/postgresql/9.4/bin/initdb -D /var/lib/postgresql/9.4/main 
> > --locale=en_CA
> >     The files belonging to this database system will be owned by user 
> > "postgres".
> >     This user must also own the server process.
> >     initdb: invalid locale name "en_CA"
> 
> Here's the gist of the matter:
> 
>       
> http://stackoverflow.com/questions/21175324/postgres-encoding-issue-on-create-restore-database
> 
> There simply is no foolproof solution to this.

And there's this:

        https://wiki.postgresql.org/wiki/Usability_Challenges

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346



reply via email to

[Prev in Thread] Current Thread [Next in Thread]