HostOnNet Blog

No PostgreSQL clusters exist; see “man pg_createcluster”


On Ubuntu VPS starting PostgreSQL, got following error

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

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_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.

To fix, you need to set locale.

Refer Blog Post

Once this is fixed, PostgreSQL started working properly.

Posted in Linux