Re: Connecting to the database server

Actually I was trying to connect to phone which was set to trust.
I got it working so thank you everybody.
BTW it takes a really long time to restore the data.... A really long time :)


On Jan 11, 2008 4:04 PM, Andrej Ricnik-Bay <andrej.groups@gmail.com> wrote:
> On 12/01/2008, LWATCDR <lwatcdr@gmail.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
>