Re: migrating from Oracle to PostgreSQL 11

[Ryan Lambert <ryan@xxxxxxxxxxxxxxxxx>]

On Thu, Jul 11, 2019 at 1:28 AM Hitesh Chadda <hkumarchadda@xxxxxxxxx> wrote:

Hello,

The target is PostgreSQL 10.1. I would like to know possible approach that can be followed for doing the migration.

Regards

H.kumar

 

10.9 is the current release in Pg10 and contains multiple security fixes over 10.1. There is no good reason to start a new project on an outdated minor release with known security issues. 

https://why-upgrade.depesz.com/show?from=10.1&to=10.9&keywords= 

 

As Gavin asked, why not start on Pg11 with 11.4 being the current release?

Ryan Lambert