Re: pg_dump crashes

2020-06-02 Thread Nico De Ranter
e help anyway. Nico On Mon, May 25, 2020 at 4:20 PM Adrian Klaver wrote: > On 5/24/20 10:30 PM, Nico De Ranter wrote: > > Unfortunately not. I discovered the issue rather late. The last working > > backup is about 2 months old. > > Well first it is entirely possible this is

Re: pg_dump crashes

2020-05-24 Thread Nico De Ranter
Unfortunately not. I discovered the issue rather late. The last working backup is about 2 months old. On Fri, May 22, 2020 at 5:36 PM Adrian Klaver wrote: > On 5/22/20 8:17 AM, Nico De Ranter wrote: > > > > > > On Fri, May 22, 2020 at 5:14 PM Adrian Klaver > <mailt

Re: pg_dump crashes

2020-05-22 Thread Nico De Ranter
On Fri, May 22, 2020 at 5:14 PM Adrian Klaver wrote: > On 5/22/20 8:05 AM, Nico De Ranter wrote: > > > > > > > Assuming the above matches: > > > > COPY public.file (fileid, fileindex, jobid, pathid, filenameid, > > del

Re: pg_dump crashes

2020-05-22 Thread Nico De Ranter
On Fri, May 22, 2020 at 5:09 PM Adrian Klaver wrote: > On 5/22/20 8:05 AM, Nico De Ranter wrote: > > > > On Fri, May 22, 2020 at 5:02 PM Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote: > > > > On 5/22/20 7:55 AM, Nico De Ranter wrote: >

Re: pg_dump crashes

2020-05-22 Thread Nico De Ranter
On Fri, May 22, 2020 at 5:07 PM Adrian Klaver wrote: > 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 und

Re: pg_dump crashes

2020-05-22 Thread Nico De Ranter
On Fri, May 22, 2020 at 5:02 PM Adrian Klaver wrote: > On 5/22/20 7:55 AM, Nico De Ranter wrote: > > Correct. > > > > If I run 'pg_dumpall --cluster 11/main --file=dump.sql' the end of the > > file looks like: > > > > ## cut here > &g

Re: pg_dump crashes

2020-05-22 Thread Nico De Ranter
ct that I do see a number of regular lines following this may suggest it's just garbage in the table but not really causing the issue afterall. Nico On Fri, May 22, 2020 at 4:47 PM Adrian Klaver wrote: > On 5/22/20 6:40 AM, Nico De Ranter wrote: > > I was just trying that.

Re: pg_dump crashes

2020-05-22 Thread Nico De Ranter
3:58 PM Andreas Kretschmer 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-corrupt

Re: pg_dump crashes

2020-05-22 Thread Nico De Ranter
.conf' -O ' -c config_file=/etc/postgresql/11/main/postgresql.conf' On Fri, May 22, 2020 at 3:35 PM Adrian Klaver wrote: > On 5/22/20 5:37 AM, Nico De Ranter wrote: > > Hi all, > > > > Postgres version: 9.5 > > OS: Ubuntu 18.04.4 > >

Re: pg_dump crashes

2020-05-22 Thread Nico De Ranter
ops. Nico On Fri, May 22, 2020 at 3:27 PM Adrian Klaver wrote: > On 5/22/20 5:37 AM, Nico De Ranter wrote: > > Hi all, > > > > Postgres version: 9.5 > > OS: Ubuntu 18.04.4 > > > > I have a 144GB Bacula database that crashes the postgres daemon when I > >

pg_dump crashes

2020-05-22 Thread Nico De Ranter
how to fix or debug this? Nico -- 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.esat