pg_dumpbinary v2.2 is out

Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

pg_dumpbinary v2.2 is out

Gilles Darold-2
Grenoble, France - August 21th, 2020

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

pg_dumpbinary 2.2 was released today, this release fixes some issues
reported by users since last release and adds news improvements.

   - Backup of extension's tables defined as being part of the dump.
   - Use the WHERE clause define for the extension's tables dump.
   - Restore sequence values with data binary dump/restore.
   - Add support to PostgreSQL >= v12 with new -f option of pg_restore.
   - Export of sequences registered as part of the dump in extensions.

pg_dumpbinary is useful in some particular situations:

* 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 char/varchar/text which truncate data after
   the '\0'. In this case pg_dump will export data in the output
   type which will result in data lost.
* any other case where pg_dump run in plain text, custom and
   directory format is failing to export your data correctly.

If you are in this case pg_dumpbinary will help you by dumping the
PostgreSQL database in binary format. In all other cases you must
use the pg_dump/pg_restore commands distributed with PostgreSQL.

See documentation for a complete description of the features.

===== Links & Credits =====

pg_dumpbinary is an open project from LzLabs (
Any contribution to build a better tool is welcome. You just have to send
your ideas, features requests or patches using the GitHub tools.

Links :

* Documentation:
* Download:
* Support: use GitHub report tool at

Gilles Darold