Fri, 22 Mar 2024 14:14:52 +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-can-i-take-a-backup-of-configuration-files-in-postgresql/ https://www.percona.com/blog/how-can-i-take-a-backup-of-configuration-files-in-postgresql/#respond Fri, 22 Mar 2024 14:14:52 +0000 https://www.percona.com/blog/?p=95275 PostgreSQL configuration file parameters are very important when managing a PostgreSQL database, and this blog post will discuss the importance of backing those files up. The following are the primary configuration files of the PostgreSQL database:postgresql.conf: One of the most important configuration files for the PostgreSQL database is postgresql.conf file. This file contains a range […]]]> https://www.percona.com/blog/how-can-i-take-a-backup-of-configuration-files-in-postgresql/feed/ 0 95275 https://www.percona.com/blog/enhancing-postgresql-security-how-to-encrypt-the-pgbackrest-repository/ https://www.percona.com/blog/enhancing-postgresql-security-how-to-encrypt-the-pgbackrest-repository/#respond Thu, 30 Nov 2023 14:50:18 +0000 https://www.percona.com/blog/?p=92178 Encryption is the process of turning data into an unrecognizable format unless the necessary password (also known as passphrase) or decryption key is provided.This blog describes how to encrypt the pgBackRest repository. pgBackRest is the backup tool used to perform Postgres database backup, restoration, and point-in-time recovery (PITR). The repository is where pgBackRest stores backups […]]]> https://www.percona.com/blog/enhancing-postgresql-security-how-to-encrypt-the-pgbackrest-repository/feed/ 0 92178 https://www.percona.com/blog/postgresql-tuple-level-statistics-with-pgstattuple/ https://www.percona.com/blog/postgresql-tuple-level-statistics-with-pgstattuple/#comments Mon, 09 Oct 2023 12:08:01 +0000 https://www.percona.com/blog/?p=91059 Since Postgres table bloat degrades database performance, we can improve its performance by removing the table bloat. We can use the pgstattuple extension to identify the bloated tables.This extension provides several functions for obtaining tuple-level statistics. Because the pgstattuple functions produce extensive page-level information, access to them is, by default, limited. Only the pg_stat_scan_tables role […]]]> https://www.percona.com/blog/postgresql-tuple-level-statistics-with-pgstattuple/feed/ 1 91059 https://www.percona.com/blog/public-schema-security-upgrade-in-postgresql-15/ https://www.percona.com/blog/public-schema-security-upgrade-in-postgresql-15/#respond Wed, 28 Jun 2023 13:00:56 +0000 https://www.percona.com/blog/?p=88905 In the Postgres database, the application data can be organized in various ways using Postgres schemas. In the Postgres database cluster, whenever we create a new database, It gets created with the default schema called public schema. This blog post will discuss the Public Schema Security upgrade in PostgreSQL 15. [crayon-664c927a8114b566092691/] When we create a […]]]> https://www.percona.com/blog/public-schema-security-upgrade-in-postgresql-15/feed/ 0 88905 https://www.percona.com/blog/what-if-the-backup-server-is-down-and-a-backup-is-needed-multi-repo-functionality-of-pgbackrest/ https://www.percona.com/blog/what-if-the-backup-server-is-down-and-a-backup-is-needed-multi-repo-functionality-of-pgbackrest/#respond Tue, 28 Mar 2023 12:01:40 +0000 https://www.percona.com/blog/?p=86413 Our previous blogs discussed configuring and setting up backups using the pgBackRest solution. To briefly explain pgBackRest, it is an open source backup tool that takes FULL Backup, Incremental Backup, and Differential Backup for PostgreSQL databases.Repository means the location/path on the server or the cloud where the actual copy of the backup will reside. In […]]]> https://www.percona.com/blog/what-if-the-backup-server-is-down-and-a-backup-is-needed-multi-repo-functionality-of-pgbackrest/feed/ 0 86413