Hiya,
Due to us specifying the schema ... and hence passing '-n' to pg_dump it doesn't include extensions
(see https://dba.stackexchange.com/questions/297985/pg-dump-is-not-including-extensions)
For my use this means the generated script won't run.
My backup is 60+Gb so editing the file is a pain.
I think we could add a flag to opt into including extensions for a schema in the dump file.
This would mean querying the schema to get the extensions and inject the code into the dump file somewhere near the top... after the schema have been created.
Hiya,
Due to us specifying the schema ... and hence passing '-n' to pg_dump it doesn't include extensions
(see https://dba.stackexchange.com/questions/297985/pg-dump-is-not-including-extensions)
For my use this means the generated script won't run.
My backup is 60+Gb so editing the file is a pain.
I think we could add a flag to opt into including extensions for a schema in the dump file.
This would mean querying the schema to get the extensions and inject the code into the dump file somewhere near the top... after the schema have been created.