Re: Odd pg dump error: cache lookup failure

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Odd pg dump error: cache lookup failure
Date: 2020-08-24 23:13:38
Message-ID: 20200824231338.GA30623@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephen Frost 2020-08-24 23:16:21 Re: Odd pg dump error: cache lookup failure
Previous Message Wells Oliver 2020-08-24 20:06:59 Re: Odd pg dump error: cache lookup failure