Re: Connect to PostgreSQL using TCP/IP

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(at)cybercable(dot)fr>
Date: Fri, 19 Jul 2002 01:07:16 +0200
To: <pgsql-novice(at)postgresql(dot)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(at)noos(dot)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