postgresql - Can't connect to pgpool -
i'm playing around pgpool2.
i'm connecting postgresql running on port 5432 command psql -u postgres -p 5432
, it's connecting normally.
when i'm connecting pgpool2 running on 9999 port command psql -u postgres -p 9999
- returns dialog like: psql: root@master:/linux/path#
what i'm doing wrong? there way connect pgpool using psql? cannot connect application also.
upd i've got following error pool_do_auth: maybe protocol version mismatch (current version 3)
solved : problem in pgpool auth on backends. editing pg_hba.conf
fixed problem.
this error message , behavior because of problem pgpool authenticating postgres, not authenticating pgpool might suspect. if check postgres logs, tell line in postgres pg_hba.conf
being rejected.
however, since (iirc) pgpool cannot peer authentication, one, says local (unix socket) connections authenticated pretending system username postgres username:
local all peer
you want change to:
local all trust
at least make things work. however, lose security way. however, if users (that can access unix socket) trusted, okayish.
Comments
Post a Comment