Re: [GENERAL] Help with remote connection to remote Postgresql 8.3 Server...

2008-05-29 Thread Dave Page 
On Wed, May 28, 2008 at 10:17 PM, hobbes [EMAIL PROTECTED] 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-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Help with remote connection to remote Postgresql 8.3 Server...

2008-05-29 Thread hobbes 
On May 29, 4:45 pm, [EMAIL PROTECTED] (Dave Page) wrote:
 On Wed, May 28, 2008 at 10:17 PM, hobbes [EMAIL PROTECTED] 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 ([EMAIL PROTECTED])
 To make changes to your 
 subscription:http://www.postgresql.org/mailpref/pgsql-general

Yes. Typo. pgadmin III

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

Re: [GENERAL] Help with remote connection to remote Postgresql 8.3 Server...

2008-05-28 Thread Tom Lane 
hobbes [EMAIL PROTECTED] 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

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

Re: [GENERAL] Help with remote connection to remote Postgresql 8.3 Server...

2008-05-28 Thread hobbes 
On May 29, 5:17 am, hobbes [EMAIL PROTECTED] 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  DATABASEUSERCIDR-ADDRESS  METHOD
 # local is for Unix domain socket connections only
 local   all postgrestrust
 local   all all md5

 # IPv4 local connections:
 hostall all 0.0.0.0/0 md5
 hostssl all all 0.0.0.0/0   md5

 # IPv6 local connections:
 hostall 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!

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