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

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 (view raw or flat)
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

pgsql-general by date

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

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