Help with remote connection to remote Postgresql 8.3 Server...
| От | hobbes |
|---|---|
| Тема | Help with remote connection to remote Postgresql 8.3 Server... |
| Дата | |
| Msg-id | c6ca4b7b-e695-4285-9e6f-ea617e33f74b@a9g2000prl.googlegroups.com обсуждение исходный текст |
| Ответы |
Re: Help with remote connection to remote Postgresql 8.3 Server...
Re: Help with remote connection to remote Postgresql 8.3 Server... |
| Список | 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...
В списке pgsql-general по дате отправления: