[Question][Answered] Database upgrade

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.

  • In reply to talex:

    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.

  • In reply to talex:

    Hi talex,

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

    regards

    mod

  • In reply to mod2402:

    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.

  • In reply to talex:

    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