[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-announce
Subject: pg_dumpbinary v2.9 released
From: Gilles Darold via PostgreSQL Announce <announce-noreply () postgresql ! org>
Date: 2023-02-07 12:49:53
Message-ID: 167577419344.1704774.8255281461411944681 () wrigleys ! postgresql ! org
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
**Zurich, Switzerland - February 4th, 2023**
## pg_dumpbinary
`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.9 was released today, this is a maintenance release
of version 2.8 published some days before. This releases add some
new features to pg_restorebinary and fix some issues reported by users.
* Force pg_restorebinary to stop on pg_restore or psql system command
error, print the failing command and exit with code 1.
* Add option -f, --outfile to generate a restore file usable with psql.
The purpose of this option is to be able to debug pg_dumprestore by
looking at the generated DDL and \copy commands.
`pg_dumpbinary` is useful in some 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 GmbH](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/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)
[Attachment #5 (text/html)]
<!doctype html>
<html>
<head>
<meta name="viewport" content="width=device-width">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>pg_dumpbinary v2.9 released</title>
<style>
@media only screen and (max-width: 620px) {
table[class=body] h1 {
font-size: 28px !important;
margin-bottom: 10px !important;
}
table[class=body] p,
table[class=body] ul,
table[class=body] ol,
table[class=body] td,
table[class=body] span,
table[class=body] a {
font-size: 16px !important;
}
table[class=body] .wrapper,
table[class=body] .article {
padding: 10px !important;
}
table[class=body] .content {
padding: 0 !important;
}
table[class=body] .container {
padding: 0 !important;
width: 100% !important;
}
table[class=body] .main {
border-left-width: 0 !important;
border-radius: 0 !important;
border-right-width: 0 !important;
}
table[class=body] .btn table {
width: 100% !important;
}
table[class=body] .btn a {
width: 100% !important;
}
table[class=body] .img-responsive {
height: auto !important;
max-width: 100% !important;
width: auto !important;
}
}
@media all {
.ExternalClass {
width: 100%;
}
.ExternalClass,
.ExternalClass p,
.ExternalClass span,
.ExternalClass font,
.ExternalClass td,
.ExternalClass div {
line-height: 100%;
}
.apple-link a {
color: inherit !important;
font-family: inherit !important;
font-size: inherit !important;
font-weight: inherit !important;
line-height: inherit !important;
text-decoration: none !important;
}
#MessageViewBody a {
color: inherit;
text-decoration: none;
font-size: inherit;
font-family: inherit;
font-weight: inherit;
line-height: inherit;
}
.btn-primary table td:hover {
background-color: #34495e !important;
}
.btn-primary a:hover {
background-color: #34495e !important;
border-color: #34495e !important;
}
}
</style>
</head>
<body class="" style="background-color: #f6f6f6; font-family: sans-serif; \
-webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.4; margin: 0; \
padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <table \
border="0" cellpadding="0" cellspacing="0" class="body" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; \
background-color: #f6f6f6;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> <td class="container" style="font-family: sans-serif; font-size: \
14px; vertical-align: top; display: block; Margin: 0 auto; max-width: 580px; padding: \
10px; width: 580px;">
<div class="content" style="box-sizing: border-box; display: block; Margin: \
0 auto; max-width: 580px; padding: 10px;">
<span class="preheader" style="color: transparent; display: none; height: \
0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; \
visibility: hidden; width: 0;"></span> <table class="main" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; background: \
#ffffff; border-radius: 3px;">
<tr>
<td class="wrapper" style="font-family: sans-serif; font-size: 14px; \
vertical-align: top; box-sizing: border-box; padding: 20px;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; \
vertical-align: top;">
<div>
<h1 style="color: #000; font-family: sans-serif; line-height: 1.4; margin: 0; \
margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: \
center">pg_dumpbinary v2.9 released</h1> </div>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px"><strong>Zurich, Switzerland - February 4th, 2023</strong></p> \
<h2 style="color: #000; font-family: sans-serif; font-weight: 400; line-height: 1.4; \
margin: 0; margin-bottom: 30px">pg_dumpbinary</h2> <p style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: \
15px"><code>pg_dumpbinary</code> is a program used to dump a PostgreSQL database with \
data dumped in binary format. The resulting dump must be restored using \
<code>pg_restorebinary</code> that is provided with this tool.</p> <p \
style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">pg_dumpbinary 2.9 was released today, this is a maintenance \
release of version 2.8 published some days before. This releases add some
new features to pg_restorebinary and fix some issues reported by users.</p>
<ul style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px"> <li style="list-style-position: inside; margin-left: 5px">Force \
pg_restorebinary to stop on pg_restore or psql system command error, print the \
failing command and exit with code 1.</li> <li style="list-style-position: inside; \
margin-left: 5px">Add option -f, --outfile to generate a restore file usable with \
psql. The purpose of this option is to be able to debug pg_dumprestore by
looking at the generated DDL and \copy commands.</li>
</ul>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px"><code>pg_dumpbinary</code> is useful in some situations:</p> <ul \
style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px"> <li style="list-style-position: inside; margin-left: 5px">you \
have bytea that can not be exported by <code>pg_dump</code> because the total size \
of the escape/hex output exceed 1Gb.</li> <li style="list-style-position: inside; \
margin-left: 5px">you have custom type that stores <code>\0</code> 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.</li>
<li style="list-style-position: inside; margin-left: 5px">any other case where binary \
format can be useful.</li> </ul>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">If you are in this case <code>pg_dumpbinary</code> 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.</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">See documentation for a complete description of the \
features.</p> <h2 style="color: #000; font-family: sans-serif; font-weight: 400; \
line-height: 1.4; margin: 0; margin-bottom: 30px">Links & Credits</h2> <p \
style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">pg_dumpbinary is an open project from <a \
href="https://www.lzlabs.com/" style="color: #3498db; text-decoration: \
underline">LzLabs GmbH</a>. Any contribution to build a better tool is welcome. You \
just have to send your ideas, features requests or patches using the GitHub \
tools.</p> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal; \
margin: 0; margin-bottom: 15px">Links :</p> <ul style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px"> <li \
style="list-style-position: inside; margin-left: 5px">Documentation: <a \
href="https://github.com/lzlabs/pg_dumpbinary/blob/master/README.md" style="color: \
#3498db; text-decoration: \
underline">https://github.com/lzlabs/pg_dumpbinary/blob/master/README.md</a></li> <li \
style="list-style-position: inside; margin-left: 5px">Download: <a \
href="https://github.com/lzlabs/pg_dumpbinary/releases/" style="color: #3498db; \
text-decoration: underline">https://github.com/lzlabs/pg_dumpbinary/releases/</a></li>
<li style="list-style-position: inside; margin-left: 5px">Support: use GitHub report \
tool at <a href="https://github.com/lzlabs/pg_dumpbinary/pg_dumpbinary/issues" \
style="color: #3498db; text-decoration: \
underline">https://github.com/lzlabs/pg_dumpbinary/pg_dumpbinary/issues</a></li> \
</ul>
</td>
</tr>
</table>
</td>
</tr>
</table>
<div class="footer" style="clear: both; Margin-top: 10px; text-align: \
center; width: 100%;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td class="content-block" style="font-family: sans-serif; \
vertical-align: top; padding-bottom: 10px; padding-top: 10px; font-size: 12px; color: \
#999999; text-align: center;">
<span class="apple-link" style="color: #999999; font-size: 12px; \
text-align: center;"> This email was sent to you from Gilles Darold. It was delivered \
on their behalf by the PostgreSQL project. Any questions about the content of the \
message should be sent to Gilles Darold.
</span>
<br><br>
You were sent this email as a subscriber of the <em>pgsql-announce</em> mailinglist, \
for the content tag Related Open Source.
To unsubscribe from
further emails, or change which emails you want to receive, please click the personal \
unsubscribe link that you can find in the headers of this email, or visit
<a href="https://lists.postgresql.org/unsubscribe/" style="color: #3498db; \
text-decoration: underline">https://lists.postgresql.org/unsubscribe/</a>.
</td>
</tr>
</table>
</div>
</div>
</td>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> </tr>
</table>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic