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

Re: [INTERFACES] Re: connecting: unix socket? Yes. TCPIP port? No.-i? Yes.

From: Bob VonMoss <bvonmoss(at)bigfoot(dot)com>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Re: connecting: unix socket? Yes. TCPIP port? No.-i? Yes.
Date: 1999-02-08 07:33:44
Message-ID: 36BE9358.FA5952BE@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
Peter T Mount wrote:

> On Sun, 7 Feb 1999, Bob VonMoss wrote:
>
> > Tom Lane wrote:
> >
> > > Bob VonMoss <bvonmoss(at)bigfoot(dot)com> writes:
> > > > [ can connect via unix socket, but not via TCP ]
> > >
> > > > The administrator says this is how postmaster is invoked:
> > > > /usr/local/pgsql/bin/postmaster -S -i -D /usr/local/pgsql/data -p 5432
> > >
> > > OK, that eliminates the "forgot -i" gotcha.
> > >
> > > James Thompson is almost certainly right that the problem is that
> > > Postgres' pg_hba.conf file is not set up to allow connections from
> > > whichever IP address you are connecting from.
> > >
> > > We heard about a similar problem recently which turned out to be
> > > due to use of "virtual server" IP addresses.
> >
> > The pgsql administrator put a line in pg_hba.conf that looks like this,
> > where my_db is substituted for my database name:
> >
> > host my_db 0.0.0.0 0.0.0.0 ident sameuser
> >
> > I'm still getting the same 'User authentication failed' messages. Same thing
> > from JDBC.
> Is the machine you are running the java app or psql on running ident?

Not that I know of. I'm requesting this from the administrator:

host my_db 0.0.0.0 0.0.0.0 password sameuser

--
Bob VonMoss
mailto:bvonmoss(at)bigfoot(dot)com
from Chicago, IL



In response to

Responses

pgsql-interfaces by date

Next:From: Claudius du PlessisDate: 1999-02-08 09:08:44
Subject:
Previous:From: Peter T MountDate: 1999-02-08 06:49:04
Subject: Re: [INTERFACES] Re: connecting: unix socket? Yes. TCPIP port? No. -i? Yes.

pgsql-general by date

Next:From: Karl EichwalderDate: 1999-02-08 08:13:20
Subject: Re: Client Installation
Previous:From: Peter T MountDate: 1999-02-08 06:49:04
Subject: Re: [INTERFACES] Re: connecting: unix socket? Yes. TCPIP port? No. -i? Yes.

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