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 /
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
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
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
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).
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
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
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
