Re: How to connect to a remote database

Hi,

this is probably not a bug.

with psql you have to use the -h option

e.g.: psql -h mypgserver.mydomain [mydatabase]

and on mypgserver.mydomain computer you have to launch postgresql with
the -i option, telling it to listen for TCP/IP connections, and check
pg_hba.conf for possible restricitions.

bye,

Jerome ALET - alet(at)unice(dot)fr - http://cortex.unice.fr/~jerome
Faculte de Medecine de Nice - http://noe.unice.fr - Tel: 04 93 37 76 30
28 Avenue de Valombrose - 06107 NICE Cedex 2 - FRANCE

On Thu, 7 Sep 2000 pgsql-bugs(at)postgresql(dot)org wrote:

> Martin Kuria (martinkuria(at)hotmail(dot)com) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> How to connect to a remote database
>
> Long Description
> This may be a dumb question, but how do I connect to a remote database
> using postgresql, or rather psql?
>
> I have trouble connecting to the remote host, to access the database what command should use to connect to the database in remote host in the prompt, Thanks again.
>
> Thanks
>
> Martin
>
>
>
> Sample Code
>
>
> No file was uploaded with this report
>