Postgres Pro
Downloads
Home   >   mailing lists

Re: AutoVacuum and growing transaction XID's - Mailing list pgsql-general

From Michael Lewis
Subject Re: AutoVacuum and growing transaction XID's
Date
Msg-id CAHOFxGok4H++SHLq50v8wp5FmnTe-9+EzJs9jS7uAT68XBOKZA@mail.gmail.com
Whole thread Raw
In response to AutoVacuum and growing transaction XID's  (github kran <githubkran@gmail.com>)
Responses Re: AutoVacuum and growing transaction XID's
Re: AutoVacuum and growing transaction XID's
List pgsql-general
Tree view
It is trying to do a vacuum freeze. Do you have autovacuum turned off? Any settings changed from default related to autovacuum?

Read 24.1.5. Preventing Transaction ID Wraparound Failures


Note that you need to ensure the server gets caught up, or you risk being locked out to prevent data corruption.

pgsql-general by date:

Previous
From: github kran
Date:
Subject: AutoVacuum and growing transaction XID's
Next
From: Tory M Blue
Date:
Subject: Odd postgres12 upgrade is changing or munging a password?