Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to connect to remote instance?

How to connect to remote instance?

From
Jim Moon
Date:
Hello.

postgresql 8.3

pg_hba.conf includes:
host     all     all     0.0.0.0/0     md5

postgresql.conf includes:
listen_addresses = '*'

Attempts to connect from remote pgAdmin III result in:
Access to database denied
The server doesn't grant access tothe database: the server reports
FATAL: no pga_hba.conf entry for host "<xx.xx.xxx.xx>", user "postgres", database "postgres", SSL off
...

Thank you in advance for any ideas!

Jim


Re: How to connect to remote instance?

From
Andrej
Date:
On 4 April 2012 02:53, Jim Moon <moonjamesg@gmail.com> wrote:
> pg_hba.conf includes:
> host     all     all     0.0.0.0/0     md5
>

The file gets evaluated top to bottom.

Any chance a previous record matches your clients IP but
doesn't allow for all users?

Re: How to connect to remote instance?

From
Jim Moon
Date:
>The file gets evaluated top to bottom.

>Any chance a previous record matches your clients IP but
>doesn't allow for all users?

Using only:
            host	 all	 all	 0.0.0.0/0	 md5
and reloading the conf files:
            SELECT pg_reload_conf();
the refused connection issue persists.

Re: How to connect to remote instance?

From
Tom Lane
Date:
Jim Moon <moonjamesg.groups@gmail.com> writes:
> Using only:
>             host     all     all     0.0.0.0/0     md5
> and reloading the conf files:
>             SELECT pg_reload_conf();
> the refused connection issue persists.

I wonder whether the postmaster is using the pg_hba file you think it is.
You might try "show hba_file;" to confirm that.

            regards, tom lane

Re: How to connect to remote instance?

From
Jim Moon
Date:

> I wonder whether the postmaster is using the pg_hba file you think it is.
> You might try "show hba_file;" to confirm that.                     

Yes.  That is the issue.  Thanks a lot, you guys.