Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D6D789FA0B7 for ; Sun, 10 Dec 2006 17:16:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 46100-05 for ; Sun, 10 Dec 2006 17:16:29 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web57101.mail.re3.yahoo.com (web57101.mail.re3.yahoo.com [216.252.111.114]) by postgresql.org (Postfix) with SMTP id BE8A69FA430 for ; Sun, 10 Dec 2006 17:16:32 -0400 (AST) Received: (qmail 50966 invoked by uid 60001); 10 Dec 2006 21:16:31 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=hu+5xaG80uMwgMYibt431mwUUBAIuu3POasUI+pmXjW1178oHWNIbWRAbF8CYCp/5AYNJikXsdf7hmNOKI38c+qNgKa8T4sD6/5r81sNhBrgcSHYlS3r/VtRBTPuUSlvcfJ9jBlLF/xkQ84k9Lz88uoXsmCRSkML1OzpI8T5AWI=; X-YMail-OSG: YdV5WHwVM1nuFHycRW2TF2fwrhP68T6dN5O54hADzzxi5gYBG2lHRgpeOwdAReG3UDzXqnKOTBMggeqebeGpkbO8Lm.B6OsV7PLbOnqhdeGryTjdaGJyHg-- Received: from [67.121.144.170] by web57101.mail.re3.yahoo.com via HTTP; Sun, 10 Dec 2006 13:16:31 PST Date: Sun, 10 Dec 2006 13:16:31 -0800 (PST) From: Abu Mushayeed Subject: Database crashed - novice error To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1701093245-1165785391=:50734" Content-Transfer-Encoding: 8bit Message-ID: <626081.50734.qm@web57101.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.967 tagged_above=0 required=5 tests=BAYES_20, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_10_20, HTML_MESSAGE X-Spam-Level: *** X-Archive-Number: 200612/140 X-Sequence-Number: 23932 --0-1701093245-1165785391=:50734 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello, Please I need help. My database was recovering and I had done a immediate shutdown. Now when I started the the DB it says the following: 2006-12-10 13:01:24 PSTLOG: database system was interrupted while in recovery at 2006-12-10 12:15:59 PST 2006-12-10 13:01:24 PSTHINT: This probably means that some data is corrupted and you will have to use the last bac kup for recovery. 2006-12-10 13:01:24 PSTLOG: checkpoint record is at 6CA/E3ABE478 2006-12-10 13:01:24 PSTLOG: redo record is at 6CA/E3A1B418; undo record is at 0/0; shutdown FALSE 2006-12-10 13:01:24 PSTLOG: next transaction ID: 66457863; next OID: 296050688 2006-12-10 13:01:24 PSTLOG: next MultiXactId: 1; next MultiXactOffset: 0 2006-12-10 13:01:24 PSTLOG: database system was not properly shut down; automatic recovery in progress 2006-12-10 13:01:24 PSTLOG: redo starts at 6CA/E3A1B418 2006-12-10 13:01:42 PSTphatcherbdc_oz[local]FATAL: the database system is starting up 2006-12-10 13:01:42 PSTphatcherbdc_oz[local]FATAL: the database system is starting up 2006-12-10 13:01:42 PSTphatcherbdc_oz[local]FATAL: the database system is starting up 2006-12-10 13:01:42 PSTphatcherbdc_oz[local]FATAL: the database system is starting up 2006-12-10 13:01:43 PSTphatcherbdc_oz[local]FATAL: the database system is starting up 2006-12-10 13:03:02 PSTLOG: record with zero length at 6CA/EFB82244 2006-12-10 13:03:02 PSTLOG: redo done at 6CA/EFB82208 2006-12-10 13:03:10 PSTLOG: database system is ready 2006-12-10 13:03:10 PSTLOG: transaction ID wrap limit is 1139621728, limited by database "bdc_oz" Please help me, with this. Thanks Abu Mushayeed --------------------------------- Access over 1 million songs - Yahoo! Music Unlimited. --0-1701093245-1165785391=:50734 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello,

Please I need help. My database was recovering and I had done a immediate shutdown. Now when I started the the DB it says the following:

2006-12-10 13:01:24 PSTLOG:  database system was interrupted while in recovery at 2006-12-10 12:15:59 PST
2006-12-10 13:01:24 PSTHINT:  This probably means that some data is corrupted and you will have to use the last bac
kup for recovery.
2006-12-10 13:01:24 PSTLOG:  checkpoint record is at 6CA/E3ABE478
2006-12-10 13:01:24 PSTLOG:  redo record is at 6CA/E3A1B418; undo record is at 0/0; shutdown FALSE
2006-12-10 13:01:24 PSTLOG:  next transaction ID: 66457863; next OID: 296050688
2006-12-10 13:01:24 PSTLOG:  next MultiXactId: 1; next MultiXactOffset: 0
2006-12-10 13:01:24 PSTLOG:  database system was not properly shut down; automatic recovery in progress
2006-12-10 13:01:24 PSTLOG:  redo starts at 6CA/E3A1B418
2006-12-10 13:01:42 PSTphatcherbdc_oz[local]FATAL:  the database system is starting up
2006-12-10 13:01:42 PSTphatcherbdc_oz[local]FATAL:  the database system is starting up
2006-12-10 13:01:42 PSTphatcherbdc_oz[local]FATAL:  the database system is starting up
2006-12-10 13:01:42 PSTphatcherbdc_oz[local]FATAL:  the database system is starting up
2006-12-10 13:01:43 PSTphatcherbdc_oz[local]FATAL:  the database system is starting up
2006-12-10 13:03:02 PSTLOG:  record with zero length at 6CA/EFB82244
2006-12-10 13:03:02 PSTLOG:  redo done at 6CA/EFB82208
2006-12-10 13:03:10 PSTLOG:  database system is ready
2006-12-10 13:03:10 PSTLOG:  transaction ID wrap limit is 1139621728, limited by database "bdc_oz"

Please help me, with this.

Thanks
Abu Mushayeed


Access over 1 million songs - Yahoo! Music Unlimited. --0-1701093245-1165785391=:50734--