Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XfFln-0007Kc-RL for pgsql-admin@arkaria.postgresql.org; Fri, 17 Oct 2014 22:13:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XfFln-0004oK-Ae for pgsql-admin@arkaria.postgresql.org; Fri, 17 Oct 2014 22:13:11 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XfFll-0004lK-Ft for pgsql-admin@postgresql.org; Fri, 17 Oct 2014 22:13:09 +0000 Received: from gateway16.websitewelcome.com ([69.93.35.23]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XfFld-0003q7-Qg for pgsql-admin@postgresql.org; Fri, 17 Oct 2014 22:13:07 +0000 Received: by gateway16.websitewelcome.com (Postfix, from userid 5007) id E03B986F603B7; Fri, 17 Oct 2014 17:13:00 -0500 (CDT) Received: from gator4123.hostgator.com (gator4123.hostgator.com [192.185.4.135]) by gateway16.websitewelcome.com (Postfix) with ESMTP id D66EB86F6037B for ; Fri, 17 Oct 2014 17:13:00 -0500 (CDT) Received: from [31.210.186.120] (port=57534 helo=[192.168.2.18]) by gator4123.hostgator.com with esmtpsa (UNKNOWN:DHE-RSA-AES128-SHA:128) (Exim 4.82) (envelope-from ) id 1XfFlc-0003Ii-Dk for pgsql-admin@postgresql.org; Fri, 17 Oct 2014 17:13:00 -0500 Message-ID: <5441945B.6010000@kapotamar.com> Date: Sat, 18 Oct 2014 01:12:43 +0300 From: Shay Gover User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.1.2 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Unable to connect remotely Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - gator4123.hostgator.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - kapotamar.com X-BWhitelist: no X-Source-IP: 31.210.186.120 X-Exim-ID: 1XfFlc-0003Ii-Dk X-Source: X-Source-Args: X-Source-Dir: X-Source-Sender: ([192.168.2.18]) [31.210.186.120]:57534 X-Source-Auth: shay@kapotamar.com X-Email-Count: 1 X-Source-Cap: a3Q7a3Q7Z2F0b3I0MTIzLmhvc3RnYXRvci5jb20= X-Pg-Spam-Score: -1.4 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hello everybody,

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?

Can you help me?

Thanks,

Shay Gover
IT Consultant
Kapot Tamar