Monday, 1 August 2016

Solution to PostgreSQL not starting

I installed postgresql9.5 on ubuntu 16.04, using "apt-get install" everything was running fine, until I installed MySQL.
PostgreSQL was not starting, in-spite of making all the required changes n pg_hba.conf and postgresql.cof files.

Finally I found the following solution :

1-sudo mkdir -p /usr/local/pgsql/data
2-s-udo chown -R postgres:postgres /usr/local/pgsql/

(Login as postgresql user)


3-sudo -u postgres -i
4-cd /usr/lib/postgresql/9.5/bin
5-./initdb -D /usr/local/pgsql/data
6-./postgres -D /usr/local/pgsql/data/ (Keep it running)


Thanks to https://ubuntuforums.org/showthread.php?t=869080

No comments:

Post a Comment