Dimitri,
On Saturday, November 30, 2013, Dimitri Fontaine wrote:
The current extension model is simple enough to reason about. A script
must be provided in a template and is executed at CREATE EXTENSION time
or at ALTER EXTENSION UPDATE time, and pg_dump only contains the CREATE
EXTENSION command, so that pg_restore has to find the template again.
I understand that folks have complained about pg_dump/restore knowing "too much" about extensions, but I do not find that a compelling argument- it's being made from the perspective that an extension is defined by files on the file system. Perhaps that means that what we're talking about aren't extensions, but in that case, such arguments do not make much sense.
Thanks,
Stephen