[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-bugs
Subject: Re: BUG #17863: Unable to restore dump 12.12 -> 15.2
From: Andrey Lizenko <lizenko79 () gmail ! com>
Date: 2023-03-27 14:38:40
Message-ID: CADKuZZD6fKQxMrA8=ioe4YUqO0NmefdjjpDHiMOS5rMOCUQU_Q () mail ! gmail ! com
[Download RAW message or body]
Sorry, have a typo here - files from №2 and №4 are the same
On Mon, 27 Mar 2023 at 16:36, Andrey Lizenko <lizenko79@gmail.com> wrote:
> Workaround in few steps:
> 1. *12.12*
>
>> pg_dump -Fc -Z 9 -v -f ./<db_name>_20230322.dmp <db_name>
>
>
> 2. *12.12*
>
>> pg_restore --file=<db_name>_20230322.sql -vOx <db_name>_20230322.dmp
>
>
> 3. *15.2*
>
>> postgres@nerva:~$ psql
>> psql (15.2 (Ubuntu 15.2-1.pgdg20.04+1))
>> Type "help" for help.
>> postgres=# \c <db_name>
>> You are now connected to database " <db_name>" as user "postgres".
>
>
> 4. *15.2*
>
>> \i <db_name>_20230323.sql
>
>
>
> On Mon, 27 Mar 2023 at 11:17, Andrey Lizenko <lizenko79@gmail.com> wrote:
>
>> If you use 12.12's pg_restore to convert the .dmp file to a text file
>>> (using
>>> the --file=somefile, instead of -h/-d), does that work?
>>
>>
>> (just to be sure, that it is not a typo)
>> The idea is to make a dump then start pg_restore in *12.12 to itself?*
>>
>> On Fri, 24 Mar 2023 at 22:27, Andres Freund <andres@anarazel.de> wrote:
>>
>>> Hi,
>>>
>>> On 2023-03-22 21:42:56 +0000, PG Bug reporting form wrote:
>>> > 12.12
>>> > pg_dump -Fc -Z 9 -v -f ./<db_name>_20230322.dmp <db_name>
>>> >
>>> > 15.2
>>> > pg_restore -U <user_name> -h 127.0.0.1 -v -d ./<db_name>_20230322.dmp
>>> >
>>> > In short:
>>> > pg_restore: processing data for table "<db_name>.consensus_estimate"
>>> > pg_restore: error: could not uncompress data: (null)
>>>
>>> If you use 12.12's pg_restore to convert the .dmp file to a text file
>>> (using
>>> the --file=somefile, instead of -h/-d), does that work?
>>>
>>> Greetings,
>>>
>>> Andres Freund
>>>
>>>
>>>
>>
>> --
>> Regards, Andrei Lizenko
>>
>
>
> --
> Regards, Andrei Lizenko
>
--
Regards, Andrei Lizenko
[Attachment #3 (text/html)]
<div dir="ltr">Sorry, have a typo here - files from №2 and №4 are the \
same</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, 27 \
Mar 2023 at 16:36, Andrey Lizenko <<a \
href="mailto:lizenko79@gmail.com">lizenko79@gmail.com</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div \
dir="ltr">Workaround in few steps:<div>1. <b>12.12</b></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"> pg_dump -Fc -Z 9 -v -f \
./<db_name>_20230322.dmp <db_name></blockquote><div> </div><div>2. \
<b>12.12</b></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> pg_restore \
--file=<db_name>_20230322.sql -vOx
<db_name>_20230322.dmp</blockquote><div> </div><div>3. \
<b>15.2</b></div><div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">postgres@nerva:~$ \
psql<br>psql (15.2 (Ubuntu 15.2-1.pgdg20.04+1))<br>Type "help" for \
help.<br>postgres=# \c <db_name><br>You are now connected to database "
<db_name>" as user "postgres".</blockquote><br>4.
<b>15.2</b></div><div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">\i
<db_name>_20230323.sql</blockquote><br></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, 27 Mar 2023 at 11:17, \
Andrey Lizenko <<a href="mailto:lizenko79@gmail.com" \
target="_blank">lizenko79@gmail.com</a>> wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr"><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex">If you use 12.12's pg_restore to convert the \
.dmp file to a text file (using<br>the --file=somefile, instead of -h/-d), does that \
work?</blockquote><div><br></div><div>(just to be sure, that it is not a typo) \
<br>The idea is to make a dump then start pg_restore in <b>12.12 to \
itself?</b></div></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Fri, 24 Mar 2023 at 22:27, Andres Freund <<a \
href="mailto:andres@anarazel.de" target="_blank">andres@anarazel.de</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi,<br> <br>
On 2023-03-22 21:42:56 +0000, PG Bug reporting form wrote:<br>
> 12.12 <br>
> pg_dump -Fc -Z 9 -v -f ./<db_name>_20230322.dmp <db_name><br>
> <br>
> 15.2<br>
> pg_restore -U <user_name> -h 127.0.0.1 -v -d \
./<db_name>_20230322.dmp<br> > <br>
> In short:<br>
> pg_restore: processing data for table \
"<db_name>.consensus_estimate"<br> > pg_restore: error: could not \
uncompress data: (null)<br> <br>
If you use 12.12's pg_restore to convert the .dmp file to a text file (using<br>
the --file=somefile, instead of -h/-d), does that work?<br>
<br>
Greetings,<br>
<br>
Andres Freund<br>
<br>
<br>
</blockquote></div><br clear="all"><div><br></div><span>-- </span><br><div \
dir="ltr"><div dir="ltr"><div><div dir="ltr"><div><div>Regards, Andrei \
Lizenko</div></div></div></div></div></div> </blockquote></div><br \
clear="all"><div><br></div><span>-- </span><br><div dir="ltr"><div \
dir="ltr"><div><div dir="ltr"><div><div>Regards, Andrei \
Lizenko</div></div></div></div></div></div> </blockquote></div><br \
clear="all"><div><br></div><span class="gmail_signature_prefix">-- </span><br><div \
dir="ltr" class="gmail_signature"><div dir="ltr"><div><div \
dir="ltr"><div><div>Regards, Andrei Lizenko</div></div></div></div></div></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic