On 05/05/2016 01:40 PM, rob stone wrote:
Hello John,On Wed, 2016-05-04 at 21:43 -0700, John R Pierce wrote:
On 5/4/2016 1:55 PM, rob stone wrote:
I can connect via psql and issue queries without any problems.
Trying
to connect via JDBC fails. Trying to connect by an application
fails.
one potential difference, psql will connect via a unix domain socket
if you don't specify a -h hostname, while JDBC can only connect via
a tcp socket. jdbc connecting to localhost will match `host`
lines in the pg_hba.conf file, while psql connecting without a host
specification will match `local` line(s).
so, please show us your jdbc connection string, and your psql command
line, and also show us your pg_hba.conf file.
Yes, I'm aware of the difference.
The pg_hba.conf file has a date of Feb 24, 2016. This problem occurred
due to me deleting packages via synaptic a few days ago.
I've also just discovered that the resolv.conf file was wacked. So it
has to have something to do with the network stack. No clues in syslog,
just the message in the Postgres log about not starting autovacuum when
it is supposed to start that process and always has up until now.
Exactly. Showing the list the error you get when you cannot connect help
may with solving that problem and save you a great of time. What have
you got to lose?
Cheers,
rob
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
