Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSQL tcp connection

PostgreSQL tcp connection

From
Lonnie Cumberland
Date:
Hello,

I have installed PostgreSQL 7.0.3 on my Mandrake 7.2 Linux system and
have been trying to get it to listen for TCP connectins.

I added the "-i" command to the /etc/init.d/postgresql script, but still
it does not seem to accept any connections. I can make local
connections, but need to be able to have the database on one machine and
my webserver database connection application on another machine.

Is there something that I have not done correctly and could you please
tell me how to get this working?

Best Regards,
Lonnie Cumberland

Re: PostgreSQL tcp connection

From
Peter T Mount
Date:
Quoting Lonnie Cumberland <Lonnie_Cumberland@yahoo.com>:

> Hello,
>
> I have installed PostgreSQL 7.0.3 on my Mandrake 7.2 Linux system and
> have been trying to get it to listen for TCP connectins.
>
> I added the "-i" command to the /etc/init.d/postgresql script, but still
>
> it does not seem to accept any connections. I can make local
> connections, but need to be able to have the database on one machine and
>
> my webserver database connection application on another machine.
>
> Is there something that I have not done correctly and could you please
> tell me how to get this working?

Have you configured the pg_hba.conf file on the server to allow the remote IP
address access?

Peter

--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/