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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-12 00:14:57 | Re: max_connections, solaris semaphores and initdb |
Previous Message | Andrej Ricnik-Bay | 2008-01-11 21:04:10 | Re: Connecting to the database server |