Latest posts
Guard Against Transaction Loss with PostgreSQL Synchronous Replication
Learn how to deploy PostgreSQL on Kubernetes with synchronous replication to guard against losing transactions.
17 min read
Scheduled PostgreSQL Backups and Retention Policies with Kubernetes
Schedule regular PostgreSQL backups and set storage retention with Kubernetes and pgBackRest and the PostgreSQL Operator
5 min read
Migrating from Oracle to PostgreSQL: Tips and Tricks
Migrating from one database to another is inherently new technology and can raise a multitude of questions.
9 min read
Deploy High Availability PostgreSQL Clusters on Kubernetes by Example
Deploy a high-availability PostgreSQL cluster on Kubernetes by example and learn how it works.
9 min read
How To Simplify pgBouncer Monitoring with pgbouncer_fdw
In order to more easily monitor PgBouncer, the team at Crunchy Data developed an open source PgBouncer Foreign Data Wrapper (pgbouncer_fdw).
5 min read
How To Improve PgBouncer Security with TLS/SSL
PgBouncer is a commonly deployed and recommended connection pooler for PostgreSQL and supports a number of authentication methods including TLS/SSL client certificate authentication.
10 min read
How to Perform a Major Version Upgrade Using pg_upgrade in PostgreSQL
Tested methods for upgrading PostgreSQL software from one major release to another with the least amount of headache.
4 min read
Hope Is Not A Strategy: How Hardware Issues Affect Your PostgreSQL Data
Learn how the HPE SSD issues can impact your PostgreSQL data, and what strategies you can take to protect your data.
3 min read
How To Get Started with pgBackRest and PostgreSQL 12
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.
10 min read
Enhancing PostgreSQL 12 Security with the CIS Benchmark
The CIS PostgreSQL 12 Benchmark continues to build upon previous versions and Crunchy Data’s efforts with the PostgreSQL Security Technical Implementation Guide.
4 min read
Monitoring PostgreSQL Clusters in Kubernetes
Learn how to monitor an enterprise PostgreSQL database-as-a-service cluster in Kubernetes using the PostgreSQL Operator and pgMonitor.
6 min read
PostgreSQL Change Data Capture With Debezium
A step-by-step guide for how to setup PostgreSQL change data capture with Debezium and Apache Kafka
10 min read
Waiting for PostGIS 3: ST_Transform() and Proj6
PostGIS makes use of the Proj library for coordinate reference system conversions, and PostGIS 3 will support the latest Proj release, version 6.
3 min read
Creating a PostgreSQL Cluster with Kubernetes CRDs
Learn how to create PostgreSQL clusters using the Kubernetes custom resource definitions (CRDs) provided by the PostgreSQL Operator.
8 min read
Just Upgrade: How PostgreSQL 12 Can Improve Your Performance
Just upgrade and take advantage of performance improvements in PostgreSQL 12.
8 min read
Waiting for PostGIS 3: GEOS 3.8
While PostGIS includes lots of algorithms and functionality we have built ourselves, it also adds geospatial smarts to PostgreSQL by linking in specialized libraries to handle particular problems.
3 min read
Waiting for PostGIS 3: Parallelism in PostGIS
Improvements in PostgreSQL 12 allow PostGIS 3 to use built-in query parallelism to execute accelerated geospatial queries.
3 min read
Waiting for PostGIS 3: ST_TileEnvelope(z,x,y)
The MVT tile format in PostGIS lets you generate tiles from PostgreSQL. The ST_TileEnvelope() function converts directly from tile to mercator coordinates.
2 min read
Waiting for PostGIS 3: Separate Raster Extension
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.
3 min read
How To Correct and Identify Indexes Affected by the GNU C 2.28 Update
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:
3 min read
