pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRestoration
8+ messages / 4 participants
[nested] [flat]
* Restoration
@ 2024-06-22 20:11 Wasim Devale <wasimd60@gmail.com>
0 siblings, 3 replies; 8+ messages in thread
From: Wasim Devale @ 2024-06-22 20:11 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>; pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Restoration
@ 2024-06-22 20:15 David G. Johnston <david.g.johnston@gmail.com>
parent: Wasim Devale <wasimd60@gmail.com>
2 siblings, 0 replies; 8+ messages in thread
From: David G. Johnston @ 2024-06-22 20:15 UTC (permalink / raw)
To: Wasim Devale <wasimd60@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>; pgsql-admin
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?
>
>
>
https://docs.pgbarman.org/release/3.10.1/#requirements-for-recovery
David J.
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Restoration
@ 2024-06-22 21:06 vrms <vrms@netcologne.de>
parent: Wasim Devale <wasimd60@gmail.com>
2 siblings, 0 replies; 8+ messages in thread
From: vrms @ 2024-06-22 21:06 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Restoration
@ 2024-06-23 06:56 Kashif Zeeshan <kashi.zeeshan@gmail.com>
parent: Wasim Devale <wasimd60@gmail.com>
2 siblings, 1 reply; 8+ messages in thread
From: Kashif Zeeshan @ 2024-06-23 06:56 UTC (permalink / raw)
To: Wasim Devale <wasimd60@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>; pgsql-admin
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 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
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Restoration
@ 2024-06-23 10:02 Wasim Devale <wasimd60@gmail.com>
parent: Kashif Zeeshan <kashi.zeeshan@gmail.com>
0 siblings, 2 replies; 8+ messages in thread
From: Wasim Devale @ 2024-06-23 10:02 UTC (permalink / raw)
To: kashi.zeeshan@gmail.com; +Cc: pgsql-admin@lists.postgresql.org; pgsql-admin
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:
> 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 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
>>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Restoration
@ 2024-06-23 10:42 vrms <vrms@netcologne.de>
parent: Wasim Devale <wasimd60@gmail.com>
1 sibling, 1 reply; 8+ messages in thread
From: vrms @ 2024-06-23 10:42 UTC (permalink / raw)
To: Wasim Devale <wasimd60@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Restoration
@ 2024-06-23 10:54 Wasim Devale <wasimd60@gmail.com>
parent: vrms <vrms@netcologne.de>
0 siblings, 0 replies; 8+ messages in thread
From: Wasim Devale @ 2024-06-23 10:54 UTC (permalink / raw)
To: vrms@netcologne.de; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Restoration
@ 2024-06-23 12:41 Kashif Zeeshan <kashi.zeeshan@gmail.com>
parent: Wasim Devale <wasimd60@gmail.com>
1 sibling, 0 replies; 8+ messages in thread
From: Kashif Zeeshan @ 2024-06-23 12:41 UTC (permalink / raw)
To: Wasim Devale <wasimd60@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org; pgsql-admin
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:
>
>> 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 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
>>>
>>
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2024-06-23 12:41 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-06-22 20:11 Restoration Wasim Devale <wasimd60@gmail.com>
2024-06-22 20:15 ` David G. Johnston <david.g.johnston@gmail.com>
2024-06-22 21:06 ` vrms <vrms@netcologne.de>
2024-06-23 06:56 ` Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-06-23 10:02 ` Wasim Devale <wasimd60@gmail.com>
2024-06-23 10:42 ` vrms <vrms@netcologne.de>
2024-06-23 10:54 ` Wasim Devale <wasimd60@gmail.com>
2024-06-23 12:41 ` Kashif Zeeshan <kashi.zeeshan@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox