Re: Connecting to the database server

On 12/01/2008, LWATCDR <lwatcdr(at)gmail(dot)com> wrote:
> Thanks I did move on to pg_hba.conf but no joy yet.
> I turned off ipchains since this box is inside our firewall and I am
> just testing for now.
> I added these lines to pg_hba.conf and restarted postgres
> host all all 192.168.100.0/24 ident sameuser
> host phone all 192.168.100.0/24 trust
>
>
>
> I now get a message saying that the server terminated this connection
> unexpectedly.
> Any ideas?
I'd start at the *simple* end. Can you connect from the
command line with psql? What other lines have you got
in pg_hba.conf?

Sameuser only makes sense if a) the user account name is
the same for both the os and postgres and b) ident is actually
set-up and running. Also, if you're working on the same machine
the IP stack will be trying to either use Unix sockets or the
loopback interface before trying the IP address.

Cheers,
Andrej