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