Re: jdbc pg_hba.conf error - Mailing list pgsql-general

From Tom Lane
Subject Re: jdbc pg_hba.conf error
Date
Msg-id 5646.1180546098@sss.pgh.pa.us
Whole thread Raw
In response to Re: jdbc pg_hba.conf error  (Oliver Elphick <olly@lfix.co.uk>)
Responses Re: jdbc pg_hba.conf error
List pgsql-general
Oliver Elphick <olly@lfix.co.uk> writes:
> His original message (which I snipped) said he had:

> # IPv4-style local connections:
> host    all         all         127.0.0.1         255.255.255.255   trust
> host    testing123  brakesh     127.0.0.1         255.255.255.255   trust

> So it seems to me he did have it configured.

I've seen similar problems resolved by discovering that (1) the DBA
was editing the wrong copy of the pg_hba.conf file, or (2) there was
actually more than one postmaster running on the machine.

Check "ps" for multiple postmasters.  Put a deliberate error in the
pg_hba.conf file and verify that the postmaster fails to restart.

            regards, tom lane

pgsql-general by date:

Previous
From: gonzales@linuxlouis.net
Date:
Subject: Re: jdbc pg_hba.conf error
Next
From: "Merlin Moncure"
Date:
Subject: Re: hundreds of schema vs hundreds of databases