Re: Host IP - Mailing list pgsql-novice

From tuan
Subject Re: Host IP
Date
Msg-id 39A69181.57343531@cnam.fr
Whole thread Raw
In response to Host IP  (Fredrick Bartlett <palmtreefrb@earthlink.net>)
List pgsql-novice
Fredrick Bartlett wrote:
>
> Hello,  List!
>
> How can I connect to the remote PostgresSQL host using IP address,  not
> host name.
>
> Fredrick

provided you started the remote postmaster with -i option,simply
replace hostname by IP address :

/usr/local/pgsql/bin/psql -h xxx.xxx.xxx.xxx dbname

But remember previous posts :IP sockets less secure.(thanks for your
explanation,Gordon )

May be improved with ssh login to the host running the backend then run
psql or front-end programs from there ? Though doing this needs to set up an
user account on the server for every person allowed to connect to the
database .

How do you think ?

--
     /\   /\
    (  '''  )
    _(O)-(O)_
   (,,) Y (,,)
   ===\[_]/===
    ¤-((_))-¤

pgsql-novice by date:

Previous
From: "Anthony E . Greene"
Date:
Subject: Re: Host IP
Next
From: Assefa Yewondwossen
Date:
Subject: Postgres on NT