ssl database connection problems...

From: Carol Walter <walterc(at)indiana(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: ssl database connection problems...
Date: 2008-12-29 21:23:30
Message-ID: 752F2E74-9F28-4E3D-869C-93357751AFA0@indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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:

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?

I know the server is running, so according to the message, it must not
be accepting TCP/IP connections on port 5433. I configured pg_port =
5433 and "with openssl" when I initially configured the server. Are
there other things that need to be done to get openssl started on the
database server? How can I diagnose this problem?

Carol

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2008-12-29 21:48:48 Re: ssl database connection problems...
Previous Message Tom Lane 2008-12-29 15:26:33 Re: rebellious pg stats collector (reopened case)