[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
- Re: [Gnumed-devel] Restoring a database under Debian, (continued)
- Re: [Gnumed-devel] Restoring a database under Debian, Karsten Hilbert, 2015/01/15
- Re: [Gnumed-devel] Restoring a database under Debian, Busser, Jim, 2015/01/22
- Re: [Gnumed-devel] Restoring a database under Debian, Karsten Hilbert, 2015/01/22
- Re: [Gnumed-devel] Restoring a database under Debian, Karsten Hilbert, 2015/01/22
- Re: [Gnumed-devel] Restoring a database under Debian, Karsten Hilbert, 2015/01/22
- Re: [Gnumed-devel] Restoring a database under Debian, Karsten Hilbert, 2015/01/22
- Re: [Gnumed-devel] Restoring a database under Debian, Busser, Jim, 2015/01/22
- Re: [Gnumed-devel] Restoring a database under Debian, Karsten Hilbert, 2015/01/22
- Re: [Gnumed-devel] Restoring a database under Debian - invalid locale name "en_CA", Busser, Jim, 2015/01/23
- Re: [Gnumed-devel] Restoring a database under Debian - invalid locale name "en_CA", Karsten Hilbert, 2015/01/23
- Re: [Gnumed-devel] Restoring a database under Debian - invalid locale name "en_CA",
Karsten Hilbert <=
- Re: [Gnumed-devel] Restoring a database under Debian, Busser, Jim, 2015/01/23
- Re: [Gnumed-devel] Restoring a database under Debian, Busser, Jim, 2015/01/24
- Re: [Gnumed-devel] Restoring a database under Debian, Busser, Jim, 2015/01/24
- Re: [Gnumed-devel] Restoring a database under Debian, Karsten Hilbert, 2015/01/24
- Re: [Gnumed-devel] Restoring a database under Debian, Busser, Jim, 2015/01/24
- Re: [Gnumed-devel] Restoring a database under Debian, Karsten Hilbert, 2015/01/25
- Re: [Gnumed-devel] Restoring a database under Debian, Busser, Jim, 2015/01/25
- Re: [Gnumed-devel] Restoring a database under Debian, Karsten Hilbert, 2015/01/14
- Re: [Gnumed-devel] Restoring a database under Debian, Karsten Hilbert, 2015/01/15
- Re: [Gnumed-devel] Restoring a database under Debian, Busser, Jim, 2015/01/15