I think you can.
I have a linux node named BETALIN and another linux node that has the
database on it named ARCHER.
I log into BETALIN and at the command prompt I run:
psql databasename -U username --host=archer
I also use pgadmin to access the database from a Windows machine (this uses
ODBC)
Make sure you have the ip's set correctly in pg_hba.conf
-----Original Message-----
From: Steve Brett [mailto:steve.brett@e-mis.com]
Sent: Monday, December 10, 2001 8:02 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Remote Access to pgsql DB ???
i don't know if you can use psql to connect to remote servers - in fact i
think you can't.
try connecting from omega using a tool such as pgaccess in xwindows and you
should be fine or telnet or ssh onto the orion box from omega and run psql
from there i use IVT-TELNET for this at work.
Steve
"Fariba Noorbakhsh" <fNoorbakhsh@tecways.com> wrote in message
news:3C0CDF34.CC972E7C@ccs-munich.de...
> Hi,
>
> I have a question about remote access to Pgsql DB. I acctually want to
> access mydb which located on a Unix server called ORION from another
> Unix server called OMEGA.
>
> According to documentation I have to run postmaster on ORION with -i
> option like:
>
> /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data &
>
> so I have done that, I also changed pg_hba.conf on ORION for OMEGA
> IP address like:
>
> host all 172.21.2.41 255.255.255.255 trust
>
> But still I can not run psql mydb from Omega:
>
> psql: connectDBStart() -- connect() failed: Connection refused
> Is the postmaster running locally
> and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
>
> Why should I get this error when I have run postmaster with -i on
> ORION?
>
> Shall I run that on OMEGA as well, then it's not a remote access?!!!
>
> I appreciate your help!
>
> Thanks in advance,
> Fariba
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)