Learn how to deploy PostgreSQL on Kubernetes with synchronous replication to guard against losing transactions.
Schedule regular PostgreSQL backups and set storage retention with Kubernetes and pgBackRest and the PostgreSQL Operator
Migrating from one database to another is inherently new technology and can raise a multitude of questions.
Deploy a high-availability PostgreSQL cluster on Kubernetes by example and learn how it works.
In order to more easily monitor PgBouncer, the team at Crunchy Data developed an open source PgBouncer Foreign Data Wrapper (pgbouncer_fdw).
Tested methods for upgrading PostgreSQL software from one major release to another with the least amount of headache.
Learn how the HPE SSD issues can impact your PostgreSQL data, and what strategies you can take to protect your data.
With the recent release of PostgreSQL 12, pgBackRest also received a number of updates and changes to take advantage of the latest features of Postgres.
The CIS PostgreSQL 12 Benchmark continues to build upon previous versions and Crunchy Data’s efforts with the PostgreSQL Security Technical Implementation Guide.
Learn how to create PostgreSQL clusters using the Kubernetes custom resource definitions (CRDs) provided by the PostgreSQL Operator.
Just upgrade and take advantage of performance improvements in PostgreSQL 12.
The raster functionality in PostGIS has been part of the main extension since it was introduced. When PostGIS 3 is released, if you want raster functionality you will need to install both the core postgis extension, and also the postgis_raster extension.
Version 2.28 (release notes) of the GNU C library introduces many changes to the collations it provides. Collations determine how strings are compared and by default, PostgreSQL uses the operating system’s collations which on Linux means glibC. When your operating system updates to this version of glibc and you aren't using the “C” or “POSIX” collation, you may encounter some differently ordered indexes. This unexpected change in the order of indexes will lead to incorrectly ordered query results and possible data corruption. Currently, the following distributions are affected: