Postgres Pro
Downloads
Home   >   mailing lists

Template0 datfrozenxid age is 160million and progressing - Mailing list pgsql-general

From Rijo Roy
Subject Template0 datfrozenxid age is 160million and progressing
Date
Msg-id 1190777028.356668.1533122919329@mail.yahoo.com
Whole thread Raw
Responses Re: Template0 datfrozenxid age is 160million and progressing
List pgsql-general
Tree view
Hello Everyone, 

I am observing a steady increase in age(datfrozenxid) of template0 database in my Postgresql 10 running in a RHEL 6.9
Currently, it is at 166846989 and I am not able to vacuum the same as datallowconn is false. Thought of setting it to true and perform a vacuum freeze on the same. Before doing that, I wanted to check whether I should be worrying for something here or can I just go ahead with my plan. 

Thanks, 

pgsql-general by date:

Previous
From: ik
Date:
Subject: Adding terminal title support for psqlrc
Next
From: Adrian Klaver
Date:
Subject: Re: Adding terminal title support for psqlrc