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)