PostgreSQL 9.4: initdb: invalid locale settings

2015-01-21 Thread opendaddy
Hello, Why won't `postgresql-server-9.4.0` accept my locale? Just upgraded to 5.7 from 5.5. Whatever `postgresql-server` version was in 5.5 didn't have this problem. % su _postgresql % initdb -D /var/postgresql/data/ The files belonging to this database system will be owned by user

Re: PostgreSQL 9.4: initdb: invalid locale settings

2015-01-21 Thread frantisek holop
openda...@hushmail.com, 21 Jan 2015 19:29: > Why won't `postgresql-server-9.4.0` accept my locale? Just upgraded to 5.7 > from 5.5. Whatever `postgresql-server` version was in 5.5 didn't have this > problem. > > % su _postgresql > % initdb -D /var/postgresql/data/ LC_ALL is not supporte

Re: PostgreSQL 9.4: initdb: invalid locale settings

2015-01-21 Thread opendaddy
Hello, On 21. januar 2015 at 8:26 PM, "frantisek holop" wrote: > >LC_ALL is not supported yet, try LC_CTYPE. > >$ sudo su - _postgresql >$ export LC_CTYPE=en_US.UTF-8 >$ initdb -D /var/postgresql/data -U postgres -E UTF8 -A md5 -W >$ psql -U postgres -l I couldn't get it to work with `LC_CTYPE`.

Re: PostgreSQL 9.4: initdb: invalid locale settings

2015-01-21 Thread frantisek holop
openda...@hushmail.com, 21 Jan 2015 20:41: > Hello, > > On 21. januar 2015 at 8:26 PM, "frantisek holop" wrote: > > > >LC_ALL is not supported yet, try LC_CTYPE. > > > >$ sudo su - _postgresql > >$ export LC_CTYPE=en_US.UTF-8 > >$ initdb -D /var/postgresql/data -U postgres -E UTF8 -A md5 -W > >$

Re: PostgreSQL 9.4: initdb: invalid locale settings

2015-01-21 Thread opendaddy
On 21. januar 2015 at 8:44 PM, "frantisek holop" wrote: > >you are not giving details, so i don't know. >but a non-utf8 database nowadays is very limiting. Indeed, thanks for your example. I'm now rolling with `initdb -D /var/postgresql/data/ --no-locale -E UTF8`. O.D.