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

Поиск
Список
Период
Сортировка
Искать
От
hobbes
Тема
Help with remote connection to remote Postgresql 8.3 Server...
Дата
в 19:31:55
Msg-id
c6ca4b7b-e695-4285-9e6f-ea617e33f74b@a9g2000prl.googlegroups.com
Список
Дерево обсуждения
Re: Help with remote connection to remote Postgresql 8.3 Server... hobbes <calvin.cheng@od-eon.com>
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...
В списке pgsql-general по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ