Greg Sabino Mullane recently shared a script to split schema-only dump files into a table creation file and a trigger/index/constraint file, for restore performance reasons. (http://blog.endpoint.com/2010/01/splitting-postgres-pgdump-into-pre-and.html)
Would it be possible and worthwhile to add functionality to pg_restore so that with one switch triggers/indexes/constraints could be ignored, and with another switch only triggers/indexes/constraints would be restored? This would then remove the requirement to split the file. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
