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 по дате отправления: