I'm going to upgrade several PostgreSQL 8 databases to version 13. The people I work for come from SQL Server. I've been looking for a tool similar to "DMA", specifically the part that lists deprecated features and "breaking changes". They want a report to estimate times. They love reports. Docx's and xlsx's everywhere.
Asked
Active
Viewed 2,703 times
1 Answers
3
Each PostgreSQL version has a section “Migration to Version xy” section in the base release part of appendix E of the documentation. This is where the incompatibilities to the previous release are enumerated. Here is a link to this for version 12.
You have to read through all of these sections for all of the base releases between 8.x and 13. Sure, that's a lot of changes, but that's to be expected for such a jump. My tip is not to spend too much time with this huge list, most of which you won't understand. Rather, invest a lot of time in testing.
Laurenz Albe
- 61,070
- 4
- 55
- 90