Re: Debian and Postgres

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(dot)klaver(at)aklaver(dot)com