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...
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 |