3

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.

1 Answers1

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