PostgreSQL 8.4.20 problem with locales
Today most of my sites stopped to work. After some time I've noticed that PostgreSQL has some problem with locale:
psql: FATAL: database locale is incompatible with operating system DETAIL: The database was initialized with LC_COLLATE "pl_PL.UTF-8", which is not recognized by setlocale(). HINT: Recreate the database with another locale or install the missing locale.
I've found similar symptoms in thread "Problem with locales on Linux with 9.3.4" posted by Hubert "depesz" Lubaczewski.
My databases has collation pl_PL.UTF-8:
List of databases
Name | Owner | Encoding | Collation | Ctype | Access privileges
--------------------+--------------------+----------+-------------+-------------+-----------------------
eztest-demo | xxxxxxxx | UTF8 | pl_PL.UTF-8 | pl_PL.UTF-8 |
eztest-flow | xxxxxxxx | UTF8 | pl_PL.UTF-8 | pl_PL.UTF-8 |
eztest-web | xxxxxxxx | UTF8 | pl_PL.UTF-8 | pl_PL.UTF-8 |and this locale was installed:
[root@jaqb ~]# locale -a | grep pl pl_PL pl_PL.iso88592 pl_PL.utf8
The solution: Restart PostgreSQL ;-)
[root@jaqb ~]# /etc/init.d/postgresql restart Stopping postgresql service: [ OK ] Starting postgresql service: [ OK ] [root@jaqb ~]# psql eztest-web psql (8.4.20) Type "help" for help. eztest-web=>
That's all.
Comments
Log in or create a user account to comment.