Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
database upgrade on the different binary
7 views
Skip to first unread message
Bach Nguyet Tien
Jun 29, 2021, 11:02:40 AM6/29/21
to
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
Bach-Nga
George Neuner
Jun 29, 2021, 3:54:04 PM6/29/21
to
PG installation. Generally it only is necessary to to migrate the
database(s) when upgrading to a different major version.
George
Bach Nguyet Tien
Jun 29, 2021, 7:21:24 PM6/29/21
to
Even I can't install repmgr with rh-postgresql binary but it requires postgres-server binary
Bach-Nga
Bach Nguyet Tien
Jun 29, 2021, 7:22:04 PM6/29/21
to
On Tuesday, June 29, 2021 at 3:54:04 PM UTC-4, George Neuner wrote:
George Neuner
Jun 30, 2021, 12:34:14 PM6/30/21
to
On Tue, 29 Jun 2021 16:21:23 -0700 (PDT), Bach Nguyet Tien
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
<mayt...@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
>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
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
0 new messages