Unable to connect remotely
От | Shay Gover |
---|---|
Тема | Unable to connect remotely |
Дата | |
Msg-id | 5441945B.6010000@kapotamar.com обсуждение исходный текст |
Ответы |
Re: Unable to connect remotely
|
Список | pgsql-admin |
<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>
В списке pgsql-admin по дате отправления: