Horton

Re: pg_restore --no-post-data and --post-data-only

Josh Berkus <josh@agliodbs.com>

View thread
From: Josh Berkus <josh@agliodbs.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Andrew Dunstan <andrew@dunslane.net>, pgsql-hackers <pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>, Alvaro Herrera <alvherre@commandprompt.com>, Jim Nasby <jim@nasby.net>
Date: 2011-12-07T14:03:03Z
Lists: pgsql-hackers 
>> Note that this feature has the odd effect that some constraints are loaded at the same time as the tables and some are loaded with the post-data.  This is consistent with how text-mode pg_dump has always worked, but will seem odd to the user.  This also raises the possibility of a future pg_dump/pg_restore optimization.
> 
> That does seem odd.  Why do we do it that way?

Beats me.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com