Update DB app to include Timescale?

Questions / Help
1

Is there a way to update a current database app from flyio/postgres-flex:15.6 to the flyio/postgres-flex-timescaledb:15 image?

2

You should have a couple of options:

  1. Create a new App using the timescaledb image and use fly pg import to import your data.
  2. Update your existing Machines to use the timescaledb image, but I would probably avoid going this route if you’re working against a production cluster.
  3. Take an on-demand snapshot of your Primary and then create a new App from the snapshot. Something like this should work: fly pg create --name <app-name> --image-ref flyio/postgres-flex-timescaledb:15 --snapshot-id <snapshot-id>
3

Why would you recommend against option 2 for production clusters?

4

If you have a staging environment and have thoroughly tested the upgrade path, how to revert if anything goes awry, etc., then it should be fine.

1 Like
5

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