Thread:
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
> 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 Well, you of course need to replace "machine's.ip" with the actual IP. You did do that and just edited it out for posting on the list, right ? Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
On 25/06/2003 15:46 Daniel E. Fisher wrote: > 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. If You're using PG 7.3, then you need a user column: host database(or all) user(or all) the.machine's.ip.address 255.255.255.255 > > 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. > Depends on which *nix flavour/distribution you're using. I use Red Hat Linux and service postgresql restart works for me. HTH -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+
Instead of "the.machine's.ip.address" can you try with localhost or mention the machine's ip address explicitly. To effect the changes in the configuration you do not have to restart the server run this command : pg_ctl reload you will get a message : postmaster successfully signaled Hope this works.... Regards, Kallol. -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Paul Thomas Sent: Wednesday, June 25, 2003 9:24 PM To: pgsql-general @ postgresql . org Subject: Re: [GENERAL] On 25/06/2003 15:46 Daniel E. Fisher wrote: > 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. If You're using PG 7.3, then you need a user column: host database(or all) user(or all) the.machine's.ip.address 255.255.255.255 > > 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. > Depends on which *nix flavour/distribution you're using. I use Red Hat Linux and service postgresql restart works for me. HTH -- Paul Thomas +------------------------------+-------------------------------------------- -+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+-------------------------------------------- -+ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match