pg_hba.conf postgres "database" problem
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.