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 Access t...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 3128 of 3323
Post > Topic >>

Remote Access to Remote Postgresql Server

by hobbes <calvin.cheng@[EMAIL PROTECTED] > May 28, 2008 at 02:16 PM

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)
****t = 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...
 




 1 Posts in Topic:
Remote Access to Remote Postgresql Server
hobbes <calvin.cheng@[  2008-05-28 14:16:54 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan12V112 Fri Dec 5 5:26:57 CST 2008.