Обсуждение: Help with remote connection to remote Postgresql 8.3 Server...

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

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