Re: best migration solution

2024-04-25 Thread Georg H.
Hello Markus, keep it simple. Use a restored backup of the source db or this db itself and then Am 25.04.2024 um 09:55 schrieb Zwettler Markus (OIZ): we have to migrate from hosted PG12 to containerized PG16 on private cloud. some of the installed PG12 extensions are not offered on the

Re: best migration solution

2024-04-25 Thread Ron Johnson
On Thu, Apr 25, 2024 at 3:55 AM Zwettler Markus (OIZ) < markus.zwett...@zuerich.ch> wrote: > we have to migrate from hosted PG12 to containerized PG16 on private > cloud. > > > > some of the installed PG12 extensions are not offered on the containerized > PG16, eg. PostGIS related extensions like

Re: best migration solution

2024-04-25 Thread Kashif Zeeshan
On Thu, Apr 25, 2024 at 12:55 PM Zwettler Markus (OIZ) < markus.zwett...@zuerich.ch> wrote: > we have to migrate from hosted PG12 to containerized PG16 on private > cloud. > > > > some of the installed PG12 extensions are not offered on the containerized > PG16, eg. PostGIS related extensions

best migration solution

2024-04-25 Thread Zwettler Markus (OIZ)
we have to migrate from hosted PG12 to containerized PG16 on private cloud. some of the installed PG12 extensions are not offered on the containerized PG16, eg. PostGIS related extensions like pg_routing and ogr_fdw. some of these extensions are not needed anymore. some of these extensions were