pgstef’s blog

A recent question on the community channels described a difficult situation: a standby had been promoted with archive_mode=off, and restarting the new primary was something the team wanted to avoid.

Percona Transparent Data Encryption for PostgreSQL (pg_tde) is an open-source PostgreSQL extension that provides Transparent Data Encryption (TDE) to protect data at rest. pg_tde ensures that data stored on disk is encrypted and cannot be read without the…

A useful new feature was introduced on 11 December 2025: Allow expiration of the oldest full backup regardless of current retention.

The TLS server provides an alternative to using SSH for protocol connections to remote hosts.

pgBackRest is a popular backup and restore tool for PostgreSQL, known for easily handling even the largest databases and workloads.

As I mentioned in my last blog post, as your cluster grows with multiple standby servers and potentially automated failover (using tools like Patroni), it becomes more practical to set up a dedicated repository host, also known as a dedicated backup serve…

Recently, we’ve received many questions about how to take backups from a standby server using pgBackRest.

Recently, while debugging a performance issue of a CREATE INDEX operation, I was reminded that PostgreSQL might produce temporary files when executing a parallel query, including parallel index creation, because each worker process has its own memory and…

One of the most frequent questions I get is to actually explain the difference between differential and incremental backups in pgBackRest.

SFTP support has been added in the 2.46 release on 22 May 2022.

With pgBackRest 2.41 just released, a new feature called backup annotations is now available.