From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | Mihalidesová Jana <jana(dot)mihalidesova(at)cetin(dot)cz>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Upgrade to 12.2 using same data directory |
Date: | 2020-02-25 14:35:45 |
Message-ID: | f1382512f2e6f288c4c246a01d1b2501f6c7d431.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 2020-02-25 at 11:58 +0000, Mihalidesová Jana wrote:
> Is there possibility to upgrade from 10.6 to 12.2 using exact same data directory?
> First problem is with initialing of “new” cluster. Then pg_upgrade check fail.
>
> ./pg_upgrade -b $OLD/bin -B $NEWd/bin -d $OLD -D $OLD -k -c
No, but that is not necessary.
- Create a new cluster on the same file system as the old one.
- Run "pg_upgrade" with the -k option.
- Remove the old cluster and move the new one in the place of
the old one.
- Start the server (with the new binaries of course).
Don't forget to ANALYZE.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
From | Date | Subject | |
---|---|---|---|
Next Message | Josef Šimánek | 2020-02-25 14:41:07 | Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] |
Previous Message | Miles Elam | 2020-02-25 14:35:24 | Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] |