Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D754C2E31A6 for ; Fri, 8 Feb 2008 12:26:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 03442-01-4 for ; Fri, 8 Feb 2008 12:25:52 -0400 (AST) Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id 311EC2E318D for ; Fri, 8 Feb 2008 12:25:52 -0400 (AST) Received: (qmail 1066 invoked from network); 8 Feb 2008 11:26:42 -0500 Received: from unknown (HELO dei26g028575) (msteben@10.10.1.20) by mail.autorevenue.com with SMTP; 8 Feb 2008 11:26:42 -0500 From: "Mark Steben" To: "'Tom Lane'" Cc: Subject: Re: Error on CLUSTER command Date: Fri, 8 Feb 2008 11:25:40 -0500 Message-ID: <00b101c86a6f$3eef3f80$14010a0a@dei26g028575> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 thread-index: AchqbnfdslE6XeIsTji0NA54SBbNsAAAGS5w In-Reply-To: <1645.1202487544@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/100 X-Sequence-Number: 28174 The number may change pointing to another index or stay the same. The error persists if I repeat 3 or 4 times. Usually after the 4th or 5th time the cluster is successful. What is the risk of performing an upgrade to 7.4.19? -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Friday, February 08, 2008 11:19 AM To: Mark Steben Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Error on CLUSTER command "Mark Steben" writes: > I am getting the following error when I attempt to CLUSTER on a table: > mavmail=# cluster mailer_queue; > ERROR: could not create relation "pg_temp_752992924": File exists If you repeat the command, does the error persist? Does the number stay the same? > Again we are running 7.4.5. Tsk tsk. Why not 7.4.19, or at least some reasonably recent 7.4.x update? regards, tom lane