Remote Access to pgsql DB ???

From: Fariba Noorbakhsh <fNoorbakhsh(at)tecways(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Remote Access to pgsql DB ???
Date: 2001-12-04 14:35:32
Message-ID: 3C0CDF34.CC972E7C@ccs-munich.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brent Verner 2001-12-04 14:44:10 Re: Remote Access to pgsql DB ???
Previous Message James Thornton 2001-12-04 13:29:23 Re: update returns 1, but no changes have been made