Our production DB shut down because of it: <2007-08-06 09:44:08 MDT>LOG: background writer process (PID 24439) exited with exit code 0 <2007-08-06 09:44:08 MDT>LOG: terminating any other active server processes <2007-08-06 09:44:08 MDT>LOG: all server processes terminated; reinitializing <2007-08-06 09:44:08 MDT>LOG: database system was shut down at 2007-08-06 09:44:08 MDT <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>LOG: checkpoint record is at 1A7/4C987A2C <2007-08-06 09:44:08 MDT>LOG: redo record is at 1A7/4C987A2C; undo record is at 0/0; shutdown TRUE <2007-08-06 09:44:08 MDT>LOG: next transaction ID: 2146747335; next OID: 677503791 <2007-08-06 09:44:08 MDT>LOG: next MultiXactId: 2937; next MultiXactOffset: 5901 <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>LOG: database system is ready <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>LOG: transaction ID wrap limit is 2147484146, limited by database "template0" <2007-08-06 09:44:08 MDT>WARNING: database "template0" must be vacuumed within 736811 transactions <2007-08-06 09:44:08 MDT>HINT: To avoid a database shutdown, execute a full-database VACUUM in "template0". <2007-08-06 09:44:08 MDT>LOG: shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down <2007-08-06 09:44:08 MDT>LOG: database system is shut down
-----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, August 06, 2007 9:51 AM To: Keaton Adams Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Template zero xid issue "Keaton Adams" <[EMAIL PROTECTED]> writes: > Our template 0 database has an XID issue: No, it doesn't. template0 never needs vacuuming. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
