Re: ssl database connection problems...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "Carol Walter" <walterc(at)indiana(dot)edu>, pgsql-admin(at)postgresql(dot)org
Subject: Re: ssl database connection problems...
Date: 2008-12-30 03:13:12
Message-ID: 7716.1230606792@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> writes:
> On Mon, Dec 29, 2008 at 2:23 PM, Carol Walter <walterc(at)indiana(dot)edu> wrote:
>> ... I can't connect to the database instance
>> from a remote host. I get a message as follows:
>> walterc(at)cat:~$ psql -h db -U walterc -d walterc -p 5433
>> psql: could not connect to server: Connection refused
>> Is the server running on host "db" and accepting
>> TCP/IP connections on port 5433?

> What does listen_addresses say in postgresql.conf for this instance?

If listen_addresses is set properly, another thing to check is whether
there is a firewall blocking connections to 5433 at the kernel or
network level.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Iñigo Martinez Lasala 2008-12-30 11:02:36 Context-switch storm in 8.1.15
Previous Message Ray Stell 2008-12-30 02:36:30 Re: ssl database connection problems...