• database upgrade on the different binary

    From Bach Nguyet Tien@21:1/5 to All on Tue Jun 29 08:02:39 2021
    Is it ok to upgrade/migrate postgresql db from 12.3 postgres binary to 12.7 redhat binary (rh-postgresql) and/or versa (12.5 redhat binary version to 12.7 postgres binary)

    Bach-Nga

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From George Neuner@21:1/5 to maytim00@gmail.com on Tue Jun 29 15:54:02 2021
    On Tue, 29 Jun 2021 08:02:39 -0700 (PDT), Bach Nguyet Tien
    <maytim00@gmail.com> wrote:

    Is it ok to upgrade/migrate postgresql db from 12.3 postgres binary to
    12.7 redhat binary (rh-postgresql) and/or versa (12.5 redhat binary
    version to 12.7 postgres binary)

    Bach-Nga

    Since it is the same major version, it should be ok to just update the
    PG installation. Generally it only is necessary to to migrate the
    database(s) when upgrading to a different major version.

    George

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Bach Nguyet Tien@21:1/5 to George Neuner on Tue Jun 29 16:22:03 2021
    On Tuesday, June 29, 2021 at 3:54:04 PM UTC-4, George Neuner wrote:
    On Tue, 29 Jun 2021 08:02:39 -0700 (PDT), Bach Nguyet Tien <mayt...@gmail.com> wrote:

    Is it ok to upgrade/migrate postgresql db from 12.3 postgres binary to
    12.7 redhat binary (rh-postgresql) and/or versa (12.5 redhat binary
    version to 12.7 postgres binary)

    Bach-Nga
    Since it is the same major version, it should be ok to just update the
    PG installation. Generally it only is necessary to to migrate the
    database(s) when upgrading to a different major version.

    George

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Bach Nguyet Tien@21:1/5 to George Neuner on Tue Jun 29 16:21:23 2021
    On Tuesday, June 29, 2021 at 3:54:04 PM UTC-4, George Neuner wrote:
    On Tue, 29 Jun 2021 08:02:39 -0700 (PDT), Bach Nguyet Tien <mayt...@gmail.com> wrote:

    Is it ok to upgrade/migrate postgresql db from 12.3 postgres binary to
    12.7 redhat binary (rh-postgresql) and/or versa (12.5 redhat binary
    version to 12.7 postgres binary)

    Bach-Nga
    Since it is the same major version, it should be ok to just update the
    PG installation. Generally it only is necessary to to migrate the
    database(s) when upgrading to a different major version.

    George

    The reason I asked because the Redhat binary directory structure is so different
    Even I can't install repmgr with rh-postgresql binary but it requires postgres-server binary

    Bach-Nga

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From George Neuner@21:1/5 to maytim00@gmail.com on Wed Jun 30 12:34:10 2021
    On Tue, 29 Jun 2021 16:21:23 -0700 (PDT), Bach Nguyet Tien
    <maytim00@gmail.com> wrote:

    On Tuesday, June 29, 2021 at 3:54:04 PM UTC-4, George Neuner wrote:
    On Tue, 29 Jun 2021 08:02:39 -0700 (PDT), Bach Nguyet Tien
    <mayt...@gmail.com> wrote:

    Is it ok to upgrade/migrate postgresql db from 12.3 postgres binary to
    12.7 redhat binary (rh-postgresql) and/or versa (12.5 redhat binary
    version to 12.7 postgres binary)

    Bach-Nga
    Since it is the same major version, it should be ok to just update the
    PG installation. Generally it only is necessary to to migrate the
    database(s) when upgrading to a different major version.

    George

    The reason I asked because the Redhat binary directory structure is so different
    Even I can't install repmgr with rh-postgresql binary but it requires postgres-server binary

    Bach-Nga

    Ok, I misunderstood the question - I've used PG on CentOS, but I've
    always used the PG repositories.

    Rather than changing installations and possibly breaking things, I
    would prefer to get updates from wherever the original package came
    from. YMMV.


    If you really do want to change installations, and your databases are
    in the default location, even though it /should/ just work to point
    the new PG to the old tablespace, it may be wiser to deliberately
    migrate or dump/restore the database(s).

    George

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)