Help with remote connection to remote Postgresql 8.3 Server... - Mailing list pgsql-general

From hobbes
Subject Help with remote connection to remote Postgresql 8.3 Server...
Date
Msg-id c6ca4b7b-e695-4285-9e6f-ea617e33f74b@a9g2000prl.googlegroups.com
Whole thread Raw
Responses Re: Help with remote connection to remote Postgresql 8.3 Server...  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Help with remote connection to remote Postgresql 8.3 Server...  ("Dave Page" <dpage@pgadmin.org>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Psql crashes with Segmentation fault on copy from
Next
From: Tom Lane
Date:
Subject: Re: Help with remote connection to remote Postgresql 8.3 Server...