Stéphane Schildknecht wrote:
My goal is to migrate to 8.2.1. definitely. But as you said it, I do not want to recreate unwanted index when migrating. I want to drop them BEFORE. But, I can't just do a "drop index" command. It fails. That's why I asked for an advice to drop them or not recreate them. I would really prefer not to parse the all dump (some GB).
Try the --list and --use-list options on pg_restore. IIRC indexes are mentioned as items in that, so you should be able to comment out the one you don't want.
HTH -- Richard Huxton Archonet Ltd
