RSSAmplifier

Matt Blewitt · Jun 30, 2024

Modifying pg_dump To Exclude Event Triggers

0
Sign in to vote or save

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

At $WORK , we have a case where we have implemented an event trigger to prevent customers from dropping an extension. As this extension is part of contrib and normally installed by users, we can’t prevent them from dropping it normally. However, event triggers can only be created by superusers, so a pg_dump of the database creates a dump that can’t be restored by a non-superuser. To…

Read on matt.blwt.io

Comments

Nothing yet. Say the first thing.

    Sign in to join the conversation.