aquametalabs/aquameta

Audit usage of pg_extensions_config_dump()

erichanson opened this issue · 1 comments

PostgreSQL's pg_dump doesn't dump data in tables created by extensions, by default. To enable it, you have to call pg_catalog.pg_extension_config_dump(), per-table. They call it "config" data, making it pretty clear that first-class data within extensions is not a pattern they were going for. This is a big foot-gun: When using Aquameta, one would expect that doing a pg_dump would capture the data within its extensions. Bundle works around this, by calling the above function on every table (I hope). The rest of the extensions should as well, or we should stop using extensions all together.

Stop using extensions that contain tables/data instead.