Error while performing Vacuum

From: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Error while performing Vacuum
Date: 2019-05-02 13:19:32
Message-ID: 1556803172736-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Community,

Please find the below error which occurred after upgrading from 9.6.12 to
10.7.

postgres=# vacuum;
ERROR: found xmin 552 from before relfrozenxid 1764198765

I even tried to perform VACUUM FREEZE but again left with the same error...

I wanted to know why this error is occurring and how it can be fixed.
Please shed some light on this.

Regards,
Pavan

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Steben 2019-05-02 15:36:35 vacuum of pg_attribute and other infrastructure tables
Previous Message Jorge Torralba 2019-05-01 21:50:04 Issues with privileges carrying over after alter table owner