Re: Restoration

From: vrms <vrms(at)netcologne(dot)de>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Restoration
Date: 2024-06-22 21:06:52
Message-ID: 9832caf9-81f0-4dc6-98a8-840cb872076e@netcologne.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kashif Zeeshan 2024-06-23 06:56:26 Re: Restoration
Previous Message David G. Johnston 2024-06-22 20:15:20 Re: Restoration