I've just installed PostgreSQL and I'm unable to connect to it
remotely from my main desktop (I'm trying to connect with pgAdmin
3).
My setup:
Ubuntu Server 14.04 x64 (Azure Cloud)
PostgreSQL v9.3.5-0ubuntu0.14.04.1
contrib package is also installed.
PostgreSQL is started on boot using Upstart. I've modified this
script: https://gist.github.com/haad/6020401 (just version
numbers)
My Problems:
1) For some reason, when I've installed pg, /var/run/postgresql
was missing. I've manually created this folder and gave my pg user
write permissions. Is that a bug?
2) I've tried to change the log config in
/etc/postgresql/9.3/main/postgresql.conf but it won't work. I
think that pg is ignoring that file. I also have no idea where is
pg log file (I tried /var/log/postgresql - not there). I tried
starting the DB manually with pg_ctl -l but the log does say much:
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
LOG: received SIGHUP, reloading configuration files
LOG: received smart shutdown request
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2014-10-17 21:22:11 UTC
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
This log contains a single DB run.
3) I'm unable to connect from my main desktop. Server is listening
according to netstat. There is no firewall on the server and I've
created an Azure endpoint for port 5432. Ideas?