W dniu 18.01.2021 o 17:19, Laurenz Albe pisze:
> On Mon, 2021-01-18 at 05:33 +0100, W.P. wrote:
>> For 9.5 to 9.6 transition, it worked like charm. (except some problems
>> with parsing json data in a view, but this I will address later, after
>> upgrade to final version - Fedora 30, probably PG 10.x).
>>
>> Now I have problem with 9.6 -> 10.7 (Fedora 27 -> 28) upgrade.
>> As expected after system upgrade, database fails to start "files
>> incompatible with binaries".
>>
>> Found pg_upgrade, command line options "-b
>> /usr/lib/pgsql/postgresql-9.6/bin -B /usr/bin -d /var/lib/pgsql/data/"
>> BUT what should I put for option -D? ("new cluster data") Was
>> (directory) already created for me (during system upgrade), or have I to
>> create it somewhere (where? is best practice).
>>
>> There are NO logs for today trial to start in
>> /var/lib/pgsql/data/pg_log/. Where they could be?
> You would call "initdb" or "postgresql-10-setup" to create a new, empty
> cluster in version 10 and use that with -D.
Ok, so "step-by-step":
1), I copy / move "somewhere" OLD DB files (*/pgsql/data/* for -d option),
2). Do initdb / postgresql-10-setup to create NEW empty base (in
/var/lib/pgsql/ or somewhere, for -D option),
3). do pg_upgrade.
Is that correct?
Is there somewhere "guide for 9.x -> 10.x CONCEPTS changes (and upgrade)
guide"? (clusters etc).
Laurent
> Yours,
> Laurenz Albe