Does anyone know of a way to get the output that pg_dump provides, but split
in pieces? What I would like is one file with just the schema, one file
with just the data, and one file with just indexes. To restore the data I
would then:
psql DB < schema.sql
psql DB < data.sql
psql DB < indexes.sql
This would make large schema changes much easier since you wouldn't have to
wade through the GB's of data to find the table definition statements.
Doing two dumps, one for schema and one for data, *almost* does the trick,
but because the indexes will then be created before copying the data in, the
restore operation takes eons :-(
Anyone?
Thx,
Glen Parker