Re: Peer authentication problem in CGI-Perl - Mailing list pgsql-novice

From Oliver Elphick
Subject Re: Peer authentication problem in CGI-Perl
Date
Msg-id 1013646959.13853.2283.camel@linda
Whole thread Raw
In response to Re: Peer authentication problem in CGI-Perl  (Mo Holkar <pgsql@digitalmindgames.com>)
List pgsql-novice
On Wed, 2002-02-13 at 18:09, Mo Holkar wrote:
> Hi there,
>
> Are you running the Postgres postmaster with -i, to allow remote
> connections? -- and is your pg_hba.conf
> file edited so as to allow connections from the IP address you're using?

That's not relevant. "peer" authentication is only used (in the Debian
packages) for connecting on the same machine through a Unix socket.

> Even if it's your local machine you're testing on, you have to have
> Postgres set up to allow TCP/IP connections if you want to test CGI
> scripts. (At least, I think that's right: please do correct me, anyone who
> knows different.)

It doesn't sound right.  The remote end connects through TCP/IP to the
server which runs the CGI script.  If the CGI script is running on the
same machine as the database, it does not itself need to use a TCP/IP
connection.

A TCP/IP connection _to_PostgreSQL_ would allow you to run a process on
one machine and directly query a PostgreSQL server on another, but
that's not the same thing.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "The earth is the LORD'S, and the fullness thereof; the
      world, and they that dwell therein."
                                   Psalms 24:1


pgsql-novice by date:

Previous
From: "Patrick Hatcher"
Date:
Subject: Re: Function Hangs
Next
From: Oliver Elphick
Date:
Subject: Re: Peer authentication problem in CGI-Perl