Thanks everyone for @Erik yes dumping the data and restore on the target will work but we have like 900 servers , like 5 thousand databases and we use ansible for all deployments so to do dump and restore will be cumbersome that is the reason we are looking into pg_upgrade.
On Tue, Jul 25, 2023 at 1:58 PM Erik Serrano <eserranos@gmail.com> wrote: > > Dear, > Very old versions will never have the new features that current applications have, which will always fail when you want to migrate, so I advise you... look, there is an official postgresql page where you can see the compatibility between versions and after that, mount the PG14 version on a destination server and only export the schemas, users and data. > Then you check your applications and if everything goes well, that's it... or you can do a POC with what I'm telling you before doing it in a productive environment > I hope it works for you, regards > > > > Erik R. Serrano Saavedra > Ingeniero de Sistemas Informáticos > Data Base Administrator > eserranos@gmail.com > 998596691 > > > El vie, 21 jul 2023 a las 4:23, Ilya Kosmodemiansky (<ik@dataegret.com>) escribió: >> >> Hi Roland, >> >> On Fri, Jul 21, 2023 at 9:39 AM Roland Che <rolandngwa31@gmail.com> wrote: >> > >> > Hello all >> > i am trying to upgrade from postgres 9.6 to the latest minor version of 14. >> >> Upgrading Postgres from such an old version with postgis is a bit >> tricky. In order to upgrade to Postgres version 13 you need to upgrade >> postgis extension to version 3.0, otherwise your postgis would be >> broken, and you would need to transfer data logically which is not a >> nice experience. >> >> for Postgis 3.0 PostgreSQL 9.5 or higher is required, so you can >> upgrade Postgis according to documentation and then do a Postgres >> upgrade. >> >> Best regards, >> Ilya >> >> > And we have a couple of extensions inclusing postgis . >> > We have postgis 2.3 as seen below: >> >> > >> > >> >>