Mon, 29 Apr 2024 16:04:30 +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/the-magic-of-pitr-pg_upgrade-and-logical-replication-when-used-together-for-postgresql-version-upgrades/ https://www.percona.com/blog/the-magic-of-pitr-pg_upgrade-and-logical-replication-when-used-together-for-postgresql-version-upgrades/#respond Tue, 05 Dec 2023 15:50:13 +0000 https://www.percona.com/blog/?p=91642 Recently, I was reading a brilliant blog by Perconian David Gonzalez titled The 1-2-3 for PostgreSQL Logical Replication Using an RDS Snapshot, exploring the intricacies of setting up logical replication on Amazon RDS using RDS snapshots. It was a fascinating read, shedding light on leveraging AWS snapshots’ capabilities to avoid initial data copy within the […]]]> https://www.percona.com/blog/the-magic-of-pitr-pg_upgrade-and-logical-replication-when-used-together-for-postgresql-version-upgrades/feed/ 0 91642 https://www.percona.com/blog/postgresql-role-inheritance-in-reverse-discovering-descendant-roles-in-reverse-gear/ https://www.percona.com/blog/postgresql-role-inheritance-in-reverse-discovering-descendant-roles-in-reverse-gear/#respond Wed, 04 Oct 2023 13:04:28 +0000 https://www.percona.com/blog/?p=91156 In our previous blog post, PostgreSQL Role Inheritance at a Glance, we delved into the concept of role inheritance in PostgreSQL. We discussed how roles can inherit permissions from other roles, simplifying access control in your database. But what if you need to discover which roles inherit from a specific role? That’s where our new […]]]> https://www.percona.com/blog/postgresql-role-inheritance-in-reverse-discovering-descendant-roles-in-reverse-gear/feed/ 0 91156 https://www.percona.com/blog/find-the-wal-count-between-two-segments-in-postgresql/ https://www.percona.com/blog/find-the-wal-count-between-two-segments-in-postgresql/#comments Thu, 29 Jun 2023 14:47:33 +0000 https://www.percona.com/blog/?p=89060 The PostgreSQL Write-Ahead Log (WAL) is a recording location within the Postgres cluster, capturing all modifications made to the cluster’s data files before being written to the heap. During crash recovery, the WAL contains sufficient data for Postgres to restore its state to the point of the last committed transaction.Use casesThere may arise circumstances where […]]]> https://www.percona.com/blog/find-the-wal-count-between-two-segments-in-postgresql/feed/ 2 89060 https://www.percona.com/blog/postgresql-role-inheritance-at-a-glance/ https://www.percona.com/blog/postgresql-role-inheritance-at-a-glance/#respond Thu, 22 Dec 2022 12:48:21 +0000 https://www.percona.com/blog/?p=84165 PostgreSQL manages database access permissions using the concept of roles. A role can be either a database user or a group of database users, depending on how the role is set up. Roles can own the database objects and assign privileges on those objects to other roles to control who has access to which objects. […]]]> https://www.percona.com/blog/postgresql-role-inheritance-at-a-glance/feed/ 0 84165