Question

How do I use Timescale DB with Managed Postgres in App Platform

I was reading the tutorial on how to download timescaleDB on Ubuntu, but it did not seem to provide instructions on how to use on a Postgres managed database that is spun up from the app platform PaaS. Is this possible or do I need to setup a managed DB external to app platform ie. on TimescaleDB website and allow a connection to that via my app?

Submit an answer
Answer a question...

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

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.

Bobby Iliev
Site Moderator
Site Moderator badge
• May 3, 2022

Hello,

There has been a similar question asked here:

https://www.digitalocean.com/community/questions/timescale-db-in-managed-pgsql

Basically, TimescaleDB is available as a PostgreSQL extension on DigitalOcean Managed database cluster.

You can install supported extensions with psql’s CREATE EXTENSION command:

CREATE EXTENSION <extension-name>;

You can also see a list of available extensions from the psql’s command line, use the following command:

SELECT * FROM pg_available_extensions;

For more information on Postgres extension and limitations, please check the below URL:

https://docs.digitalocean.com/products/databases/postgresql/details/supported-extensions/

Hope that this helps.

Regards,

Bobby