Docker Community Forums

Share and learn in the Docker community.

Postgres Replication


#1

Hello good day.
I had problems to make a replication in my container with Postgresql, below I tell you how to make the configuration of the master:

→config de pg_hba.conf
host replication postgres xx.xx.xx.xx/32 md5

→ Configuracion postgres.conf
wal_level = hot_standby
max_wal_senders = 8

and to make the database copy

docker exec -ti container_slave pg_basebackup -D /home/Data/data_r -h IP_Container_Master -p 5432 -U postgres -W -P -v --xlog-method=stream -R

in the container log marks this for me:
pg_basebackup: directory ‘;/home/Data/data_r exists but is not empty’

2.-
docker exec -ti Container_Master pg_basebackup -D /home/Data/data_r -U postgres -W -P -v --xlog-method=stream -R
Password:

Log:
pg_basebackup: could not connect to server: FATAL: no pg_hba.conf entry for replication connection from host ‘Local’ user ‘postgres’, SSL off