PostgreSQL: pg_dumpbinary v2.15 released

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

Zurich, Switzerland - Febuary 14th, 2024

pg_dumpbinary

pg_dumpbinary dumps a PostgreSQL database to a binary format. The resulting dump must be restored using pg_restorebinary, which is provided.

Version 2.15 has been published, this release adds a new option and fixes a bug reported by users since last release.

• Add -w, --where command line option to pg_dumpbinary to apply a filter to the data dumped. The filter will be used in a WHERE clause for data export, this clause will be applied to all tables dumped.
• Fix error "DBD::Pg::db do failed: server closed the connection unexpectedly" when the attempt to dump the pre-data section fail.

A full list of changes and acknowledgments can be found here

pg_dumpbinary is useful when:

• You have bytea that can not be exported...

Get the full details here: https://www.postgresql.org/about/news/pg_dumpbinary-v215-released-2811/