Re: pg_dump crashes - Mailing list pgsql-general

From Adrian Klaver
Subject Re: pg_dump crashes
Date
Msg-id 9424642a-a1ff-7d2e-9f8f-ec4e6d50ca4e@aklaver.com
Whole thread Raw
In response to Re: pg_dump crashes  (Nico De Ranter <nico.deranter@esaturnus.com>)
List pgsql-general
On 5/22/20 8:13 AM, Nico De Ranter wrote:
> 
> 

> 
> 
> bacula=# SELECT md5 FROM public.file where fileid = 4557430888798830399;
>   md5
> -----
> (0 rows)
> So that fileid is bogus too (max(bigint) I assume)

No:

select 4557430888798830399::bigint;
         int8
---------------------
  4557430888798830399
(1 row)

It means it cannot find that fileid. I putting that down to file corruption.


> 
> -- 
> 
> Nico De Ranter
> 
>
-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query returns no rows in pg_basebackup cluster
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dump crashes