Guía de configuración de la fuente para Postgres genérico

wal_level = logical

SHOW wal_level;

ALTER SYSTEM SET wal_level = logical;

max_wal_senders > 1
max_replication_slots >= 4

SHOW max_wal_senders;
SHOW max_replication_slots;

ALTER SYSTEM SET max_wal_senders = 10;
ALTER SYSTEM SET max_replication_slots = 10;

CREATE USER clickpipes_user PASSWORD 'some-password';

GRANT USAGE ON SCHEMA "public" TO clickpipes_user;
GRANT SELECT ON ALL TABLES IN SCHEMA "public" TO clickpipes_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA "public" GRANT SELECT ON TABLES TO clickpipes_user;

ALTER USER clickpipes_user WITH REPLICATION;

host    all   clickpipes_user     0.0.0.0/0          scram-sha-256

SELECT pg_reload_conf();