Possible changes to pg_restore

From: <hywel(at)hmallett(dot)co(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Possible changes to pg_restore
Date: 2010-01-25 17:17:26
Message-ID: a03573d674ecd6021d1c9b54bab9c38e@hmallett.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2010-01-25 17:25:52 Re: commit fests
Previous Message Bruce Momjian 2010-01-25 17:12:31 Re: MySQL-ism help patch for psql