Ekaterina Amez <ekaterina.amez@zunibal.com> writes:
> When you say "Red Hat's postgres packages use a much different file
> layout than the PGDG packages, so they don't interoperate terribly
> well.", I guess you're talking about the installation, not the structure
> of the database. If I'm right, there shouldn't be problems with
> pg_upgrade (I'm worried about data corruption as I'm not sure how to
> detect it).
Right, I'm just talking about where they put the installed executables
and libraries. The database data per se should be compatible.
> Would it be possible to install another server with same CentOS but with
> PGDG packages of postgres 9.2 and create the replica to this server and
> replaces this one with main server when both are completely synchronized?
Should work, I think, and that's probably a good idea. PGDG's file layout
supports having both 9.2 and 9.6 installed on the same machine much better
than Red Hat's does.
regards, tom lane