X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 912D5D70BF for ; Mon, 12 Sep 2005 08:29:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88865-06 for ; Mon, 12 Sep 2005 11:29:53 +0000 (GMT) Received: from newgen.co.in (mx.newgen.co.in [202.131.146.227]) by svr1.postgresql.org (Postfix) with SMTP id B3F7CD7B26 for ; Mon, 12 Sep 2005 08:29:50 -0300 (ADT) Received: (qmail 5441 invoked by uid 507); 12 Sep 2005 11:29:53 -0000 Received: from 202.140.41.205 by mx.newgen.co.in (envelope-from , uid 501) with qmail-scanner-1.25 (fireav: ???. spamassassin: 3.0.3. Clear:RC:0(202.140.41.205):SA:0(-99.4/5.0):. Processed in 1.957893 secs); 12 Sep 2005 11:29:53 -0000 Received: from unknown (HELO ngmail.newgen.co.in) (okhlaoffice@202.140.41.205) by mx.newgen.co.in with SMTP; 12 Sep 2005 11:29:50 -0000 Received: (qmail 9355 invoked by uid 504); 12 Sep 2005 11:36:07 -0000 Received: from yogvinder@newgen.co.in by ngmail.newgen.co.in by uid 501 with qmail-scanner-1.21 (fireav: ???. Clear:RC:1(192.168.5.86):. Processed in 3.112456 secs); 12 Sep 2005 11:36:07 -0000 Received: from unknown (HELO ng3054) (192.168.5.86) by 192.168.5.243 with SMTP; 12 Sep 2005 11:36:03 -0000 Message-ID: <006f01c5b78d$38ad2430$5605a8c0@ng3054> From: "Yogvinder Singh" To: Subject: index error :- index ------ not a btree Date: Mon, 12 Sep 2005 16:59:13 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006C_01C5B7BB.4D47DDD0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at hub.org X-Amavis-Alert: BAD HEADER MIME error: error: part did not end with expected boundary X-Spam-Status: No, hits=1.443 required=5 tests=[AWL=0.797, DNS_FROM_RFC_ABUSE=0.374, HTML_MESSAGE=0.001, MIME_MISSING_BOUNDARY=0.247, RCVD_BY_IP=0.024] X-Spam-Level: * X-Archive-Number: 200509/108 X-Sequence-Number: 18845 This is a multi-part message in MIME format. ------=_NextPart_000_006C_01C5B7BB.4D47DDD0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi, =20 i am facing the above quoted error " index ---- not a btree". Scenario here is=20 1) installation of Postgres7.3 2) creation of database using initdb 3) creation and population of some tables using a sql script=20 4) reboot after reboot when i do vacuumdb -f -z -U postgres -d postgres (previously created database) vacuumdb -f -z -U postgres -d ispcab (previously created database) vacuumdb for ispcab gives error pg_toast_??? not a btree. i have scanned through previous posts to find out that this is due to = reboot occuring without database server properly shut down and on = restart ...indexes get corrupted. but here the situation is a bit diffrent if i put a delay of around 120s between the two vacuum commands, = everything works fine. Can anyone help me on that. its urgent Thanks in advance Yogvinder Singh ------=_NextPart_000_006C_01C5B7BB.4D47DDD0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
hi,    
     i am = facing the above=20 quoted error " index ---- not a btree".
    Scenario here is =
1) installation of = Postgres7.3
2) creation of database using = initdb
3) creation and population of some = tables using a=20 sql script
4) reboot
 
after reboot when i do
vacuumdb -f -z=20 -U postgres -d postgres (previously created database)
vacuumdb -f -z = -U=20 postgres -d ispcab (previously created database)
vacuumdb for=20 ispcab gives error pg_toast_??? not a btree.
 
i have scanned=20 through previous posts to find out that this is due to reboot occuring = without=20 database server properly shut down and on restart ...indexes get=20 corrupted.
 
but here the situation is a bit=20 diffrent
if i put a delay of around 120s between the two=20 vacuum commands, everything = works=20 fine.
Can anyone help me on that. its = urgent
 
Thanks in advance
Yogvinder Singh
 
 


 
------=_NextPart_000_006C_01C5B7BB.4D47DDD0--