Re: [HACKERS] Possible changes to pg_restore

2010-01-25 Thread Andrew Dunstan
Tom Lane wrote: writes: 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? You should probably go back and look at

Re: [HACKERS] Possible changes to pg_restore

2010-01-25 Thread Tom Lane
writes: > 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? You should probably go back and look at the archives from the la

[HACKERS] Possible changes to pg_restore

2010-01-25 Thread hywel
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 fu