Thread

1. Host IP

   Fredrick Bartlett <palmtreefrb@earthlink.net> — 2000-08-23T18:22:30Z

   Hello,  List!
   
   How can I connect to the remote PostgresSQL host using IP address,  not
   host name.
   
   Fredrick
   
   
   

2. Re: Host IP

   Anthony E . Greene <agreene@pobox.com> — 2000-08-24T22:28:28Z

   On 23 Aug 2000 14:22 Fredrick Bartlett wrote:
   >How can I connect to the remote PostgresSQL host using IP address,  not
   >host name.
   
   If you can't figure out anything else, make up a name and add an entry in
   your own hosts file (normally /etc/hosts) that points to the remote server.
   
   -- 
   Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/>
   PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
   Linux. The choice of a GNU Generation. <http://www.linux.org/>
   
   

3. Re: Host IP

   tuan <nguyen_a@cnam.fr> — 2000-08-25T15:32:17Z

   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 (,,)
      ===\[_]/===
       ¤-((_))-¤