From: Joe Dieckert <dieckert@cabnet.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] cant connect
Date: Tue, 13 Apr 1999 00:35:04 -0700
Message-ID: <3712F3A8.3FE8527D@cabnet.net> (raw)
References: <12537.923845132@sss.pgh.pa.us>
Thanks!! That took care of it.
Joe
Tom Lane wrote:
> Joe Dieckert <dieckert@cabnet.net> writes:
> > The backend start okay and we can access the data on the local machine
> > runing psql but cannont on another machine on the same net. We tried
> > adding PAM modules and adding the tcp port to the services files. We
> > tried to log in as many different users but it just keeps telling us on
> > the remote and local machine that authenication has failed.
>
> Sounds like the pg_hba.conf file on the server machine is not set up
> to allow access from anywhere except that same machine. It has to
> contain an entry matching the IP address of the machine you want to
> connect from. See the administrator documentation, or check the
> archives of this list --- I recall the same problem being discussed
> just a week or two back.
>
> regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: dieckert@cabnet.net, tgl@sss.pgh.pa.us
Subject: Re: [INTERFACES] cant connect
In-Reply-To: <3712F3A8.3FE8527D@cabnet.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox