Re: BUG #17863: Unable to restore dump 12.12 -> 15.2

From: Andrey Lizenko <lizenko79(at)gmail(dot)com>
To: daniel(at)yesql(dot)se
Cc: pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17863: Unable to restore dump 12.12 -> 15.2
Date: 2023-03-23 11:30:20
Message-ID: CADKuZZC04-7BR_tUL-cb6X_ybXxWs8HMBF5MBGfCcYP8-CEN5w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

(copying here as it was a misclick about "reply all" button)

I'll try to, but even plain text dump didn't work
>
>
> psql:<db_name>_20230323.sql:5672327: ERROR: extra data after last
> expected column
> CONTEXT: COPY alpha_beta, line 3828998: "1643415437295 SRSR
> MORN1661692859461 NODK MORNINGSTAR f
> {"fiscalYearEndMonth": "12"} 0P00019YC1 0C00..."

I can check md5sum if there is an idea about network issue.

On Thu, 23 Mar 2023 at 10:43, Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:

> > On 22 Mar 2023, at 22:42, PG Bug reporting form <noreply(at)postgresql(dot)org>
> wrote:
>
> > pg_restore: processing data for table "<db_name>.consensus_estimate"
> > pg_restore: error: could not uncompress data: (null)
>
> This error indicates, as it clearly states, a failure to decompress the
> compressed file, but it's a bit worrying that the error is (null) since
> this
> really should report an error. Handling an empty ->msg seems like
> something we
> maybe should do.
>
> Does dumping/restoring any database in your cluster work? Is it just this
> one
> that fails?
>
> --
> Daniel Gustafsson
>
>

--
Regards, Andrei Lizenko

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Gustafsson 2023-03-23 11:31:58 Re: BUG #17863: Unable to restore dump 12.12 -> 15.2
Previous Message Daniel Gustafsson 2023-03-23 09:42:57 Re: BUG #17863: Unable to restore dump 12.12 -> 15.2