Canceling REINDEX safe?

From: "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Canceling REINDEX safe?
Date: 2015-02-17 13:52:56
Message-ID: trinity-dcda198e-8dd8-446f-9ec3-f9d0baeb1135-1424181176500@3capp-gmx-bs46
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I wonder whether canceling a REINDEX of a database is safe ( PostgreSQL v9.2.7 ). In the server log there's just the error message that the REINDEX statement has been canceled without details.
Is the index that has been worked on when canceling okay or can it be incomplete or even get lost?

I don't see anything regarding this:
http://www.postgresql.org/docs/9.2/static/sql-reindex.html

Thank you very much in advance!

Best regards,

Peter

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2015-02-17 15:13:19 Re: Canceling REINDEX safe?
Previous Message Albe Laurenz 2015-02-17 10:56:57 Re: PostgreSQL File System Based Backup Restartability