How to optimize performance for PostgreSQL logical replication …
Oct 25, 2024 · We are facing issues with logical replication performance when handling a large number of tenants (around 150 databases on the same PG instance). Our replication setup …
postgresql - Monitor logical replication using LSN - Database ...
Jul 12, 2022 · How do I monitor a logical replication in Postgresql 12 by seeing the lsn ? What I have done : Inspect some colomns on Publisher and Subscriber. Publisher side : select * from …
postgresql - How to activate replication slot - Database …
Aug 23, 2022 · I have 2 logical replication slots in Postgres 12. Suddenly one of them (100 fields, 16K records) failed couple of days ago. Obviously, the replication slot is inactive. Then I check …
How to set up Postgresql pglogical replication on the same …
Oct 16, 2024 · I am trying to assess pglogical replication usage instead of the built-in one (particularly due to being able to filter by operation). I am using a single Azure Postgresql …
postgresql - Autovacuum unable to vacuum which is causing DB …
Oct 4, 2024 · If it a problem for VACUUM, and you have logical replication slots, investigate if you have long running transactions and check how the consumer is doing. Disclaimer: from what I …
postgresql - find error log for streaming replication - Database ...
Dec 6, 2022 · Recently the streaming replication fails after I restart the primary. I can not find the record using select * from pg_stat_replication Now, I want to see it from the system log file at …
Which PostgreSQL replication solution (s) would work for me?
Dec 7, 2023 · By default replica server for streaming replication is read-only and the one table you mentioned can easily control using user rights. Streaming replication can setup using just one …
postgresql - Upgrading Postgres major version using logical …
Oct 22, 2021 · Setup logical replication between the primary and replication (so change from the current streaming replication) Once replication is completed and they are in sync, stop the …
postgresql - Postgres major version upgrade using replication …
Oct 29, 2021 · Setup logical replication with the primary to get the data up to date Make replication the primary, and applications start connecting to the replication. Kill the Postgres …
postgresql - Postgres Logical Replication - "replication slot "mysub ...
Jun 23, 2019 · I have two database servers 192.168.150.210 and 192.168.150.220 I created publication and subscription successfully for logical replication. postgresql.conf file is modified …