connect to database over network

From: aa nn <bmewang(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: connect to database over network
Date: 2003-04-10 17:27:33
Message-ID: 20030410172734.99018.qmail@web20606.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Hi,

I am trying to connect to the PostgreSQL 7.3.1 database running on RH-Linux 8. I already compiled my psql program on my Win XP. When I run the followig command:

psql -h synapse.xxx.xxx.xxx -d myDatabse -U postgres

I got the error message as below:

psql: could not connect to server: Connection reset by peer (0x00002746/10054)
Is the server running on host synapse.xxx.xxx.xxx and accepting
TCP/IP connections on port 5432?

The thing is that I started the postermaster with -i option and I already added my client PC's IP to the pg_hba.conf. Also, I can ping synapse.xxx.xxx.xxx without any problem. Any suggestions? Thanks.

Wei

---------------------------------
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Doug Silver 2003-04-10 17:56:18 Data types mapping
Previous Message Himmet Karaman 2003-04-10 13:06:23 PLEASE HELP ME URGENT about choosing only the ones that i want while entering the data to postgresql with pgaccess on linux or windows or pgadmin II