Re: Restoration

Yes I have followed the same approach as you mentioned. I am stuck with the
postgis extension installation as it has many dependencies for postgresql
12 to create an extension on RHEL 9.

Actually we are migrating from centOS7 to RHEL 9.

Thanks,
Wasim

On Sun, 23 Jun, 2024, 4:11 pm vrms, <vrms(at)netcologne(dot)de> wrote:

>
>
> On 6/23/24 12:02 PM, Wasim Devale wrote:
> >
> > So I can work with the minor version upgrade. I can restore postgresql
> > 12.8 backup from barman to postgresql 12.19 I hope I will get it done.
> > Thanks
> >
>
> not sure whether my last response came through
>
> >> 1. barman creates a physical copy of the data directory
> >> 2. the data directory does work for the version it was created with
> via initdb
> so you can not just run your pg12 restore on a pg13 instance
> >> 3. restoring the data directory plus running pg_upgrade should do
> the job though
>
> so #3 would be the thing I'd try
>
> - restore the backup from v12 to a temporary directory into your
> server runnig v12 AND v13
> - run pg_upgrade
>
>
> if you don't know how that works in detail let us know
>
> regards
> Gunnar
>