Each release of TimescaleDB is compatible with specific versions of PostgreSQL. Over time support is added for a newer version of PostgreSQL while simultaneously dropping support for older versions.
When the supported versions of PostgreSQL changes, you may need to upgrade the version of the PostgreSQL instance (for example, from 10 to 12) before you can install the latest release of TimescaleDB.
To upgrade PostgreSQL, you have two choices, as outlined in the PostgreSQL online documentation.
pg_upgrade is a tool that avoids the need to dump all data and then import it
into a new instance of PostgreSQL after a new version is installed. Instead,
pg_upgrade allows you to
retain the data files of your current PostgreSQL installation while binding the new PostgreSQL binary
runtime to them. This is currently supported for all releases 8.4 and greater.
pg_upgrade -b oldbindir -B newbindir -d olddatadir -D newdatadir"
pg_upgrade is not an option, such as moving data to a new physical instance of PostgreSQL, using the
tried and true method of dumping all data in the database and then restoring into a database in the new instance
is always supported with PostgreSQL and TimescaleDB.
Please see our documentation on Backup & Restore strategies for more information.
Found an issue on this page?Report an issue!