Re: Remote Access to pgsql DB ???

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(dot)brett(at)e-mis(dot)com]
Sent: Monday, December 10, 2001 8:02 AM
To: pgsql-general(at)postgresql(dot)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(at)tecways(dot)com> wrote in message
news:3C0CDF34(dot)CC972E7C(at)ccs-munich(dot)de(dot)(dot)(dot)
> 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(at)postgresql(dot)org)

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)