Skip site navigation (1) Skip section navigation (2)

Re: Host IP

From: tuan <nguyen_a(at)cnam(dot)fr>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Host IP
Date: 2000-08-25 15:32:17
Message-ID: 39A69181.57343531@cnam.fr (view raw or flat)
Thread:
Lists: 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 (,,)
   ===\[_]/===
    ¤-((_))-¤

In response to

  • Host IP at 2000-08-23 18:22:30 from Fredrick Bartlett

pgsql-novice by date

Next:From: Windy ElliottDate: 2000-08-25 16:12:53
Subject: help
Previous:From: Anthony E . GreeneDate: 2000-08-24 22:28:28
Subject: Re: Host IP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group