Permission issue while installing timescaledb extension in managed database
I am trying to install an extension named timescaledb in a Linode's managed Postgres database. However, I am getting permission issue as -
ERROR: permission denied to create extension "timescaledb"
HINT: Must be superuser to create this extension.
I have read in the documentation that some extensions are not compatible. However, timescaledb seems to be compatible.
Please let me know if it is possible to create this extension without superuser, or is it even possible.
To get the
timescaledb extension installed on your Managed PostgreSQL Database, you will need to reach out to the Support Team with the extension name, the name of the database you want the extension installed on, and your use case. The same is true for several other compatible extensions for your PostgreSQL database.
This information is noted in the PostgreSQL Extensions Guide.