Tue, 27 Feb 2024 21:50:14 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/how-to-convert-postgresql-streaming-replication-to-logical-replication/ https://www.percona.com/blog/how-to-convert-postgresql-streaming-replication-to-logical-replication/#comments Thu, 14 Dec 2023 17:56:29 +0000 https://www.percona.com/blog/?p=92468 While a hallmark feature of PostgreSQL is streaming replication, sometimes data demands a more refined and adaptable replication approach to address different requirements. Logical replication offers a distinct advantage over traditional streaming replication by providing a more detailed and selective approach to data replication, enabling organizations to replicate specific tables selectively and even filter out […]]]> https://www.percona.com/blog/how-to-convert-postgresql-streaming-replication-to-logical-replication/feed/ 2 92468 https://www.percona.com/blog/how-to-start-logical-replication-in-postgresql-for-specific-tables-based-on-a-pg_dump/ https://www.percona.com/blog/how-to-start-logical-replication-in-postgresql-for-specific-tables-based-on-a-pg_dump/#comments Mon, 08 May 2023 14:51:18 +0000 https://www.percona.com/blog/?p=87536 In simpler terms, logical replication in PostgreSQL is a way to copy data from one database to another in a more flexible and customizable manner compared to physical replication. Instead of copying the entire database, logical replication focuses on replicating changes made to individual rows or transactions. To set up logical replication, you create a […]]]> https://www.percona.com/blog/how-to-start-logical-replication-in-postgresql-for-specific-tables-based-on-a-pg_dump/feed/ 2 87536 https://www.percona.com/blog/pgbackrest-restoration-scenarios/ https://www.percona.com/blog/pgbackrest-restoration-scenarios/#comments Tue, 15 Nov 2022 12:29:52 +0000 https://www.percona.com/blog/?p=83576 In one of our previous posts—pgBackRest: A Great Backup Solution and a Wonderful Year of Growth—we discussed the installation of pgBackRest and the backup, quick restore command. It would be ideal to have a restoration activity scheduled as per business needs so that backups are validated and provide critical metrics on recovery time. In this […]]]> https://www.percona.com/blog/pgbackrest-restoration-scenarios/feed/ 6 83576