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.
Click below to sign up and get $100 of credit to try our products over 60 days!