Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > Remote / networ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 9 Topic 3077 of 3215
Post > Topic >>

Remote / network connection fails

by nils.zierath@[EMAIL PROTECTED] (Nils Zierath) Apr 16, 2008 at 07:05 PM

Dear list,
I am trying to connect to my database over the network. When trying to
connect to the 
server from a Windows client via psql with

#-> psql -h pg_server_ip -d postgres -U postgres OR
#-> psql -h pg_server_ip -d cms -U cmsuser

I get the following error (same with pgAdmin3)

psql: could not connect to server: Connection refused (0x0000274D/10061)
	Is the server running on host "pg_server_ip" and accepting
	TCP/IP connections on ****t 5432?

****
- I am using PostgreSQL 8.3 on Debian Etch.
- The server is up and running on host "pg_server_ip" on ****t 5432.
- The Postgres server process is running as UNIX user 'postgres'.
- I can connect to the postgres-server locally via PSQL.
- A CMS is running fine with a Postgres data base 'cms' as backend on the
same machine.
- I changed 'listen_address' to '*' in postgresql.conf
- iptables allows connections on ****ts 22, 80 and 5432.
- pg_hba.conf looks as follows:

#	LOCAL CONNECTIONS
	local	all	postgres		ident	sameuser
	local	all	cmsuser			md5
	local	all	all			ident	sameuser

#       IPv4
#	TYPE	DBASE	USER	CIDR-ADDRESS	METHOD	[OPTION]
         host	all	all	131.220.0.0/16	md5
         host	all	all	127.0.0.1/32	md5

- I restarted the Postgres server process / reloaded the config files
after modification.

Since the CMS with 'cmsuser' is running fine, I suspect it is connecting
locally. What do 
I have to change at the IPv4 connections?

Thanks in advance,
Nils

-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
 




 9 Posts in Topic:
Remote / network connection fails
nils.zierath@[EMAIL PROTE  2008-04-16 19:05:51 
Re: Remote / network connection fails
andrej.groups@[EMAIL PROT  2008-04-17 09:38:04 
Re: Remote / network connection fails
nils.zierath@[EMAIL PROTE  2008-04-18 10:36:11 
Re: Remote / network connection fails
andrej.groups@[EMAIL PROT  2008-04-19 07:56:49 
Re: Remote / network connection fails
nils.zierath@[EMAIL PROTE  2008-04-21 12:21:20 
Re: Remote / network connection fails
tgl@[EMAIL PROTECTED] (T  2008-04-21 10:36:11 
Re: Remote / network connection fails
nils.zierath@[EMAIL PROTE  2008-04-22 11:41:49 
Re: Remote / network connection fails
andrej.groups@[EMAIL PROT  2008-04-22 21:36:50 
Re: Remote / network connection fails
nils.zierath@[EMAIL PROTE  2008-04-22 14:46:03 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun Sep 7 6:57:04 CDT 2008.