Re: [GENERAL] Re: No pg_hba.conf entry ??? - Mailing list pgsql-general

From Jim Mercer
Subject Re: [GENERAL] Re: No pg_hba.conf entry ???
Date
Msg-id 20000221131336.S365@reptiles.org
Whole thread Raw
In response to Re: No pg_hba.conf entry ???  ("Paulo Parola" <pgsql@brazilinfo.com>)
List 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@reptiles.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.  ]

pgsql-general by date:

Previous
From: "Paulo Parola"
Date:
Subject: Re: No pg_hba.conf entry ???
Next
From: "Robert Esser"
Date:
Subject: Problems using Postgres-ODBC-Borland BDE