GitHub

YuliyaVaravko/PostgreSQL_dump

This project contains scripts that creates a PostgreSQL backup and writes it to the log file /var/log/backup/backup.log. Log format: [Script name][Execution time ...
GitHub

pg_dumpbinary is a program used to dump a PostgreSQL database with data dumped in binary format. The resulting dumps must be restored using pg_restorebinary.

you have bytea that can not be exported by pg_dump because the total size of the escape/hex output exceed 1Gb. you have custom type that stores \0 internally in bytea but data are returned as ...
ZDNet

PostgreSQL 17 packs big performance and feature enhancements

One of the most anticipated new features in PostgreSQL 17 is native support for incremental backups. Previously, you had to use third-party programs for this; now, it's baked into the server. This ...
InfoWorld

4 key new features in PostgreSQL 16

Postgres 16 highlights include updates around privilege administration, logical replication, performance improvements, and comprehensive monitoring features. Here is a breakdown. Today, the PostgreSQL ...