I have installed both pgpool and postgresql via
pgpool.conf, I have made the changes necessary to use replication mode, as well as my two postgresql databases (currently all running on the same host).
I am unable to figure out what I need to add to my
pg_hba.conf files in order to have pgpool connect to them. I keep getting this error
createdb: could not connect to database postgres: ERROR: MD5 authentication is unsupported in replication, master-slave and parallel modes. HINT: check pg_hba.conf
both of my
pg_hba.conf files look like
local all postgres peer local all all peer local all postgres md5 host all all 127.0.0.1/32 md5 host all all ::1/128 md5 local replication postgres peer host replication postgres 127.0.0.1/32 md5
pool_hba.conf looks like
local all all trust local all postgres md5 local all all md5 host all all 127.0.0.1/32 trust
What am I missing in order to have pgpool connect to my databases?