Ekaterina Amez <ekaterina.amez@xxxxxxxxxxx> 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
