Info: Upgrading PostgreSQL to 64-bit on UTM 9.5

Maybe a bit of instruction on how to dissolve a cluster?

Just set 'Operation mode: Off', Louis.

Cheers - Bob

Hi Bob,

yes but what happens after it is set to off? Obviously one of the UTM's will remain active with the current ip address etc and can be updated.

But what happens to the other UTM? It can't have the same ip otherwise there will be a conflict. Turning the active UTM off will cause an outage.

So I'm wondering how to go about it?

Setting HA "Off" causes the other unit to do a Factory Reset and shut down, Louis.  You have to disconnect it, do a rudimentary setup, upgrade databases to 64-bit, Factory Reset and shut down.  After that, reconnect and power it up - the Master will configure it and sync to it.

Cheers - Bob

Wow...... not exactly the easiest way to upgrade

Wow...... not exactly the easiest way to upgrade

It's the first time I've see this since we stated doing V3 14 years ago.  High Availability has been with us for almost 10 years and has never before required a separate maneuver like this.

Cheers - Bob

ummmm.... so in a live environment where each UTM goes to a Cisco stacked switch with an etherchannel  and each physical port on a different switch:

1. Determine which UTM is in standby
2. Disconnect all cables at standby UTM (bar HA cable)
3. Turn HA off. This will factory reset standby UTM. Active UTM will function as normal.
4. Disconnect HA cable
5. Connect pc/laptop to lan port of disconnected UTM and connect to admin interface
6. Perform db upgrade.
7. Factory reset

8. Go to active UTM
9. Perform db upgrade

10. Connect HA cable and bring HA back up on active UTM
11. Connect disconnect cables to standby UTM
12. Check sync and perform failover

Suggested improvements, Louis:

  7. Factory Reset and power the unit down

10. Bring HA back up on active UTM
11. Connect disconnect cables to standby UTM and then power it up.

Cheers - Bob

Hi Bob,

Thanks to you and Louis for these step by step instructions.    

Did my 9.502 HA upgrade yesterday without any problems.

A few questions...

- How does one know/verify if the UTM postgreSQL was running the 64-bit version?

- Does a new v9.502 distro installation install the 64-bit libraries by default or would you have to do the 64-bit upgrade after the install?

Bob G.

BobG said:

A few questions...

- How does one know/verify if the UTM postgreSQL was running the 64-bit version?

- Does a new v9.502 distro installation install the 64-bit libraries by default or would you have to do the 64-bit upgrade after the install?

Fresh installation are now using the 64-bit version.

For the check I don't know at the moment, but you feel it if you use your reports and wonder why they run a lot faster. At least this was my experience.

Best

Alex

Thank you for quick response.