Help with remote connection to remote Postgresql 8.3 Server...

hobbes <calvin.cheng@od-eon.com> writes:

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.

What exactly happens when you try?

A reasonable guess is that you need to poke a hole in your firewall,
but the specific error you are getting would help to confirm or
disprove that theory.

regards, tom lane

On May 29, 5:17 am, hobbes <calvin.ch...@od-eon.com> wrote:

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

It was a firewall issue. Using iptables to unblock it worked.

Thanks!

On Wed, May 28, 2008 at 10:17 PM, hobbes <calvin.cheng@od-eon.com> wrote:

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.

Is that a typo? pgAdmin II hasn't been supported in years and will
almost certain barf on 8.3.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

On May 29, 4:45 pm, dp...@pgadmin.org ("Dave Page") wrote:

On Wed, May 28, 2008 at 10:17 PM, hobbes <calvin.ch...@od-eon.com> wrote:

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.

Is that a typo? pgAdmin II hasn't been supported in years and will
almost certain barf on 8.3.

--
Dave Page
EnterpriseDB UK:http://www.enterprisedb.com

--
Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

Yes. Typo. pgadmin III