Skip to content

Extensions don't get dumped #110

@nigelatdas

Description

@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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions