pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #16973: Backward compatibility: pg_restore: [archiver] unsupported version (1.14) in file header
3+ messages / 3 participants
[nested] [flat]
* BUG #16973: Backward compatibility: pg_restore: [archiver] unsupported version (1.14) in file header
@ 2021-04-20 07:17 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: PG Bug reporting form @ 2021-04-20 07:17 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: frankaen@gmail.com
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #16973: Backward compatibility: pg_restore: [archiver] unsupported version (1.14) in file header
@ 2021-04-20 18:48 Tom Lane <tgl@sss.pgh.pa.us>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2021-04-20 18:48 UTC (permalink / raw)
To: frankaen@gmail.com; +Cc: pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #16973: Backward compatibility: pg_restore: [archiver] unsupported version (1.14) in file header
@ 2021-04-21 08:31 Piotr F. <frankaen@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Piotr F. @ 2021-04-21 08:31 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-bugs@lists.postgresql.org
<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>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-04-21 08:31 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-04-20 07:17 BUG #16973: Backward compatibility: pg_restore: [archiver] unsupported version (1.14) in file header PG Bug reporting form <noreply@postgresql.org>
2021-04-20 18:48 ` Tom Lane <tgl@sss.pgh.pa.us>
2021-04-21 08:31 ` Piotr F. <frankaen@gmail.com>
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