- Mailing list pgsql-general

From Daniel E. Fisher
Subject
Date
Msg-id BEELKEGKMIBCEMJEAOMEGEBLCCAA.danfisher@bwkip.com
Whole thread Raw
Responses Re:  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Re:  (Paul Thomas <paul@tmsl.demon.co.uk>)
List pgsql-general
Entered in the pg_hba.conf file

host    all    the.machine's.ip.address 255.255.255.255
and still gives me the error that it doesn't have an entry for the servers
ip.

Warning: Unable to connect to PostgreSQL server: FATAL: No pg_hba.conf entry
for host "machine's.ip" user postgres, database nm in
/var/www/html/crohns/phpBB2/db/postgres7.php on line 79
phpBB : Critical Error

Could not connect to the database

I would also like to know how to restart postmaster to reinitialize changes
if someone could help me out on that.


in need of help,
Dan

<snip>
> This is in the pg_hba.conf file
>
> www.websiteIamusing.com   all   themachine'sIP   255.255.255.255
> trust
>
> I am sure I need to edit something yet.

"host" is a keyword (for tcp/ip connections as opposed to keyword
"local" for local domain socket connections), it is not a hostname.
Try:
host all the.machine.ip.address 255.255.255.255

Cheers,
Steve


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Alternative replication method.
Next
From: Stephan Szabo
Date:
Subject: Re: Inheritance & Indexes