strange connection problem.

From: "Day, David" <dday(at)redcom(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: strange connection problem.
Date: 2015-10-23 14:29:39
Message-ID: 401084E5E73F4241A44F3C9E6FD79428011C3FA455@exch-01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a development site ( FreeBSD 10.1 and Postgres 9.3 ) where I can connect to the database via psql or pgadminIII both locally and remotely.
However, all of the local apps ( 3 different ones ) that would connect to it are failing to connect.

I see no error events in the messages/postgres log files related to bad attempts.
I suspect something with name resolution,
The hosts, hosts.conf and resolv.conf files are set to resolv first via the hosts file
And the hostname and localhost are properly defined there.

The site installation did have some initial DNS setup issues. However this command works fine locally.
"psql -U <role> -h <hostname> database.
i.e. name resolution works locally fine for psql.

The problem does not go away on shutting down and starting up the system ( Virtual Machine )

Is there anything on the postgres side that might explain this situation ?

Will likely re-install and see if the problem goes away. ( build of the day problem ? )
It is an interesting puzzle at the moment.

Thanks

Dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yves Dorfsman 2015-10-23 14:34:48 Re: strange connection problem.
Previous Message Dane Foster 2015-10-23 01:52:56 Re: A question about PL/pgSQL DECLAREd variable behavior