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)