How to wait between PostgreSQL DB restore and reindexing?
Note that the REINDEX step only applies if you're updating an 8.3.x cluster in-place from x&lt;5 to x>=5. It does not apply for dump and restore. You do not need to perform this step for what you are doing. You won't even be using 8.3, you'll be going straight from 8.2 to 9.2 (right?). 

Also, as per the upgrade documentation, you should use the new PostgreSQL's pg_dump when preparing for an upgrade, not the old version.

That said, this really shouldn't be happening; see comments.