Link to "Upgrading a PostgreSQL Cluster" in Release Notes

On 2019-12-30 00:03, Vik Fearing wrote:

Following a complaint on IRC about the dearth of information on how to
migrate to a new major version in the release notes, the attached
trivial patch was determined to be sufficient for the OP.

This patch applies to REL_12_STABLE.  I don't know how far it should be
backpatched (the OP was trying to upgrade to v10), and I didn't see any
place to put it for 13 and future versions.

I think this change is sensible. But to what extent do we want to edit
around in old release notes? Should we just keep it for PG13?

I think we should also extend the blurb in the release notes to mention
the option of using logical replication to upgrade. Otherwise, if you
follow the link you propose, then one might think that logical
replication upgrading is not applicable since only pg_dump and
pg_upgrade were mentioned in the place the link came from.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

On Fri, Jan 3, 2020 at 9:57 AM Peter Eisentraut <
peter.eisentraut@2ndquadrant.com> wrote:

On 2019-12-30 00:03, Vik Fearing wrote:

Following a complaint on IRC about the dearth of information on how to
migrate to a new major version in the release notes, the attached
trivial patch was determined to be sufficient for the OP.

This patch applies to REL_12_STABLE. I don't know how far it should be
backpatched (the OP was trying to upgrade to v10), and I didn't see any
place to put it for 13 and future versions.

I think this change is sensible. But to what extent do we want to edit
around in old release notes? Should we just keep it for PG13?

I think it makes sense to backpatch it. Lots of people still upgrade to at
least 12 and 11, and that's a likely place for them to start reading. And
if we're already covering 12 and 11, it is probably no big extra effort to
do other supported branches as well.

I think we should also extend the blurb in the release notes to mention

the option of using logical replication to upgrade. Otherwise, if you
follow the link you propose, then one might think that logical
replication upgrading is not applicable since only pg_dump and
pg_upgrade were mentioned in the place the link came from.

+1.

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/&gt;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/&gt;

On 2020-01-03 11:00, Magnus Hagander wrote:

On 2019-12-30 00:03, Vik Fearing wrote:

Following a complaint on IRC about the dearth of information on

how to

migrate to a new major version in the release notes, the attached
trivial patch was determined to be sufficient for the OP.

This patch applies to REL_12_STABLE.  I don't know how far it

should be

backpatched (the OP was trying to upgrade to v10), and I didn't

see any

place to put it for 13 and future versions.

I think this change is sensible.  But to what extent do we want to edit
around in old release notes?  Should we just keep it for PG13?

I think it makes sense to backpatch it. Lots of people still upgrade to
at least 12 and 11, and that's a likely place for them to start reading.
And if we're already covering 12 and 11, it is probably no big extra
effort to do other supported branches as well.

Committed to 12, 11, 10. After that the patch didn't apply anymore and
nobody should be upgrading to that anyway.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

On 09/01/2020 16:19, Peter Eisentraut wrote:

On 2020-01-03 11:00, Magnus Hagander wrote:

    On 2019-12-30 00:03, Vik Fearing wrote:
     > Following a complaint on IRC about the dearth of information on
    how to
     > migrate to a new major version in the release notes, the attached
     > trivial patch was determined to be sufficient for the OP.
     >
     > This patch applies to REL_12_STABLE.  I don't know how far it
    should be
     > backpatched (the OP was trying to upgrade to v10), and I didn't
    see any
     > place to put it for 13 and future versions.

    I think this change is sensible.  But to what extent do we want
to edit
    around in old release notes?  Should we just keep it for PG13?

I think it makes sense to backpatch it. Lots of people still upgrade
to at least 12 and 11, and that's a likely place for them to start
reading. And if we're already covering 12 and 11, it is probably no
big extra effort to do other supported branches as well.

Committed to 12, 11, 10.  After that the patch didn't apply anymore
and nobody should be upgrading to that anyway.

Thanks!  And thanks for adding the logical replication text, too.

--

Vik Fearing