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

From: Célestin Matte <celestin(dot)matte(at)cmatte(dot)me>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: PostgreSQL WWW <pgsql-www(at)lists(dot)postgresql(dot)org>
Subject: Re: pglister: issue with materialized view after upgrade (+ solution)
Date: 2023-10-09 12:31:16
Message-ID: 232c6209-3755-48bd-a2e7-d400299dec4d@cmatte.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-www by date

  From Date Subject
Next Message Daniel Gustafsson 2023-10-09 12:42:09 Re: Permission to allow testing harness to send error reports for pgweb directly to mailing list.
Previous Message Magnus Hagander 2023-10-06 22:15:04 Re: pglister: issue with materialized view after upgrade (+ solution)