Permissions to UPDATE postgres extensions on managed database

1

Hello!

I’m using a Render managed postgres database (Postgres v14). I’ve enabled the Postgis extension and it works correctly.

I would like to move the tables Postgis manages into their own schema. This is supported by Postgis

It appears, though, that the postgres user that Render provides does not have permissions to modify an extension.

UPDATE pg_extension SET extrelocatable = true WHERE extname = 'postgis';

Returns

ERROR:  permission denied for table pg_extension

Attempting to grant this privilege on my user does not work either:

GRANT UPDATE on pg_extension to postgres_prod_user;

Returns

WARNING:  no privileges were granted for "pg_extension"

Is this possible, or will I need to spin up a Postgres database in a Docker container to have full control?

2

Hey Jonathan, so as a managed Postgres service there are a few limitations that we have to put in place.

What I’ll need to do is check in wth our Datastores team here to see what we can do here, obviously, via Docker you’d have full control of your PG instance but then you’d have to take care of backups etc

Regards,

John B

3

Hi Jonathan,

We currently aren’t able to provide the additional privileges here to allow you to modify the extension. If you’d like to do this, then we’d recommend a docker based service with a disk attached.

If you get a moment, would you be able to create a request for this in feedback.render.com? We can then prioritize this based on additional customer use cases and requests.

4

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.