PostgreSQL: pgBackRest 2.46 and credcheck v2.0.0 Released

posted by Roy Schestowitz on Jun 13, 2023

• pgBackRest 2.46 Released

  Crunchy Data is pleased to announce the release of pgBackRest 2.46, the latest version of the reliable, easy-to-use backup and restore solution that can seamlessly scale up to the largest databases and workloads.

  Over the last year pgBackRest has introduced many exciting new features including block incremental backup, file bundling, repository verification, backup annotations, and SFTP repository storage.

  IMPORTANT NOTE: pgBackRest 2.44 is the last version to support PostgreSQL 9.0/9.1/9.2.

  pgBackRest supports a robust set of features for managing your backup and recovery infrastructure, including: parallel backup/restore, full/differential/incremental backups, block incremental backup, multiple repositories, delta restore, parallel asynchronous archiving, per-file checksums, page checksums (when enabled) validated during backup, multiple compression types, encryption, partial/failed backup resume, backup from standby, tablespace and link support, S3/Azure/GCS/SFTP support, backup expiration, local/remote operation via SSH or TLS, flexible configuration, and more.

• credcheck v2.0.0 released

  Release v2.0.0 adds a major feature and the compatibility with PostgreSQL 16. Upgrade require a PostgreSQL restart to reload the credcheck library.

  Add "Authentication failure ban" new feature

  PostgreSQL doesn't have any mechanism to limit the number of authentication failure attempt before the user being banned. With the credcheck extension, after an amount of authentication failure defined by configuration directive credcheck.max_auth_failure the user can be banned and never connect anymore even if it gives the right password later. This feature requires that the credcheck extension to be added to to shared_preload_libraries configuration option.