[PSA] Don't Use Postgres 14
For the time being, don't use Postgres 14 in staging and production environment.
Who is this announcement for?
Backend engineers responsible for database development
What do you need to do?
If you plan to provision new RDS using or upgrading existing RDS to Postgres 14, consider using Postgres 13 (maximum 13.7) instead.
Why is this needed?
- Based on this link and postgres mailing list, Postgres 14.0 to 14.3 has a bug where CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY might drop entries, resulting in corrupted index. This should be fixed in Postgres 14.4, but we have no idea when will this version be available in AWS
- We want to push migration from RDS to Aurora Serverless v2, and for now Aurora Serverless v2 is only available for Postgres 13.6 and 13.7
Question/Concerns?
You can contact @christianto.handojo or @fajrin for inquiries about this matter