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.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2008-01-12 00:14:57|
|Subject: Re: max_connections, solaris semaphores and initdb |
|Previous:||From: Andrej Ricnik-Bay||Date: 2008-01-11 21:04:10|
|Subject: Re: Connecting to the database server|