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
Once this is fixed, PostgreSQL started working properly.