Question : I’m using AWS RDS PostgreSQL 13 database in a master-slave configuration using logical replication with pglogical extension. Recently, […]
Tag: pg-logical
Postgres difference between restart_lsn and confirmed_flush
Question : According to the documentation, restart_lsn is The address (LSN) of oldest WAL which still might be required by […]
Postgres major version upgrade using replication server
Question : I am planning to upgrade my database from Postgres 10 to Posgres 14. To reduce the downtime, I […]
Postgres major version upgrade using replication server
Question : I am planning to upgrade my database from Postgres 10 to Posgres 14. To reduce the downtime, I […]
Error when passing variable to function
Question : I’ve created a function in PostgreSQL 11.10 to handle DDL change in pglogical to apply it into subscriber. […]
Why can’t I setup replication with pglogical? It says I need a primary key even though I have unique constraints
Question : I’m trying to enable replication with pglogical on a database running Postgres 9.6.22, however I can’t add one […]