Glyn Astill wrote: > One thing I forgot to mention is that in the restore script I drop the > indexes off my tables between restoring the schema and the data. I've always > done this to speed up the restore, but is there any chance this could be > causing the issue?
Uh. Why are you doing that? pg_restore is supposed to restore the schema, then data, finally indexes and other stuff. Are you using separate schema/data dumps? If so, don't do that -- it's known to be slower. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general