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 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
Password for user postgres:
List of databases
   Name|  Owner   | Encoding | Collate |Ctype|   Access privileges
---+--+--+-+-+---
 postgres  | postgres | UTF8 | C   | en_US.UTF-8 |
 template0 | postgres | UTF8 | C   | en_US.UTF-8 | =c/postgres  
+
   |  |  | | | postgres=CTc/postgres
 template1 | postgres | UTF8 | C   | en_US.UTF-8 | =c/postgres  
+
   |  |  | | | postgres=CTc/postgres
(3 rows)

-f
-- 
if practice makes perfect, and nobody's perfect, why practice?

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 min...@obiit.org 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`. It did, however, work with `initdb 
 -D /var/postgresql/data/ --no-locale`.

you are not giving details, so i don't know.
but a non-utf8 database nowadays is very limiting.

-f
-- 
god?  i'm no god.  god has mercy.

Re: PostgreSQL 9.4: initdb: invalid locale settings

2015-01-21 Thread opendaddy 
Hello,

On 21. januar 2015 at 8:26 PM, frantisek holop min...@obiit.org 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`. It did, however, work with `initdb 
-D /var/postgresql/data/ --no-locale`.

O.D.

Re: PostgreSQL 9.4: initdb: invalid locale settings

2015-01-21 Thread opendaddy 
On 21. januar 2015 at 8:44 PM, frantisek holop min...@obiit.org 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.