From: vrms <vrms@netcologne.de>
To: Wasim Devale <wasimd60@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Restoration
Date: Sun, 23 Jun 2024 12:42:28 +0200
Message-ID: <644e1420-829e-4ac4-80b2-650688c91685@netcologne.de> (raw)
In-Reply-To: <CAB5fag79Nzd9HrAu4jy32-9+xHmNsMayDXmBLtQj8g-TjgArtQ@mail.gmail.com>
References: <CAB5fag7RM0e_Owi3JrYmMyX727XyBZereCDssSNTuMvNL-iADA@mail.gmail.com>
<CAAPsdhd4EaUUC9HxmA+iimgvixbvPOzFb7iVGzzmscs8BCNrZA@mail.gmail.com>
<CAB5fag79Nzd9HrAu4jy32-9+xHmNsMayDXmBLtQj8g-TjgArtQ@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vrms@netcologne.de, wasimd60@gmail.com
Subject: Re: Restoration
In-Reply-To: <644e1420-829e-4ac4-80b2-650688c91685@netcologne.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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