Hi Stéphane,
The two files you need to check are:
1. postgresql.conf
2. pg_hba.conf
In postgresql.conf, uncomment or add the following two lines:
tcpip_socket = true
port = 5432
Then in pg_hba.conf, you might need to add a line with the machine
(for example, 192.168.54.1) that you want to connect to the database:
host all 192.168.54.1 255.255.255.255 trust
Make sure to stop and restart the database to make these changes
take effect.
Derek
----- Original Message -----
From: Stéphane Pinel <spinel@cybercable.fr>
Date: Fri, 19 Jul 2002 01:07:16 +0200
To: <pgsql-novice@postgresql.org>
Subject: [NOVICE] Connect to PostgreSQL using TCP/IP
> I would like to know how and where I can configure stuff in order to process
> TCP/IP (localhost and distant clients) connections to PostgreSQL ?
>
> Is there somrthing to do with user privileges too ?
>
> Thanks.
>
> -------------------
> Stéphane Pinel
> spinel@noos.fr
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>
--
_______________________________________________
Get your free email from http://www.graffiti.net
Powered by Outblaze