Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
How To Set Database-Wide Parameters In Managed PostgreSQL
I would like to enable some features in a PostgreSQL database. I am able to create a database cluster, and inside that cluster I can create a user
newuser and a database
newdb. While using
psql connected to the new database as the new user, I can run commands like
CREATE EXTENSION postgis; and
SET postgis.gdal_enabled_drivers = 'GTiff';. However, I cannot set that parameter as a database-wide parameter as either the new user or
doadmin with the command
ALTER DATABASE newdb SET postgis.gdal_enabled_drivers = 'GTiff'; as I get the following error:
ERROR: permission denied to set parameter "postgis.gdal_enabled_drivers".
doadmin is the owner of
newdb, and we don’t get superuser access to these databases as far as I know.
How can I set this parameter?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×