From: | "W(dot)P(dot)" <laurentp(at)wp(dot)pl> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org, laurenz(dot)albe(at)cybertec(dot)at |
Subject: | Re: System (and DB) upgrade problem., "part 2" |
Date: | 2021-01-18 04:33:05 |
Message-ID: | 6262bd4a-5d11-f0ec-0727-d6a0c10fb7f5@wp.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
W dniu 13.01.2021 o 12:28, Laurenz Albe pisze:
> On Wed, 2021-01-13 at 07:41 +0100, W.P. wrote:
>> I am upgrading Fedora 24 to (now) 26, PostgreSQL stopped starting (as
>> expected), the message from systemctl was to do "postgresql-setup
>> --upgrade".
>>
>> Did installed the tool, loaunched.
>>
>> But it fails with (attached logs) messages, I am missing some libraries,
>> what should I install?
> The logs complain about missing the "dblink" library, so you forgot to install
> the -contrib package.
>
> Remember to REINDEX all indexes on string columns, because the collations
> may have changed.
>
> Yours,
> Laurenz Albe
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?
Laurent
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2021-01-18 08:17:05 | Re: Code of Conduct plan,Re: Code of Conduct plan |
Previous Message | Benedict Holland | 2021-01-17 23:09:48 | Re: Is it possible to compare a long text string and fuzzy match only phrases contained in? |