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
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? |