Public bug reported:
I am trying to work remotely with Postgresql 9.1 and modified the file:
/var/lib/postgresql/9.1/main/pg_hba.conf to contain these setting:
local all all md5
host all all 127.0.0.1/32 md5
host all all 192.168.0.0/24 md5
host all all 192.168.0.102/32 md5
on using pgadmin III on windows to access my server, I get these error
messages in postgresql logs:
2011-12-30 22:45:21 EST FATAL: no pg_hba.conf entry for host "192.168.0.102",
user "postgres", database "postgres", SSL on
2011-12-30 22:45:21 EST FATAL: no pg_hba.conf entry for host "192.168.0.102",
user "postgres", database "postgres", SSL off
2011-12-30 22:46:00 EST FATAL: no pg_hba.conf entry for host "192.168.0.102",
user "postgres", database "postgres", SSL on
2011-12-30 22:46:00 EST FATAL: no pg_hba.conf entry for host "192.168.0.102",
user "postgres", database "postgres", SSL off
2011-12-30 22:46:24 EST FATAL: no pg_hba.conf entry for host "192.168.0.102",
user "postgres", database "postgres", SSL on
2011-12-30 22:46:24 EST FATAL: no pg_hba.conf entry for host "192.168.0.102",
user "postgres", database "postgres", SSL off
I have tried to tunnel the 5432 port from my server (ip address:
192.168.0.50) to the workstation (192.168.0.102) and it result in the
same error:
2011-12-30 22:48:19 EST FATAL: no pg_hba.conf entry for host "192.168.0.50",
user "postgres", database "postgres", SSL on
2011-12-30 22:48:19 EST FATAL: no pg_hba.conf entry for host "192.168.0.50",
user "postgres", database "postgres", SSL off
2011-12-30 22:48:40 EST FATAL: no pg_hba.conf entry for host "192.168.0.50",
user "postgres", database "postgres", SSL on
2011-12-30 22:48:40 EST FATAL: no pg_hba.conf entry for host "192.168.0.50",
user "postgres", database "postgres", SSL off
on the other hands, using php pg admin on the server work fine. I did
configure postgres so it listen to any address (localhost in this case
and 192.168.0.50) but for one reason or another, postgresql doesn't
tcp/ip connexions.
** Affects: postgresql-9.1 (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/910300
Title:
the file pg_hba.conf is not working on pgsql 9.1
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/postgresql-9.1/+bug/910300/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
