On Thursday 11 September 2003 21:42, N.K. wrote:
> Hi, I've just installed postgres on the Linux server. It is supposed
> to start automatically which I think it does since I can run an sql
> stmt right away. When I'm trying to connect from a remote machine I
> get a message that the remote machine IP address is not specified in
> pg_hba.conf, that there is no record of that machine there.
> ph_hba.conf is set up correctly, because when I run the following:
> postmaster -i -D /var/lib/pgsql/data
> from the command line, I'm able to easily connect to postgre from the
> remote machine.
> What's the deal here? It's probably how postgres is started.
>
> here is my startup script:
Assuming this is the startup script that ships with PG, you probably want to
look in your postgresql.conf file and check the tcp_ip setting is on.
--
Richard Huxton
Archonet Ltd