Thread: Restoration
Hi All
Can I restore backup from barman which has postgresql 12 version's backup to postgresql 13? Will the extension's work. Please advise or any suggestions.
I have RHEL 9 version Linux and postgresql 12 not highly compatible with it.
Thanks,
Wasim
On Saturday, June 22, 2024, Wasim Devale <wasimd60@gmail.com> wrote:
Can I restore backup from barman which has postgresql 12 version's backup to postgresql 13?
David J.
hi, On 6/22/24 10:11 PM, Wasim Devale wrote: > Can I restore backup from barman which has postgresql 12 version's > backup to postgresql 13? Will the extension's work. Please advise or > any suggestions. without being 100% certain, I would say ... 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
Hi
Barman does the file level backup so you cant use backup taken from one Majore PG version and restore and use it with another PG Major Version.
Regards
Kashif Zeeshan
On Sun, Jun 23, 2024 at 1:11 AM Wasim Devale <wasimd60@gmail.com> wrote:
Hi AllCan I restore backup from barman which has postgresql 12 version's backup to postgresql 13? Will the extension's work. Please advise or any suggestions.I have RHEL 9 version Linux and postgresql 12 not highly compatible with it.Thanks,Wasim
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
On Sun, 23 Jun, 2024, 12:26 pm Kashif Zeeshan, <kashi.zeeshan@gmail.com> wrote:
HiBarman does the file level backup so you cant use backup taken from one Majore PG version and restore and use it with another PG Major Version.RegardsKashif ZeeshanOn Sun, Jun 23, 2024 at 1:11 AM Wasim Devale <wasimd60@gmail.com> wrote:Hi AllCan I restore backup from barman which has postgresql 12 version's backup to postgresql 13? Will the extension's work. Please advise or any suggestions.I have RHEL 9 version Linux and postgresql 12 not highly compatible with it.Thanks,Wasim
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
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@netcologne.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
On Sun, Jun 23, 2024 at 3:02 PM Wasim Devale <wasimd60@gmail.com> 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
With minor version upgrade it will work.
On Sun, 23 Jun, 2024, 12:26 pm Kashif Zeeshan, <kashi.zeeshan@gmail.com> wrote:HiBarman does the file level backup so you cant use backup taken from one Majore PG version and restore and use it with another PG Major Version.RegardsKashif ZeeshanOn Sun, Jun 23, 2024 at 1:11 AM Wasim Devale <wasimd60@gmail.com> wrote:Hi AllCan I restore backup from barman which has postgresql 12 version's backup to postgresql 13? Will the extension's work. Please advise or any suggestions.I have RHEL 9 version Linux and postgresql 12 not highly compatible with it.Thanks,Wasim