docs icon indicating copy to clipboard operation
docs copied to clipboard

pg_hba.conf postgres "database" problem

Open daywalker90 opened this issue 3 years ago • 0 comments

Hi great guide thanks for writing this. I followed it on postgresql 14 and besides one setting which got replaced it's the same i think. But there is one problem which could also be true for v12. Your guide says to put host postgres postgres 192.168.0.6/32 md5 into pg_hba.conf and then later to run pg_basebackup -h 192.168.0.5 -U postgres -D /var/lib/postgresql/12/main/ -P --password --slot node_a_slot But this command gives an error: no pg_hba.conf entry for replication connection from host "xx.x.x.x", user "postgres" And i think that makes sense because you only gave it the "postgres" connection. So i changed it to: host replication postgres 192.168.0.6/32 md5 and it worked.

daywalker90 avatar May 28 '22 18:05 daywalker90