Обсуждение: How to connect to remote instance?
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!
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
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?
>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.
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
> 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.