Re: Upgrade problem

2023-09-12 Thread Adrian Klaver
On 9/12/23 03:51, Graeme wrote: On 11/09/2023 17:04, Graeme wrote: Ta Graeme Gemmill Tom, Adrian, Ray: thanks for your comments. I see the problem now, trying to gat a Mga8 module to link against Mga9 libraries. I suspecy a carefully placed sym-link or two will sort the problem. I'

Re: Upgrade problem

2023-09-12 Thread Graeme
On 11/09/2023 17:04, Graeme wrote: Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg 15. I'm at the point of running pg_upgrade but have received anerror message: /mga8/usr/bin/postgres: error while loading shared libraries: libssl.so.1.1: cannot open shared object fil

Re: Upgrade problem

2023-09-12 Thread Peter J. Holzer
On 2023-09-11 17:04:54 +0100, Graeme wrote: > Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg 15. > I'm > at the point of running pg_upgrade but have received anerror message: > > /mga8/usr/bin/postgres: error while loading shared libraries: libssl.so.1.1: > cannot open sh

Re: Upgrade problem

2023-09-11 Thread Ray O'Donnell
On 11/09/2023 17:33, Graeme wrote: On 11/09/2023 17:13, Adrian Klaver wrote: On 9/11/23 09:04, Graeme wrote: Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg 15. I'm at the point of running pg_upgrade but have received anerror message: You are going to have to be more

Re: Upgrade problem

2023-09-11 Thread Adrian Klaver
On 9/11/23 09:33, Graeme wrote: On 11/09/2023 17:13, Adrian Klaver wrote: On 9/11/23 09:04, Graeme wrote: Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg 15. I'm at the point of running pg_upgrade but have received anerror message: You are going to have to be more spe

Re: Upgrade problem

2023-09-11 Thread Graeme
On 11/09/2023 17:13, Adrian Klaver wrote: On 9/11/23 09:04, Graeme wrote: Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg 15. I'm at the point of running pg_upgrade but have received anerror message: You are going to have to be more specific on the Postgres version. P

Re: Upgrade problem

2023-09-11 Thread Tom Lane
Graeme writes: > Tom, thanks: it's finding other so. files in the correct place > libpam.so.0 => /lib64/libpam.so.0 (0x7f8d49e1e000) > libssl.so.1.1 => not found > libcrypto.so.1.1 => not found > librt.so.1 => /lib64/librt.so.1 (0x7f8d49e16000) Note this only shows it looking in /lib64,

Re: Upgrade problem

2023-09-11 Thread Graeme
On 11/09/2023 17:10, Tom Lane wrote: Graeme writes: Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg 15. I'm at the point of running pg_upgrade but have received anerror message: /mga8/usr/bin/postgres: error while loading shared libraries: libssl.so.1.1: cannot open shar

Re: Upgrade problem

2023-09-11 Thread Adrian Klaver
On 9/11/23 09:04, Graeme wrote: Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg 15. I'm at the point of running pg_upgrade but have received anerror message: You are going to have to be more specific on the Postgres version. Prior to Postgres 10 major version changes w

Re: Upgrade problem

2023-09-11 Thread Tom Lane
Graeme writes: > Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg > 15. I'm at the point of running pg_upgrade but have received anerror > message: > /mga8/usr/bin/postgres: error while loading shared libraries: > libssl.so.1.1: cannot open shared object file: No such fi

Upgrade problem

2023-09-11 Thread Graeme
Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg 15. I'm at the point of running pg_upgrade but have received anerror message: /mga8/usr/bin/postgres: error while loading shared libraries: libssl.so.1.1: cannot open shared object file: No such file or directory no data

Re: System (and DB) upgrade problem., "part 2"

2021-01-18 Thread Bruce Momjian
On Mon, Jan 18, 2021 at 03:13:13PM -0600, Ron wrote: > On 1/18/21 2:58 PM, Bruce Momjian wrote: > > On Mon, Jan 18, 2021 at 09:53:33PM +0100, W.P. wrote: > [snip] > > > Ok, so "step-by-step": > > > 1), I copy / move "somewhere" OLD DB files (*/pgsql/data/* for -d option), > > > 2). Do initdb / post

Re: System (and DB) upgrade problem., "part 2"

2021-01-18 Thread David G. Johnston
On Mon, Jan 18, 2021 at 2:13 PM Ron wrote: > The documents tend to assume the reader thoroughly knows Postgresql, and > that's manifestly Not True. > Maybe not, but users are still expected to read the documentation. If there remains questions or concerns after doing so then by asking such ther

Re: System (and DB) upgrade problem., "part 2"

2021-01-18 Thread Ron
On 1/18/21 2:58 PM, Bruce Momjian wrote: On Mon, Jan 18, 2021 at 09:53:33PM +0100, W.P. wrote: [snip] 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,

Re: System (and DB) upgrade problem., "part 2"

2021-01-18 Thread Bruce Momjian
On Mon, Jan 18, 2021 at 09:53:33PM +0100, W.P. wrote: > 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 late

Re: System (and DB) upgrade problem., "part 2"

2021-01-18 Thread W.P.
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). No

Re: System (and DB) upgrade problem., "part 2"

2021-01-18 Thread Laurenz Albe
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 (Fed

Re: System (and DB) upgrade problem., "part 2"

2021-01-18 Thread Peter J. Holzer
On 2021-01-18 05:33:05 +0100, W.P. wrote: > 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/bi

Re: System (and DB) upgrade problem., "part 2"

2021-01-17 Thread W.P.
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

Re: System (and DB) upgrade problem.

2021-01-13 Thread Laurenz Albe
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 mi

System (and DB) upgrade problem.

2021-01-12 Thread W.P.
Hi there, 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?