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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: lizenko79(at)gmail(dot)com
Subject: BUG #17863: Unable to restore dump 12.12 -> 15.2
Date: 2023-03-22 21:42:56
Message-ID: 17863-3243d0500e135b20@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17863
Logged by: Andrey Lizenko
Email address: lizenko79(at)gmail(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2023-03-23 02:26:18 BUG #17864: pg_notify is publishing message twice
Previous Message David Rowley 2023-03-22 21:03:11 Re: BUG #17862: Overall query cost ignores window function