Horton

Re: pg_upgrade and materialized views

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Claudio Freire <klaussfreire@gmail.com>
Cc: pgsql-bugs@postgresql.org
Date: 2018-02-20T21:26:59Z
Lists: pgsql-bugs 
Claudio Freire wrote:

> In the upgraded server, vacuum complained with:
> 
> INFO:  vacuuming "public.user_agents_canonical_user_agent_os"
> vacuumdb: vacuuming of database "mat" failed: ERROR:  found xmin
> 244738497 from before relfrozenxid 245830003

Wow, these checks were just added shortly before the minors released a
couple of weeks ago, and they've already found one genuine bug!  Nice.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Repair pg_upgrade's failure to preserve relfrozenxid for matviews.