<font face="David CLM">Hello everybody,<br /><br /> I've just installed PostgreSQL and I'm unable to connect to it
remotelyfrom my main desktop (I'm trying to connect with pgAdmin 3).<br /><br /> My setup:<br /> Ubuntu Server 14.04
x64(Azure Cloud)<br /> PostgreSQL v9.3.5-0ubuntu0.14.04.1<br /> contrib package is also installed.<br /> PostgreSQL is
startedon boot using Upstart. I've modified this script: <a class="moz-txt-link-freetext"
href="https://gist.github.com/haad/6020401">https://gist.github.com/haad/6020401</a>(just version numbers)<br /><br />
MyProblems:<br /> 1) For some reason, when I've installed pg, /var/run/postgresql was missing. I've manually created
thisfolder and gave my pg user write permissions. Is that a bug?<br /> 2) I've tried to change the log config in
/etc/postgresql/9.3/main/postgresql.confbut it won't work. I think that pg is ignoring that file. I also have no idea
whereis pg log file (I tried /var/log/postgresql - not there). I tried starting the DB manually with pg_ctl -l but the
logdoes say much:<br /> LOG: database system is ready to accept connections<br /> LOG: autovacuum launcher
started<br/> LOG: received SIGHUP, reloading configuration files<br /> LOG: received smart shutdown
request<br/> LOG: autovacuum launcher shutting down<br /> LOG: shutting down<br /> LOG: database system
isshut down<br /> LOG: database system was shut down at 2014-10-17 21:22:11 UTC<br /> LOG: database system is
readyto accept connections<br /> LOG: autovacuum launcher started<br /> This log contains a single DB run.<br />
3)I'm unable to connect from my main desktop. Server is listening according to netstat. There is no firewall on the
serverand I've created an Azure endpoint for port 5432. Ideas?<br /><br /> Can you help me? <br /><br /> Thanks,<br
/><br/></font><div class="moz-signature">-- <br /></div><p><font face="Liberation Serif, serif"><span
lang="en-US"><fontface="Times New Roman"><font size="4" style="font-size: 14pt">Shay Gover<br /> IT Consultant<br /><a
href="www.kapot-tamar.com">KapotTamar</a> </font></font></span></font>
