Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-12328

Postgres upgrade from 9.5 to 9.6 won't use the old data dir

    Details

    • Type: Bug
    • Status: Done
    • Priority: Blocker
    • Resolution: Done
    • Affects Version/s: fuse-7.5-GA
    • Fix Version/s: None
    • Component/s: Fuse Online
    • Labels:
      None

      Description

      Between 7.4 and 7.5 we changed postgres 9.5 to 9.6 and during the upgrade a new deployment of database is rolled out. however the deployment ends with:

      Exec lifecycle hook ([/bin/sh -c /var/lib/pgsql/sampledb/postStart.sh]) for Container "postgresql" in Pod "syndesis-db-2-7t7mb_avano-syndesis(f8c5f29e-102c-11ea-8dae-fa163e2bfff4)" failed - error: command '/bin/sh -c /var/lib/pgsql/sampledb/postStart.sh' exited with 137: , message: ""
      

      I assume that this is the culprit:

      sh-4.2$ container-entrypoint run-postgresql
      Incompatible data directory.  This container image provides
      PostgreSQL '9.6', but data directory is of
      version '9.5'.
      
      This image supports automatic data directory upgrade from
      '9.5', please _carefully_ consult image documentation
      about how to use the '$POSTGRESQL_UPGRADE' startup option.
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  lgarciaac Luis GarcĂ­a Acosta
                  Reporter:
                  avano Andrej Vano
                  Tester:
                  Michael Cada
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: