HostOnNet Blog

No PostgreSQL clusters exist; see “man pg_createcluster”

postgreSQL

On Ubuntu VPS starting PostgreSQL, got following error

root@vps60814:~# service postgresql start
 * No PostgreSQL clusters exist; see "man pg_createcluster"
root@vps60814:~# 

Starting PostgreSQL manually get following error

root@vps60814:~# pg_createcluster 9.3 main --start
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
    LANGUAGE = (unset),
    LC_ALL = (unset),
    LC_PAPER = "en_IN.UTF-8",
    LC_ADDRESS = "en_IN.UTF-8",
    LC_MONETARY = "en_IN.UTF-8",
    LC_NUMERIC = "en_IN.UTF-8",
    LC_TELEPHONE = "en_IN.UTF-8",
    LC_IDENTIFICATION = "en_IN.UTF-8",
    LC_MEASUREMENT = "en_IN.UTF-8",
    LC_TIME = "en_IN.UTF-8",
    LC_NAME = "en_IN.UTF-8",
    LANG = "en_GB.UTF-8"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
Error: The locale requested by the environment is invalid.
root@vps60814:~#

To fix, you need to set locale.

Refer Blog Post

https://blog.hostonnet.com/ubuntu-14-04-openvz-locale-cannot-set-lc_all-to-default-locale-no-such-file-or-directory

Once this is fixed, PostgreSQL started working properly.


Posted in Linux