During a YugabyteDB PostgreSQL 15 upgrade pre-check, you may encounter an error similar to: Performing Consistency Checks on Old Live Server SQL […]
Read More
Fix pgcrypto Installed in pg_catalog Before a YugabyteDB v2024.2 to v2025.x Upgrade
Upgrading YugabyteDB from v2024.2 to v2025.2 includes a YSQL major-version upgrade from PostgreSQL 11 to PostgreSQL 15. YugabyteDB Anywhere runs a precheck […]
Read MoreAutomate Duplicate Regional Indexes on pg_partman Partitions in YugabyteDB
Follow-up tip: This tip builds on Preserve Regional Index Tablespaces with pg_partman Templates, which demonstrates how a custom pg_partman template can preserve […]
Read MoreInherit Regional Tablespaces with pg_partman in YugabyteDB v2025.1 and Later
Version scope: This tip applies to YugabyteDB v2025.1 and later, where the YSQL API is based on PostgreSQL 15. For YugabyteDB v2024.2 […]
Read More