From: | Nico De Ranter <nico(dot)deranter(at)esaturnus(dot)com> |
---|---|
To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_dump crashes |
Date: | 2020-05-22 14:48:53 |
Message-ID: | CALVv0fad+ABttFFYw2J=tbgcaHd0sW-Heksy4YwFq9r_UNwmdg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
On Fri, May 22, 2020 at 3:58 PM Andreas Kretschmer <andreas(at)a-kretschmer(dot)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
Philipssite 5, D, box 28
3001 Leuven – Belgium
T. +32 16 40 12 82
F. +32 16 40 84 77
www.esaturnus.com
*For Service & Support :*
Support Line Belgium: +32 2 2009897
Support Line International: +44 12 56 68 38 78
Or via email : medical(dot)services(dot)eu(at)sony(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Nico De Ranter | 2020-05-22 14:55:20 | Re: pg_dump crashes |
Previous Message | Adrian Klaver | 2020-05-22 14:47:15 | Re: pg_dump crashes |