Skip site navigation (1) Skip section navigation (2)

Help with remote connection to remote Postgresql 8.3 Server...

From: hobbes <calvin(dot)cheng(at)od-eon(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Help with remote connection to remote Postgresql 8.3 Server...
Date: 2008-05-28 21:17:52
Message-ID: c6ca4b7b-e695-4285-9e6f-ea617e33f74b@a9g2000prl.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi Guys,

I have been trying to get my local (windows) machine's PgAdmin II to
connect directly to a remote Linux (Debian) Server where Postgresql
8.3 is installed.

I have set in my postgresql.conf (remote):

listen_addresses = '*'    		# what IP address(es) to listen on;
					# comma-separated list of addresses;
					# defaults to 'localhost', '*' = all
					# (change requires restart)
port = 5432				# (change requires restart)
max_connections = 100			# (change requires restart)

and set in my pg_hba.conf (remote):

# TYPE  	DATABASE	USER        CIDR-ADDRESS          METHOD
# "local" is for Unix domain socket connections only
local   	all         	postgres				trust
local   	all         	all                               	md5

# IPv4 local connections:
host		all     	all		0.0.0.0/0     md5
hostssl	all		all		0.0.0.0/0 	md5

# IPv6 local connections:
host    	all 	        all         	::1/128           	md5

But I am still unable to connect to the server using the "postgres"
user.
Could some one enlighten me what I could be doing wrongly?

Thanks...

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2008-05-28 22:44:24
Subject: Re: Help with remote connection to remote Postgresql 8.3 Server...
Previous:From: Tom LaneDate: 2008-05-28 20:42:53
Subject: Re: Psql crashes with Segmentation fault on copy from

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group