Re: pg_upgrade and materialized views

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Claudio Freire <klaussfreire(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_upgrade and materialized views
Date: 2018-02-20 21:26:59
Message-ID: 20180220212659.db4d3lq7aw2xj2at@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2018-02-20 21:27:44 Re: pg_upgrade and materialized views
Previous Message Claudio Freire 2018-02-20 21:13:26 pg_upgrade and materialized views