Restoring 9.1 db from crashed disk/VM

From: robert <robert(at)redcor(dot)ch>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Restoring 9.1 db from crashed disk/VM
Date: 2021-01-02 11:49:53
Message-ID: 39f5516d-78eb-9fba-0aea-a8daa1d6b204@redcor.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Friends

I hope you had a good start into 2021.

I would like to get some advice on how to restore a 9.1 DB, of which I have the

/var/lib/postgresql

with some 20GB salvaged.

Now I find now easily usable 9.1 PostgreSQL installer anymore.

How should I proceed to get that data in a newer PG loaded?

Could I just install a 9.5 and  copy the salvaged folder into

/var/lib/postgresql/9/main

Or could I add the folder to my PG 12 installation like:

/var/lib/postgresql/12/main
                            /9/main

and tell PG 12 somehow to read the data for the PG9 folder?

Thanks for your insights

Robert

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2021-01-02 11:54:22 Re: Restoring 9.1 db from crashed disk/VM
Previous Message Alban Hertroys 2021-01-02 11:31:09 Re: Trigger with conditional predicates