I'm dealing with an older PostgreSQL database running on version 9.2.15. I aim to upgrade it to the latest version 16.1 without losing data if possible. Should I perform incremental updates to major versions in between ? If so, which specific versions should I consider in the process ?
Any feedback would be appreciated. Thanks.