Обсуждение: Connecting to a PostgreSQL Server remotely
Hi! I had a few questions. I've postgresql 8.1 setup on a desktop which is occasionally behind a VPN, running a server. I've a laptop running 8.1 as well, with which I'd like to be able to access the server. I've attempted to change the listen_addresses parameter to '*' and then reloaded with pg_ctl reload; however, I still get a "server doesn't listen" error. I'm using pgAdmin III, and I was hoping someone might be able to help me out? Thanks a bunch! Gratefully, a.
Even I'm facing the same problem.
In postgresql.conf,i changed the listen address to *, also i enabled all the tcp options so that when i Exectute the statement EXEC SQL CONNECT TO 'tcp:postgresql://[ip address]:5432/dbname [user name and password] the tcp connection is established but i always get -402 sqlcode meaning that the connection is not established.
Thanks,
~Jas
On 8/3/06, Alec Resnick <aresnick@mit.edu> wrote:
Hi! I had a few questions. I've postgresql 8.1 setup on a desktop
which is occasionally behind a VPN, running a server. I've a laptop
running 8.1 as well, with which I'd like to be able to access the
server. I've attempted to change the listen_addresses parameter to
'*' and then reloaded with pg_ctl reload; however, I still get a
"server doesn't listen" error. I'm using pgAdmin III, and I was
hoping someone might be able to help me out?
Thanks a bunch!
Gratefully,
a.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match