Postgres Pro
Downloads
Home   >   mailing lists

BUG #13647: Error after upgrade 9.3->9.4: materialized view `foo` has not been populated - Mailing list pgsql-bugs

From beni@strivewire.com
Subject BUG #13647: Error after upgrade 9.3->9.4: materialized view `foo` has not been populated
Date
Msg-id 20150928090804.1426.34235@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      13647
Logged by:          Benjamin Flesch
Email address:      beni@strivewire.com
PostgreSQL version: 9.4.4
Operating system:   Ubuntu 14.04
Description:

After upgrading using the ubuntu up_upgradecluser script, the materialized
views are not populated, resulting in errors.

I had to manually perform "REFRESH MATERIALIZED VIEW foo;" in order to fix
this issue.

It would be nice if the upgrade script also refreshed materialized views in
the future.

pgsql-bugs by date:

Previous
From: digoal@126.com
Date:
Subject: BUG #13645: pg_basebackup backup hash index & unlogged table
Next
From: Jeremy Whiting
Date:
Subject: Re: BUG #13646: Upgrading existing db from 9.2 to 9.4.4 not working using postgresql-setup.