Search Postgresql Archives

Re: pg_dump crashes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxx> 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.services.eu@xxxxxxxx



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux