From: "Daniel E(dot) Fisher" <danfisher(at)bwkip(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject:
Date: 2003-06-25 14:46:11
Message-ID: BEELKEGKMIBCEMJEAOMEGEBLCCAA.danfisher@bwkip.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Re: at 2003-06-25 15:13:37 from Karsten Hilbert
  • Re: at 2003-06-25 15:53:53 from Paul Thomas

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-06-25 14:48:11 Re: Inheritance & Indexes
Previous Message Tom Lane 2003-06-25 14:44:11 Re: Alternative replication method.