Re: pglister: issue with materialized view after upgrade (+ solution)

Поиск
Список
Период
Сортировка
От Célestin Matte
Тема Re: pglister: issue with materialized view after upgrade (+ solution)
Дата
Msg-id 232c6209-3755-48bd-a2e7-d400299dec4d@cmatte.me
обсуждение исходный текст
Ответ на Re: pglister: issue with materialized view after upgrade (+ solution)  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-www
> Hm. I guess the problem here is that `pg_dump -s` creates the view
> WITH NO DATA. But how exactly did you run the upgrade -- a normal
> `pg_dump` of a pglister database will include a `REFRESH MATERIALIZED
> VIEW` command right at the end. 

I used pg_upgradecluster with no additional option (sudo -u postgres pg_upgradecluster 12 main).

> This may be an issue in how pg_upgradecluster executes it perhaps?

Do you mean that the issue could be with pg_upgradecluster then?

-- 
Célestin Matte




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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: pglister: issue with materialized view after upgrade (+ solution)
Следующее
От: Daniel Gustafsson
Дата:
Сообщение: Re: Permission to allow testing harness to send error reports for pgweb directly to mailing list.