Database 'template1' vacuum

From: Natalie Wenz <nataliewenz(at)ebureau(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Database 'template1' vacuum
Date: 2016-07-26 18:08:52
Message-ID: 95F2FD17-7813-4718-B99F-165B177EA6E9@ebureau.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi!

I've encountered something I've never seen before, and I am hoping someone can help me understand what's going on behind the scenes with this vacuum/xid behavior.

ERROR: database is not accepting commands to avoid wraparound data loss in database "template1"

This error popped up right after I restarted a database that had just finished running a vacuum freeze in single user mode for the postgres database (the only database we use).
(That was in response to: ERROR: database is not accepting commands to avoid wraparound data loss in database "postgres")

I'm confused about the need to vacuum template1. All of our activity is in the database named postgres. Do all of the databases share the same set of xids? If they do, why would the single user backend vacuum not handle all of the databases at once? If all databases don't share the same set of xids, then what could be going on internally to cause template1 to run through so many xids?

(This is running on 9.5.3, if that makes a difference.)

Thanks!

Natalie

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2016-07-26 18:20:17 Re: Database 'template1' vacuum
Previous Message Jerry Sievers 2016-07-26 17:22:39 Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data?