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

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

[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

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

[hobbes]

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

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