Extensions don't get dumped

[nigelatdas]

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.

[nigelatdas]

I'll investigate

[junkert]

Hi @nigelatdas, did you happen to get any of this working? I was going to start looking into this as we should definitely dump the extensions into the dump file as well to simplify loading.

[nigelatdas]

sorry. No. It dropped in priority locally.

…

On Wed, 22 Mar 2023 at 06:31, Levi ***@***.***> wrote: Hi @nigelatdas <https://github.com/nigelatdas>, did you happen to get any of this working? I was going to start looking into this as we should definitely dump the plugins into the dump file as well to simplify loading. — Reply to this email directly, view it on GitHub <#110 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AV3WT6A3EXWU3DRVDL6U5ATW5H6XRANCNFSM57N7ZIQA> . You are receiving this because you were mentioned.Message ID: ***@***.***>