Re: Odd pg dump error: cache lookup failure - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Odd pg dump error: cache lookup failure
Date
Msg-id 20200824231338.GA30623@alvherre.pgsql
Whole thread Raw
In response to Re: Odd pg dump error: cache lookup failure  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: Odd pg dump error: cache lookup failure  (Stephen Frost <sfrost@snowman.net>)
List pgsql-admin
On 2020-Aug-24, Wells Oliver wrote:

> 12.4. Both of those queries return no rows, with and without those options
> set.
> 
> We do do some nightly processing of data during the same window, in which
> views are re-materialized: would that cause this issue? No non-temporary
> tables are dropped or re-created, though.

Oh, so this could be some kind of relation that exists when pg_dump
starts but is dropped before it reaches the point where it dumps the
data for that relation.

Hmm.


-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: Odd pg dump error: cache lookup failure
Next
From: Stephen Frost
Date:
Subject: Re: Odd pg dump error: cache lookup failure