Re: problem connecting to postgres via apache - Mailing list pgsql-general

From Sameer Kumar
Subject Re: problem connecting to postgres via apache
Date
Msg-id CADp-Sm5Y3eKP5dkUwpCdQm34r9NRnp6w8xTd+ua7fwcbYr03hw@mail.gmail.com
Whole thread Raw
In response to Re: problem connecting to postgres via apache  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general

On Fri, Jan 24, 2014 at 7:08 AM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
On 01/23/2014 02:55 PM, Susan Cassidy wrote:
I'm having a problem connecting to postgres via a CGI program.  I can
connect just fine using the same connect string in a non-cgi perl
program as in the perl cgi program.  The error I get is this:


        ERROR: Unable to connect to dbname testdb2, err: could not
        connect to server: Permission denied
        Is the server running on host "jacensolo.red.dsic.com
        <http://jacensolo.red.dsic.com>" (192.168.10.16) and accepting

        TCP/IP connections on port 5432?

FYI, in the future you might want to anonymize your host information. For example   xxx.yyy.zzz.com

Well from the above it looks like you where trying to connect using TCP/IP not a socket.

What is your connection string?

In addition to what has been already asked, can you also check if your firewall is running?


Best Regards,
Sameer Kumar | Database Consultant
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M : +65 8110 0350 T: +65 6438 3504 | www.ashnik.com
www.facebook.com/ashnikbiz | www.twitter.com/ashnikbiz

email patch

This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).

Attachment

pgsql-general by date:

Previous
From: Sameer Kumar
Date:
Subject: Re: Fully-automatic streaming replication failover when master dies?
Next
From: Scott Marlowe
Date:
Subject: Re: Fully-automatic streaming replication failover when master dies?