CODEWITHSUNDEEP
postgresqltimescaledbpg-dumppg-upgrade
cooljack
cooljack

Reputation: 1

upgrade of Postgres 12.3 /Timescaledb 2.5.1 , very large database of 30TB to PG 16.2 /timescaledb 2.14

We have a very large Postgres database on version 12.3 with timescaledb version 2.5.1. Size of db ~30 TB **# of entries in _timescaledb_internal = ~1.7 million. (chunks for historical data). **# of tables ~8000 **

We tried pg_dump, it doesn't complete in ~24+ hrs, it gets stuck in reading the catalog information. We tried pg_upgrade from Pg 12.3 to PG 16.2 takes for ever and ends up failing for different reasons every time.

We want to upgrade to latest Postgres version 16.x with timescaledb version 2.14 or later.

What options are best to achieve for such large database ?

Upvotes: 0

Views: 86

Answers (0)

Related Questions