Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sOB2E-00Cp15-JW for pgsql-announce@arkaria.postgresql.org; Mon, 01 Jul 2024 07:01:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sOB2D-00FbEc-0X for pgsql-announce@arkaria.postgresql.org; Mon, 01 Jul 2024 07:01:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sOB2C-00FbEI-5a for pgsql-announce@lists.postgresql.org; Mon, 01 Jul 2024 07:01:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sOB2A-004R9K-9j for pgsql-announce@lists.postgresql.org; Mon, 01 Jul 2024 07:01:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=Tpau4M46gFROixCeMWOENoLyoXhQ3TaeNppyIudcdcA=; b=YGolpoRdd7vyxaQ2HwejPbgg/y +vvkFy5fJ1Li6aj230jWxVbLe09xMNoq8OSEeObrs4pZLALR3H/gpkHG9AuBXCSqJkzpd4pGf/kEW 9W20pu3hinKnpsAMvExXfSjmfSWxoUnXgXpqZ5dmc6jj2jeUsXVkMKxOczz+ZkrYg1jXNeh8twkwn F+uiWr96esSXbsn1h/iFfcE3hOmrGdPNCveTthjpM4e16ic73UmlNRxb+knDOJoFJAbkl/eIcledh ojSROVOiuUY+DR6q5KOCam6P52fBNaFKtN7Oio8hE1DCMWP0rYTFvXVIrlZbY11GhVVFrJ0AF0c19 rKGETIMw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sOB28-00CcHc-2J for pgsql-announce@lists.postgresql.org; Mon, 01 Jul 2024 07:01:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sOB26-007PXS-Nm for pgsql-announce@lists.postgresql.org; Mon, 01 Jul 2024 07:01:02 +0000 Content-Type: multipart/mixed; boundary="===============1140972892917643469==" MIME-Version: 1.0 Subject: pg_dumpbinary v2.18 released To: PostgreSQL Announce From: Gilles Darold via PostgreSQL Announce Reply-To: gilles@darold.net Date: Mon, 01 Jul 2024 07:00:15 +0000 Message-ID: <171981721523.701.13011453309014325611@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: 774d883280f071768c3c814146a7d60cdad104074ababb8c3e18a5069adb742b List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1140972892917643469== Content-Type: multipart/alternative; boundary="===============4572348898795873146==" MIME-Version: 1.0 --===============4572348898795873146== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable **Grenoble, France - June 22, 2024** ## pg_dumpbinary `pg_dumpbinary` dumps a PostgreSQL database to a binary format. The resulti= ng dump must be restored using `pg_restorebinary`, which is provided. This is a maintenance release that fixes two bugs in the restore process. - Fix double copy statements when a table name requires to be quoted. - Fix error when restoring a table with a GENERATED ALWAYS column. `pg_dumpbinary` is useful when: * You have bytea that can not be exported by `pg_dump` because the total size of the escape/hex output exceeds 1Gb. * You have custom type that stores `\0` internally in bytea but data are exported by pg_dump as char/varchar/text. In this case pg_dump truncates all data after the first `\0`, resulting in data loss. * Other cases where a binary output format is useful. In these kinds of cases `pg_dumpbinary` helps by dumping the PostgreSQL database in a binary format. In all other cases the pg_dump/pg_restore commands distributed with PostgreSQL are preferred. See the documentation for a more complete description of available features. ## Links & Credits pg_dumpbinary is an Open Source project from [LzLabs GmbH](https://www.lzla= bs.com/). Contributions and ideas are welcome. Send your ideas, features requests, or patches using GitHub's tool= s. Links : * Documentation: [https://github.com/lzlabs/pg_dumpbinary/blob/master/READM= E.md](https://github.com/lzlabs/pg_dumpbinary/blob/master/README.md) * Download: [https://github.com/lzlabs/pg_dumpbinary/releases/](https://gi= thub.com/lzlabs/pg_dumpbinary/releases/) * Support: use GitHub report tool at [https://github.com/lzlabs/pg_dumpbina= ry/pg_dumpbinary/issues](https://github.com/lzlabs/pg_dumpbinary/pg_dumpbin= ary/issues) --===============4572348898795873146== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable pg_dumpbinary v2.18 released
 

pg_dumpbinary v2.18 released

Grenoble, France - June 22, 2024

pg_dumpbinary

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

This is a maintenance release that fixes tw= o bugs in the restore process.

  • Fix double copy= statements when a table name requires to be quoted.
  • Fix error when = restoring a table with a GENERATED ALWAYS column.

pg_dumpbinary is useful when:<= /p>

  • You have bytea = that can not be exported by pg_dump because the total size of the escape/hex output exceeds 1Gb.
  • You have custom= type that stores \0 internally in bytea but data are exported by pg_dump as char/varchar/text. In this case pg_dump truncates all data after the first \0, resulting in data los= s.
  • Other cases whe= re a binary output format is useful.

In these kinds of cases pg_dumpbinary= helps by dumping the PostgreSQL database in a binary format. In all other cases the pg_dump/pg_restore commands distributed with PostgreSQL are preferred.

See the documentation for a more complete d= escription of available features.

Links & Credits

pg_dumpbinary is an Open Source project fro= m LzLabs GmbH. Contributions and ideas are welcome. Send your ideas, features requests, or patches using GitHub's tool= s.

Links :
This email was sent to you from Gilles Darold. It was delivered on their be= half by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to Gilles Darold.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============4572348898795873146==-- --===============1140972892917643469==--