How to enable extensions in self hosted
self-hostedCLIHello, what is the recommended way of enabling extensions in a self hosted instance programmatically (I use self hosted for integration testing)? If I do it in a migration file, I get the following error:
ERROR: permission denied for function pg_read_file (SQLSTATE 42501)
At statement: 0
-- Enable pgmq extension for message queuing
CREATE EXTENSION IF NOT EXISTS pgmq
ERROR: permission denied for function pg_read_file (SQLSTATE 42501)
At statement: 0
-- Enable pgmq extension for message queuing
CREATE EXTENSION IF NOT EXISTS pgmq
