OK thanks Tom
-----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: 30 August 2006 14:48 To: Nigel Bishop Cc: [email protected] Subject: Re: [ADMIN] Some advice required please "Nigel Bishop" <[EMAIL PROTECTED]> writes: > Selecting from pg_database shows the following: > datname | datvacuumxid | datfrozenxid > ----------------+--------------+-------------- > template1 | 2160549932 | 1086808109 > template0 | 427 | 427 > live01.db | 427 | 427 > stage01.db | 2153231186 | 1079489364 The numbers for template1 and stage01.db look reasonable (but perhaps you just recently vacuumed them?). What the message is probably complaining about is that live01.db has seemingly never been vacuumed. You can ignore template0, it's not supposed to be touched, but the others all need vacuuming every so often. > Could someone advise me on how to reset the datvacuumxid on the > template1 DB (I don't think it should be this high), also is the message > about data loss really implying that we may have lost data? Yes, otherwise we'd not bother to emit it. regards, tom lane Communications on or through ioko's computer systems may be monitored or recorded to secure effective system operation and for other lawful purposes. Unless otherwise agreed expressly in writing, this communication is to be treated as confidential and the information in it may not be used or disclosed except for the purpose for which it has been sent. If you have reason to believe that you are not the intended recipient of this communication, please contact the sender immediately. No employee is authorised to conclude any binding agreement on behalf of ioko with another party by e-mail without prior express written confirmation. ioko365 Ltd. VAT reg 656 2443 31. Reg no 3048367. All rights reserved. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
