[pgpool-general: 1698] pgpool with streaming replication - error
Jayadevan M
jayadevan.maymala at ibsplc.com
Wed May 8 20:29:41 JST 2013
Hi,
When I try to connect to PostgreSQL via pgpoo, pgpool is not asking me for password. It just throws the error
psql: ERROR: "MD5" authentication with pgpool failed for user "postgres"
My pg_hba.conf gor postgresql is
# TYPE DATABASE USER ADDRESS METHOD
#
# # "local" is for Unix domain socket connections only
# # IPv4 local connections:
host all all 192.0.0.1/8 md5
# # IPv6 local connections:
# host all all ::1/128 trust
# # Allow replication connections from localhost, by a user with the
# # replication privilege.
local replication postgres trust
host replication postgres 127.0.0.1/32 trust
host replication postgres ::1/128 trust
pool_hba.conf reads -
# "local" is for Unix domain socket connections only
# IPv4 local connections:
host all all 192.0.0.1/8 md5
Any idea why?
Pgpool version is pgpool-II-3.2.4
Regards,
Jayadevan
DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20130508/59b738d4/attachment.htm>
More information about the pgpool-general
mailing list