Message-ID: <644e1420-829e-4ac4-80b2-650688c91685@netcologne.de>
Date: Sun, 23 Jun 2024 12:42:28 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Restoration
To: Wasim Devale <wasimd60@gmail.com>
Cc: pgsql-admin@postgresql.org
References: 
 <CAB5fag7RM0e_Owi3JrYmMyX727XyBZereCDssSNTuMvNL-iADA@mail.gmail.com>
 <CAAPsdhd4EaUUC9HxmA+iimgvixbvPOzFb7iVGzzmscs8BCNrZA@mail.gmail.com>
 <CAB5fag79Nzd9HrAu4jy32-9+xHmNsMayDXmBLtQj8g-TjgArtQ@mail.gmail.com>
Content-Language: en-US
From: vrms <vrms@netcologne.de>
In-Reply-To: 
 <CAB5fag79Nzd9HrAu4jy32-9+xHmNsMayDXmBLtQj8g-TjgArtQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/644e1420-829e-4ac4-80b2-650688c91685%40netcologne.de>
Precedence: bulk


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