Re: - Mailing list pgsql-general

From Paul Thomas
Subject Re:
Date
Msg-id 20030625165353.A11885@bacon
Whole thread Raw
In response to  ("Daniel E. Fisher" <danfisher@bwkip.com>)
Responses Re:
List pgsql-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   |
+------------------------------+---------------------------------------------+

pgsql-general by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: Physical Database Configuration
Next
From: Fernando Schapachnik
Date:
Subject: Re: Physical Database Configuration