Re: pg_dump crashes
От | Adrian Klaver |
---|---|
Тема | Re: pg_dump crashes |
Дата | |
Msg-id | 1c99b45f-0e84-52fe-40d3-107182522daa@aklaver.com обсуждение исходный текст |
Ответ на | Re: pg_dump crashes (Nico De Ranter <nico.deranter@esaturnus.com>) |
Ответы |
Re: pg_dump crashes
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: