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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

[no subject]



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



  • Follow-Ups:
    • Re:
      • From: Paul Thomas
    • Re:
      • From: Karsten Hilbert

Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group