[email protected], 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?
