From: Piotr F. <frankaen@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16973: Backward compatibility: pg_restore: [archiver] unsupported version (1.14) in file header
Date: Wed, 21 Apr 2021 10:31:20 +0200
Message-ID: <d7763887-38dd-089d-6bff-ef34a32168b5@gmail.com> (raw)
In-Reply-To: <632958.1618944492@sss.pgh.pa.us>
References: <16973-399e0677315a26a6@postgresql.org>
<632958.1618944492@sss.pgh.pa.us>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#2d2d2d" bgcolor="#FFFFFF">
<font face="Palatino Linotype">Hi Tom,<br>
<br>
Thanks, thought the same, but the current pg_dump and pg_restore
versions are as follows:<br>
<br>
pg_restore -V<br>
pg_restore (PostgreSQL) 10.16 (Ubuntu 10.16-1.pgdg20.04+1)<br>
pg_dump -V<br>
pg_dump (PostgreSQL) 10.16 (Ubuntu 10.16-1.pgdg20.04+1)<br>
<br>
Nothing has been changed since the last week in the postgresql
versions, including pg_dump and pg_restore.<br>
I use default OpenProject settings, including PostgreSQL, now same
10.16 for the last couple of months.<br>
<br>
Also, to make it more complex,<br>
I have restored with no problem the dump from April 8 [that was a
life-saver], made with the same pg_dump as this one used on April
12. The latest, however, cannot be restored.<br>
<br>
Best,<br>
Piotr<br>
</font><br>
<div class="moz-cite-prefix">W dniu 2021-04-20 o 20:48, Tom Lane
pisze:<br>
</div>
<blockquote type="cite" cite="mid:632958.1618944492@sss.pgh.pa.us">
<pre class="moz-quote-pre" wrap="">PG Bug reporting form <a class="moz-txt-link-rfc2396E" href="mailto:noreply@postgresql.org"><noreply@postgresql.org></a> writes:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">Full dump created on April 12, 2021, default Ubuntu 18.04 LTS, cannot be
restored on April 19, with the current output:
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">psql --version
psql (PostgreSQL) 10.16 (Ubuntu 10.16-1.pgdg20.04+1)
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">pg_restore returns:
pg_restore: [archiver] unsupported version (1.14) in file header
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
The most obvious explanation for this is that you made the dump
with a v12-or-later pg_dump, and are now trying to restore it
with a pre-v12 pg_restore. If so, the failure is expected.
regards, tom lane
</pre>
</blockquote>
<br>
<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br /> <table style="border-top: 1px solid #D3D4DE;">
<tr>
<td style="width: 55px; padding-top: 18px;"><a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&a...; target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png"; alt="" width="46" height="29" style="width: 46px; height: 29px;" /></a></td>
<td style="width: 470px; padding-top: 17px; color: #41424e; font-size: 13px; font-family: Arial, Helvetica, sans-serif; line-height: 18px;">Wolny od wirusów. <a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&a...; target="_blank" style="color: #4453ea;">www.avg.com</a> </td>
</tr>
</table>
<a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"> </a></div></body>
</html>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: frankaen@gmail.com, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16973: Backward compatibility: pg_restore: [archiver] unsupported version (1.14) in file header
In-Reply-To: <d7763887-38dd-089d-6bff-ef34a32168b5@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox