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.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)