Upgrade streaming replication and log-shipping standby servers

From: Victor Sudakov <vas(at)sibptus(dot)ru>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Upgrade streaming replication and log-shipping standby servers
Date: 2020-06-15 10:46:19
Message-ID: 20200615104619.GA97072@admin.sibptus.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear Colleagues,

When upgrading to a new major version, pg_upgrade documentation
https://www.postgresql.org/docs/current/pgupgrade.html#PGUPGRADE-STEP-REPLICAS
states that pg_upgrade can be used on a master server. After upgrading
the PostgreSQL version on standbys, however, one must either pull the
data from scratch with pg_basebackup, or run rsync from master to
standby.

Is running pg_upgrade on replicas not supported and why?

--
Victor Sudakov, VAS4-RIPE, VAS47-RIPN
2:5005/49(at)fidonet http://vas.tomsk.ru/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message vinod kale 2020-06-15 13:32:04 block corruption on slave db.
Previous Message Richard Bernstein 2020-06-15 10:07:36 Image crud for Postgresql in php?