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@xxxxxxxxxxxxx] Sent: Friday, February 08, 2008 11:19 AM To: Mark Steben Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Error on CLUSTER command "Mark Steben" <msteben@xxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
