From: | Hellmuth Vargas <hivs77(at)gmail(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | Martín Fernández <fmartin91(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: PG Upgrade with hardlinks, when to start/stop master and replicas |
Date: | 2019-02-18 20:32:31 |
Message-ID: | CAN3Qy4r=nDNXvf=sp9Vc3O81Oi1kaADuH=-Zo-+b8=yQ6qijyQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hola Martin
Pues si uno sigue la secuencia de la pagina de ayuda de PostgreSQL
https://www.postgresql.org/docs/10/pgupgrade.html
Usage
(...)
7. Stop both servers
(...)
10. Upgrade Streaming Replication and Log-Shipping standby servers
(...)
12. Start the new server
*The new server can now be safely started, and then any rsync'ed standby
servers.*
Pensaría que toca esperar a que terminen todo los rsync de las replicas
antes de iniciar la master... Pero tengo incluso una pregunta adicional: si
tengo 2 o mas replicas.. se podria sincronizar primero la master con una
replica (rsync), iniciar la master y luego emplear la replica sincronizada
para sincronizar el resto de replicas mientras que la máster ya se
encuentra en funcionamiento?.
El lun., 18 de feb. de 2019 a la(s) 15:21, Laurenz Albe (
laurenz(dot)albe(at)cybertec(dot)at) escribió:
> Martín Fernández wrote:
> > After reading the pg_upgrade documentation multiple times, it seems that
> after running pg_upgrade on the primary instance, we can't start it until
> we run rsync from the primary to the standby. I'm understanding this from
> the following section in the pg_upgrade manual page.
> >
> > You will not be running pg_upgrade on the standby servers, but rather
> rsync on the
> > primary. Do not start any servers yet.
>
> Immediately following, you can read:
>
> If you did not use link mode, do not have or do not want to use rsync, or
> want an easier
> solution, skip the instructions in this section and simply recreate the
> standby servers
> once pg_upgrade completes and the new primary is running.
>
> So this is not compulsory, it's just an efficient method to quickly get
> the standby
> server updated.
>
> There is nothing wrong with rebuilding the standby later.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
>
--
Cordialmente,
Ing. Hellmuth I. Vargas S.
Esp. Telemática y Negocios por Internet
Oracle Database 10g Administrator Certified Associate
EnterpriseDB Certified PostgreSQL 9.3 Associate
From | Date | Subject | |
---|---|---|---|
Next Message | Martín Fernández | 2019-02-18 20:41:05 | Re: PG Upgrade with hardlinks, when to start/stop master and replicas |
Previous Message | Laurenz Albe | 2019-02-18 20:20:53 | Re: PG Upgrade with hardlinks, when to start/stop master and replicas |