From: Shay Gover <shay@kapotamar.com>
To: pgsql-admin@postgresql.org
Subject: Unable to connect remotely
Date: Sat, 18 Oct 2014 01:12:43 +0300
Message-ID: <5441945B.6010000@kapotamar.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
<html style="direction: ltr;">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;" bidimailui-charset-is-forced="true"
bgcolor="#FFFFFF" text="#000066">
<font face="David CLM">Hello everybody,<br>
<br>
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).<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 started on 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>
My Problems:<br>
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?<br>
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:<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 is shut down<br>
LOG: database system was shut down at 2014-10-17 21:22:11 UTC<br>
LOG: database system is ready to 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 server and 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>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title></title>
<meta name="generator" content="LibreOffice 4.3.0.4 (Windows)">
<meta name="created" content="00:00:00">
<meta name="changed" content="2014-08-23T05:53:57.511000000">
<style type="text/css">
p { direction: inherit; color: #000066 }
</style>
<p><font face="Liberation Serif, serif"><span lang="en-US"><font
face="Times New Roman"><font style="font-size: 14pt"
size="4">Shay
Gover<br>
IT Consultant<br>
<a href="www.kapot-tamar.com">Kapot Tamar</a>
</font></font></span></font>
</p>
</div>
</body>
</html>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: shay@kapotamar.com
Subject: Re: Unable to connect remotely
In-Reply-To: <5441945B.6010000@kapotamar.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox