How to optimize performance for PostgreSQL logical replication with a ...
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 Using phyical …
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 Administrators ...
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 a couple of …
How to set up Postgresql pglogical replication on the same database ...
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 flexible server database
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 heard, the …
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 /var/log/
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 replication ...
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 replication …
postgresql - Postgres major version upgrade using replication server ...
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 service running on the …
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 on both servers.