pg.ddx.io pgsql-bugs@postgresql.org mailing list archive help / color / mirror / Atom feed From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: lizenko79@gmail.com
Subject: BUG #17863: Unable to restore dump 12.12 -> 15.2
Date: Wed, 22 Mar 2023 21:42:56 +0000
Message-ID: <17863-3243d0500e135b20@postgresql.org> (raw )
The following bug has been logged on the website:
Bug reference: 17863
Logged by: Andrey Lizenko
Email address: lizenko79@gmail.com
PostgreSQL version: 15.2
Operating system: Ubuntu 20.04.5 LTS
Description:
Please close, if already reported or fixed. But its too many release notes,
to check everything and, on the other hand, I suppose, that dumps might be
compatible.
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)
No other errors in logs.
Here is the table:
<db_name>=# \d+ <db_name>.consensus_estimate
Table
"<db_name>.consensus_estimate"
Column | Type | Collation | Nullable |
Default | Storage | Stats target |
Description
---------------------+------------------+-----------+----------+--------------------------------------------------------+----------+--------------+-------------
event_time | bigint | | |
| plain | |
<field_name> | text | | not null |
| extended | |
source | text | | |
| extended | |
disabled | boolean | | |
| plain | |
ext | jsonb | | |
| extended | |
sid | text | | |
| extended | |
period | text | | |
| extended | |
currency_code | text | | |
| extended | |
ymd | integer | | |
| plain | |
reference_period | text | | |
| extended | |
adjusted_eps_mean | double precision | | |
| plain | |
adjusted_eps_median | double precision | | |
| plain | |
reported_eps_mean | double precision | | |
| plain | |
reported_eps_median | double precision | | |
| plain | |
id | integer | | not null |
nextval('<db_name>.consensus_estimate_id_seq'::regclass) | plain |
|
ext_hash | uuid | | |
| plain | |
Indexes:
"idx_consensus_estimate_unique" UNIQUE, btree (<field_name>, ymd,
ext_hash)
Access method: heap
view thread (12+ messages) latest in thread
Message-ID: <17863-3243d0500e135b20@postgresql.org>
Permalink: ../17863-3243d0500e135b20@postgresql.org/
Also on: postgresql.org/message-id/17863-3243d0500e135b20@postgresql.org
copy link · copy postgr.es
reply 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: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, lizenko79@gmail.com
Subject: Re: BUG #17863: Unable to restore dump 12.12 -> 15.2
In-Reply-To: <17863-3243d0500e135b20@postgresql.org>
* 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