[Question][Answered] Database upgrade

Hi Egon,

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.

Sorry guys,

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.

Hi talex,

What about HA systems. Must we execute the script on both ha nodes?

regards

mod

Hi,

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.

Hi talex,

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 32bit
postgres server instance to 64bit.
========================================

Depending on the size of your reporting
data, this could lead to a significant
database downtime.
Also notice that you should NOT terminate
this script while running. Consider using
"screen" if you have an unstable SSH
connection.

Enter "yes" to continue:
yes

========================================
Checking pre-conditions for db migration
========================================

64 bit postgres already running! Nothing to do.
Aborting.

regards

mod

Hi talex,

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 32bit
postgres server instance to 64bit.
========================================

Depending on the size of your reporting
data, this could lead to a significant
database downtime.
Also notice that you should NOT terminate
this script while running. Consider using
"screen" if you have an unstable SSH
connection.

Enter "yes" to continue:
yes

========================================
Checking pre-conditions for db migration
========================================

64 bit postgres already running! Nothing to do.
Aborting.

regards

mod