Re: [GENERAL] Re: No pg_hba.conf entry ???

From: Jim Mercer <jim(at)reptiles(dot)org>
To: Paulo Parola <pgsql(at)brazilinfo(dot)com>
Cc: pgsql-general <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Re: No pg_hba.conf entry ???
Date: 2000-02-21 18:13:36
Message-ID: 20000221131336.S365@reptiles.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 21, 2000 at 03:25:32PM -0300, Paulo Parola wrote:
> Even for the server with no domain name associated with it, shouldn't the
> line below be sufficient for connection to succeed???
>
> host all 127.0.0.1 255.255.255.255 trust

the address 127.0.0.1 is a "special" address meaning the local machine
(aka "localhost").

the above line will only work if the database and the scripts are on the
exact same machine.

if the database and the scripts are on different machines, then the scripts
need to open the database by specifying the name or address of the database
machine, and the database machine must have a pg_hba.conf entry listing the
address of the machine running the scripts.

--
[ Jim Mercer jim(at)reptiles(dot)org +1 416 506-0654 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paulo Parola 2000-02-21 18:25:32 Re: No pg_hba.conf entry ???
Previous Message Pete Bass 2000-02-21 17:04:06 Error using update