I'm starting up a postgres 9.3 instance on a ubuntu 12.04 server :
~# service postgresql start
* The PostgreSQL server failed to start. Please check the log output.
[fail]
the start fails, but it leaves no log, this file is empty :
tail /var/log/postgresql/postgresql-9.3-main.log
and the are no other files in this directory : /var/log/postgresql/
what is the best way to troubleshoot this ?
su - postgres; /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
and see what it gives you. You may need to change user name and paths depending on your setup.-d 3
to thepostgres
command. This will enable more extensive debugging output written to the log. You can lower the debugging output by changing it to 1 or 2, or increase it by changing it to 4 or 5. Also, what is the output ofwhich pgsql
?