Re: Odd pg dump error: cache lookup failure

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Odd pg dump error: cache lookup failure
Дата
Msg-id 20200824231621.GA29590@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Odd pg dump error: cache lookup failure  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: Odd pg dump error: cache lookup failure  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Odd pg dump error: cache lookup failure
Следующее
От: Thomas Kellerer
Дата:
Сообщение: How to debug logical replication error "columns are missing" if they are not