"Mark Steben" <[EMAIL PROTECTED]> writes:
> The doc says to do an initdb and reload the data whenever you run
> pg_resetxlog. Do you concur with that even if we are only resetting the OID
> counter?
The docs are thinking of the case where you are trying to recover from
database corruption. If yo
On Feb 8, 2008 1:37 PM, Mark Steben <[EMAIL PROTECTED]> wrote:
> The doc says to do an initdb and reload the data whenever you run
> pg_resetxlog. Do you concur with that even if we are only resetting the OID
> counter?
On 7.4 I'd say you'd be better off dumping and reloading all your data
than p
@postgresql.org
Subject: Re: [ADMIN] Error on CLUSTER command
"Mark Steben" <[EMAIL PROTECTED]> writes:
> 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 su
"Mark Steben" <[EMAIL PROTECTED]> writes:
> 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.
Hm. I'd guess that the installation is old enough that the OID counter
has w
]
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" <[EMAIL PROTECTED]> writes:
> I am getting the following error when I attempt to CLUSTER on a table:
> mavmail=# cluster mailer_
"Mark Steben" <[EMAIL PROTECTED]> 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 sa
Hello listers,
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
The 752992924 is the oid of one of the indexes of this table (not the
clustering index)
This app
