Re: Remote Access to pgsql DB ???

In article <3C0CDF34.CC972E7C@ccs-munich.de>, "Fariba Noorbakhsh"
<fNoorbakhsh@tecways.com> wrote:

> 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'?
>
This suggests that psql is trying to connect to a local postmaster. The
-h option to psql tells it which host to connect to. In your case:

psql -h orion mydb

should do what you want.

Regards

John
--
John Gray
Azuli IT    http://www.azuli.co.uk      +44 121 693 3397
jgray@azuli.co.uk