[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.sraoss.jp/pipermail/pgpool-general/attachments/20130508/59b738d4/attachment.html>


More information about the pgpool-general mailing list