Of course, I was planning to upgrade but as with most things, too little, too late...
At this point, I just want to keep it running until I can move to my planned new platform. Can you tell me where to start with CHECKPOINT? If it's any help, my problem appears to be a missing file. This is from my pg_log: DEBUG: database system was shut down at 2004-04-07 12:14:38 CDT DEBUG: CheckPoint record at (1, 516646732) DEBUG: Redo record at (1, 516646732); Undo record at (0, 0); Shutdown TRUE DEBUG: NextTransactionId: 28728439; NextOid: 9098648 FATAL 2: ZeroFill(/var/lib/pgsql/data/pg_xlog/xlogtemp.1091) failed: No such file or directory /usr/bin/postmaster: Startup proc 1091 exited with status 512 - abort Thanks Tom Bakken Information Resource Manager Texas USDA, Rural Development -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 2:46 PM To: Tom Bakken Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Out of space "Tom Bakken" <[EMAIL PROTECTED]> writes: > I'm not finding any mention of CHECKPOINT in my references. Is that > something from a version newer than 7.1.2? You're running 7.1.2? My, that *is* an old installation. You really ought to think about an update, particularly if you might be approaching the 4-billion-transaction event horizon. You do not want to suffer XID wraparound in a 7.1 installation :-(. See this link for explanations: http://www.postgresql.org/docs/7.4/static/maintenance.html#VACUUM-FOR-WRAPAR OUND 7.1 does have the CHECKPOINT command, though, whether you see it documented or not. regards, tom lane
BEGIN:VCARD VERSION:2.1 N:Bakken;Tom FN:[EMAIL PROTECTED] ORG:Texas State Office TEL;WORK;VOICE:(254) 742-9726 TEL;WORK;FAX:(254) 742-9709 ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;101 South Main=0D=0ASuite 102;Temple;TX;76502;United States of America LABEL;WORK;ENCODING=QUOTED-PRINTABLE:101 South Main=0D=0ASuite 102=0D=0ATemple, TX 76502=0D=0AUnited States of Am= erica EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20040301T143942Z END:VCARD
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend