Skip site navigation (1) Skip section navigation (2)

Re: Connecting to the database server

From: LWATCDR <lwatcdr(at)gmail(dot)com>
To: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Connecting to the database server
Date: 2008-01-11 21:53:05
Message-ID: 8c38cea40801111353j5196fe38l1ed0ca873e95b629@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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(dot)groups(at)gmail(dot)com> wrote:
> 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
>

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2008-01-12 00:14:57
Subject: Re: max_connections, solaris semaphores and initdb
Previous:From: Andrej Ricnik-BayDate: 2008-01-11 21:04:10
Subject: Re: Connecting to the database server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group