BUG #16973: Backward compatibility: pg_restore: [archiver] unsupported version (1.14) in file header
The following bug has been logged on the website:
Bug reference: 16973
Logged by: Piotr F
Email address: frankaen@gmail.com
PostgreSQL version: 10.16
Operating system: Ubuntu 20.04 LTS
Description:
Hello,
Full dump created on April 12, 2021, default Ubuntu 18.04 LTS, cannot be
restored on April 19, with the current output:
psql --version
psql (PostgreSQL) 10.16 (Ubuntu 10.16-1.pgdg20.04+1)
pg_restore returns:
pg_restore: [archiver] unsupported version (1.14) in file header
PostgreSQL server installed all along with the OpenProject installation.
Sorry for being brief, I am not a developer, if needed, I will be happy to
provide with more info, just let me know which one, and how to get the
necessary output.
Cheers,
Piotr
PG Bug reporting form <noreply@postgresql.org> writes:
Full dump created on April 12, 2021, default Ubuntu 18.04 LTS, cannot be
restored on April 19, with the current output:
psql --version
psql (PostgreSQL) 10.16 (Ubuntu 10.16-1.pgdg20.04+1)
pg_restore returns:
pg_restore: [archiver] unsupported version (1.14) in file header
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
<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&utm_content=emailclient" 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&utm_content=emailclient" 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>