Hello, what is the command to upgrade the database ?
Hello, what is the command to upgrade the database ?
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.
/talex
- 21 is only half of the truth
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.
/talex
- 21 is only half of the truth
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.
/talex
- 21 is only half of the truth
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.
/talex
- 21 is only half of the truth
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
