Skip site navigation (1) Skip section navigation (2)

Re: ssl database connection problems...

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Carol Walter" <walterc(at)indiana(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: ssl database connection problems...
Date: 2008-12-29 21:50:38
Message-ID: dcc563d10812291350w51764ca5p76dad8628a5127c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, Dec 29, 2008 at 2:23 PM, Carol Walter <walterc(at)indiana(dot)edu> wrote:
> Hello,
>
> I've just created a new instance of postgres.  It's running an a Sun server
> running Solaris 10.  I configured it with ssl using port 5433.  The server
> starts and runs.  I can connect to it from the local host and list the
> databases, connect to them etc.  I can't connect to the database instance
> from a remote host.  I get a message as follows:

Are you connecting via unix sockets or tcp/ip sockets locally?

> 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?

In response to

Responses

pgsql-admin by date

Next:From: Ray StellDate: 2008-12-30 02:36:30
Subject: Re: ssl database connection problems...
Previous:From: Kevin GrittnerDate: 2008-12-29 21:48:48
Subject: Re: ssl database connection problems...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group