From: | Gilles Darold via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org> |
---|---|
To: | PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org> |
Subject: | pg_dumpbinary v2.3 released |
Date: | 2020-10-29 15:37:22 |
Message-ID: | 160398584272.7814.10217890260084132610@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
Grenoble, France - August 21th, 2020
##pg_dumpbinary 2.3 released
`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.3` was released today. This release fixes the setting of sequences values after
restoring data from binary a dump where sequences values from PostgreSQL extensions was not restored.
`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 binary format can be useful.
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 (https://www.lzlabs.com/).
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: https://github.com/lzlabs/pg_dumpbinary/blob/master/README.md
* Download: https://github.com/lzlabs/pg_dumpbinary/releases/
* Support: use GitHub report tool at https://github.com/lzlabs/pg_dumpbinary/issues
From | Date | Subject | |
---|---|---|---|
Next Message | PWN via PostgreSQL Announce | 2020-11-02 06:14:07 | PostgreSQL Weekly News - November 1, 2020 |
Previous Message | Dalibo via PostgreSQL Announce | 2020-10-29 15:36:30 | pg_activity 1.6.2 has been released |