BUG #17863: Unable to restore dump 12.12 -> 15.2 - Mailing list pgsql-bugs
From | PG Bug reporting form |
---|---|
Subject | BUG #17863: Unable to restore dump 12.12 -> 15.2 |
Date | |
Msg-id | 17863-3243d0500e135b20@postgresql.org Whole thread Raw |
Responses |
Re: BUG #17863: Unable to restore dump 12.12 -> 15.2
Re: BUG #17863: Unable to restore dump 12.12 -> 15.2 |
List | pgsql-bugs |
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
pgsql-bugs by date: