Re: Accessing PostgreSQL from a remote host ? - Mailing list pgsql-novice

From Stéphane Pinel
Subject Re: Accessing PostgreSQL from a remote host ?
Date
Msg-id 1FADF120-4064-11D7-B533-000A27AFF5D2@noos.fr
Whole thread Raw
In response to Re: Accessing PostgreSQL from a remote host ?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Accessing PostgreSQL from a remote host ?
List pgsql-novice
Le vendredi, 14 fév 2003, à 21:40 Europe/Paris, Josh Berkus a écrit :

> Stephane,
>
>> As a newbie, I would like to know exactly what I have to
>> do (and how) (on the server) in order to get a running connection to
>> my
>> PostgreSQL database from a remote host (using a GUI
>> client).
>>
>> I'm going to get mad since I've tried everything I could
>> read about this topic without any success for hours ;-)
>>
>> MacOS X 10.2.4
>> PostgreSQL 7.3 (Marc Liyanage package)
>
> It's easy:
>
> 1) Change your postgresql.conf file (which should be in Postgres' data
> directory)  so that the option reads:
> tcpip_socket = true

OK. I've looked at this file and I saw that every line start with a
'#'. To my understanding
(approximatively nothing), this is a "comment" tag ? Should I rename:
"#tcpip_socket = true"
to
"tcpip_socket = true" ?

>
> 2) Modify your pg_hba.conf file to allow connections from the host
> from which
> you are trying to connect.
>
> 3) Restart PostgreSQL

Should I need to restart with the option -i ?

>
> 4) Configure your remote client to look to your database host to
> connect with
> the authentication method you indicated in 2.

Right.

Thank you very much

------------------------------------------------------------------------
---
Stéphane
iChat/AIM: s.pinel
------------------------------------------------------------------------
---


pgsql-novice by date:

Previous
From: Adam Bultman
Date:
Subject: Importing Postgres 7.1.1 DBs into Postgres 7.3.2
Next
From: Josh Berkus
Date:
Subject: Re: Accessing PostgreSQL from a remote host ?