From: | Keith <keith(at)keithf4(dot)com> |
---|---|
To: | Killian Driscoll <killiandriscoll(at)gmail(dot)com> |
Cc: | pgsql-novice(at)lists(dot)postgresql(dot)org |
Subject: | Re: Open version 9.3 .out file with version 12 |
Date: | 2020-09-15 15:32:17 |
Message-ID: | CAHw75vvq1-YMHgk5k6BTD51tPb1BZYKEkY_0chX0144micm_dQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, Sep 15, 2020 at 11:00 AM Killian Driscoll <killiandriscoll(at)gmail(dot)com>
wrote:
> I have a backup of a small database last used in 2016, with the backup
> saved as an .out file and .sql file in version 9.3. I no longer have
> PostgreSQL installed. I want to access the database again, and see that
> version 9.3 is not supported. Can I download version 12 and restore the
> file, or should I install version 9.3?
>
> Regards,
>
> Killian DriscoIl
>
>
pg_restore does its best to be backwards compatible to try and load old
dump files. So I would just try it and see with PG12.
However, there is a chance, depending on what was in that old version, that
it may not restore without error. In that case, you could bring up a 9.3
cluster and restore the dump there. Then use the pg_dump binary from PG12
to create a new dump. The newer pg_dump binaries running on old servers try
and convert things as needed.
From | Date | Subject | |
---|---|---|---|
Next Message | Keith | 2020-09-15 16:27:22 | Re: Open version 9.3 .out file with version 12 |
Previous Message | Killian Driscoll | 2020-09-15 15:00:07 | Open version 9.3 .out file with version 12 |