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?