Re: pg_dump crashes - Mailing list pgsql-general
The original server was running 9.5.14
The system I am currently testing on is 11.8
2 fields are marked as 'extended'. However if I understand correctly the table isn't actually toasted:
oid | table_schema | table_name | total_bytes | total | index | toast | table
-------+--------------------+-------------------------+--------------+------------+------------+------------+------------
19601 | public | file | 147648061440 | 138 GB | 57 GB | 8192 bytes | 80 GB
-------+--------------------+-------------------------+--------------+------------+------------+------------+------------
19601 | public | file | 147648061440 | 138 GB | 57 GB | 8192 bytes | 80 GB
On Fri, May 22, 2020 at 3:58 PM Andreas Kretschmer <andreas@a-kretschmer.de> wrote:
Am 22.05.20 um 14:37 schrieb Nico De Ranter:
> Postgres version: 9.5
which minor-version?
Can you check if the table has TOAST-Tables? Can you try to select all
columns but not TOASTed columns?
Maybe there is data-corruption only in toast-tables.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
Nico De Ranter
Operations Engineer
T. +32 16 38 72 10
eSATURNUS | T. +32 16 40 12 82 |
For Service & Support :
Support Line Belgium: +32 2 2009897
Support Line International: +44 12 56 68 38 78
Or via email : medical.services.eu@sony.com
pgsql-general by date: