1. User ve Role Yaratılır
Şöyle yaparızCREATE USER cdcuser WITH PASSWORD 'cdcpassword' REPLICATION LOGIN;CREATE ROLE replication_group WITH USER foouser, cdcuser;GRANT CREATE ON DATABASE quant_core TO replication_group;GRANT USAGE ON SCHEMA foo TO replication_group;GRANT CREATE ON SCHEMA foo TO replication_group;CREATE TABLE foo.cdc_heartbeat (heartbeat bit);ALTER TABLE foo.cdc_heartbeat OWNER TO cdcuser;
2. WAL Seviyesi
var/lib/postgresql/data/postgresql.conf dosyasındaki wal_level alanını değeri logical yapılır
Hiç yorum yok:
Yorum Gönder