Re: pg_dump crashes

On 5/22/20 7:48 AM, Nico De Ranter wrote:
> 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

What query are you using to get above?

> 
> 
> On Fri, May 22, 2020 at 3:58 PM Andreas Kretschmer 
> <andreas@a-kretschmer.de <mailto: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 <http://www.2ndQuadrant.com>
> 
> 
> 
> 
> 
> -- 
> 
> Nico De Ranter
> 
> Operations Engineer
> 
> T. +32 16 38 72 10
> 
> 
> <http://www.esaturnus.com>
> 
> <http://www.esaturnus.com>
> 
> 
> eSATURNUS
> Philipssite 5, D, box 28
> 3001 Leuven – Belgium
> 
>     
> 
> T. +32 16 40 12 82
> F. +32 16 40 84 77
> www.esaturnus.com <http://www.esaturnus.com>
> 
> ** <http://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.services.eu@sony.com 
> <mailto:medical.services.eu@sony.com>
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com