Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> writes: > It seems that you have to actually restore the 2 backup separately. > > pg_restore -1 -d mydb < nearly_full.bak > pg_restore -1 -d mydb < schema_only.bak > > I can't think of any other way to restore both in one transaction > unless I backup in plain text. But that should have other drawback. > > Any hint? In general what I do is backup it all then filter at restore time, editing the restore catalog (see pg_restore options -l and -L). Incidentally I've written code for automating this for me, that's called pg_staging and is available at github and already is in debian (I miss a source release so that RPM will follow): http://github.com/dimitri/pg_staging Regards, -- dim -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
