<font size=2 face="sans-serif">Hi All,</font>
<br>
<br><font size=2 face="sans-serif">I am working on a PostgreSQL cluster
managed using Pacemaker and Corosync.</font>
<br><font size=2 face="sans-serif">The cluster is composed by three nodes:
Master, Sync and Async.</font>
<br><font size=2 face="sans-serif">Currently my cluster uses PostgreSQL
9.4.9 and I am going to upgrade my environments to 9.6.3.</font>
<br>
<br><font size=2 face="sans-serif">My upgrade procedure uses the following
steps:</font>
<br>
<br><font size=2 face="sans-serif">1. install 9.6.3 binaries on all the
three nodes</font>
<br><font size=2 face="sans-serif">2. crm node standby of all the three
nodes</font>
<br><font size=2 face="sans-serif">3. create new data directory on all
the three nodes</font>
<br><font size=2 face="sans-serif">4. only on master node do initdb on
data directory</font>
<br><font size=2 face="sans-serif">5. pg_upgrade from old to the new directory</font>
<br><font size=2 face="sans-serif">6. update postgresql.conf file</font>
<br><font size=2 face="sans-serif">7. start postgres with pg_ctl command</font>
<br><font size=2 face="sans-serif">8. stop postgres with pg_ctl command</font>
<br><font size=2 face="sans-serif">9. crm node online <master node></font>
<br>
<br><font size=2 face="sans-serif">on the others two nodes:</font>
<br><font size=2 face="sans-serif">10. pg_base_backup to align slave node
with master</font>
<br><font size=2 face="sans-serif">11. crm node online <slave node></font>
<br>
<br><font size=2 face="sans-serif">Now I have two questions:</font>
<br><font size=2 face="sans-serif">1. In order to have the master working
properly I needed step 7 and 8 in order to let master recognize the status
of the cluster before the upgrade and let it recognize the others node
and go in hot standby mode. <b>Is this start/sto really required or there
is another way to have master start from the status before the upgrade?</b></font>
<br>
<br><font size=2 face="sans-serif">2. On test environment this procedure
works fine. In production, two times happened that when I start nodes in
step 9 the slaves start as well. Is this possible? In which case this could
happen?</font>
<br>
<br><font size=2 face="sans-serif">Salvatore D'Angelo<br>
Advisory Software Engineer - IBM Cloud<br>
IBM Rome Software Lab<br>
Via Sciangai 53, 00144 Roma<br>
Phone +39-347-432-8059<br>
<br>
</font>
<p><font size=1 face="sans-serif">IBM Italia S.p.A. Sede Legale: Circonvallazione
Idroscalo - 20090 Segrate (MI) Cap. Soc. euro 347.256.998,80 C. F. e Reg.
Imprese MI 01442240030 - Partita IVA 10914660153 Societa' con unico azionista
Societa' soggetta all'attivita' di direzione e coordinamento di International
Business Machines Corporation (Salvo che sia diversamente indicato sopra
/ Unless stated otherwise above)</font>
<p>