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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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