We'd love to hear about it! Click here to go to the product suggestion community
Hello, what is the command to upgrade the database ?
welcome to the Beta. The DB is upgraded automatically in the background. No need for any manual action.
EDIT: THIS IS WRONG, PLEASE SEE MY POST BELOW.
In reply to talex:
I was wrong. Somehow I misread the internal docs. The DB is NOT automatically upgraded.
On new installations the 64bit postgres is used per default.
Existing installations need to run the migration tool. Please execute as root "/usr/local/bin/pg_migrate64.sh".
Sorry for the confusion.
What about HA systems. Must we execute the script on both ha nodes?
In reply to mod2402:
HA systems need to be migrated separately. BUT please make sure you split the nodes to prevent them from syncing in the time of DB migration.
I've executed the script on the passive node. Are you sure that we need to migrate separately? It seems that this is not needed.
========================================This script migrates a existing 32bitpostgres server instance to 64bit.========================================Depending on the size of your reportingdata, this could lead to a significantdatabase downtime.Also notice that you should NOT terminatethis script while running. Consider using"screen" if you have an unstable SSHconnection.Enter "yes" to continue:yes========================================Checking pre-conditions for db migration========================================64 bit postgres already running! Nothing to do.Aborting.