Configuration Metrics News About

Add replication slot

psql postgres
SELECT pg_create_physical_replication_slot('repl', true, false);
\q
    

as postgres user

Change the pgmoneta configuration

Change pgmoneta.conf to add

wal_slot = repl
    

under the [primary] server setting, like

[primary]
host = localhost
port = 5432
user = repl
wal_slot = repl
    

as pgmoneta user

Restart pgmoneta

Stop pgmoneta and start it again with

pgmoneta-cli -c pgmoneta.conf stop
pgmoneta -c pgmoneta.conf -u pgmoneta_users.conf
    

as pgmoneta user