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

From Stephen Frost
Subject Re: Odd pg dump error: cache lookup failure
Date
Msg-id 20200824231621.GA29590@tamriel.snowman.net
Whole thread Raw
In response to Re: Odd pg dump error: cache lookup failure  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Odd pg dump error: cache lookup failure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Greetings,

* Alvaro Herrera (alvherre@2ndquadrant.com) wrote:
> 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.

That'd be cute since pg_dump should be locking all the relations that
it's going to export the data from...

Thanks,

Stephen

Attachment

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Odd pg dump error: cache lookup failure
Next
From: Thomas Kellerer
Date:
Subject: How to debug logical replication error "columns are missing" if they are not