1
/
of
1
ERROR: must be superuser or replication role to use
ERROR: must be superuser or replication role to use
the master doesn't create the replication slot This doesn't happen at every restart but randomlyinconsistent In the slave postgres logs:
Configure logical replication using the slot · Create a publication on the source cluster: CREATE PUBLICATION publication_name> FOR TABLE
create logical replication slot postgres Step 4: Create a logical replication slot · Connect your client to the RDS instance by using the db_admin account psql -h Endpoint of the RDS
create replication slot SELECT * FROM pg_replication_slots to see if any replication slots were accidentally created that might be preventing WAL cleanup · SHOW
Regular
price
126.00 ₹ INR
Regular
price
126.00 ₹ INR
Sale
price
126.00 ₹ INR
Unit price
/
per
Share
![create replication slot postgres](10054.png)