Re: System (and DB) upgrade problem., "part 2"
От | W.P. |
---|---|
Тема | Re: System (and DB) upgrade problem., "part 2" |
Дата | |
Msg-id | d9b3667f-2ed6-e771-716e-a49eb2c606c7@wp.pl обсуждение исходный текст |
Ответ на | Re: System (and DB) upgrade problem., "part 2" (Laurenz Albe <laurenz.albe@cybertec.at>) |
Ответы |
Re: System (and DB) upgrade problem., "part 2"
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: