" I'd suggest you do a POC, setup 5.x with PG 13.x and restore content + db and do a round of regression test."
is that means when I setup alfreso 5.0 / 5.x I can tell Alfresco where the EXISTING PostgreSQL is, and the installation wizard will configure the rest?
What I want to do is separate PostgreSQL from alfresco application tier, so I can just setup another VM box for alfresco community 5.0 application tier and then point back to existing PostgreSQL (for the old alfresco communtiy 5.0), will it be ok ? In this case the Alfresoc application tier and database tier separated, and this is ALSO one of thing improvement we want to do.
Once it is ok then we can try to only upgrade alfresco community 5.0 to 5,2 and let the process upgrade the PostgreSQL in the old box for us. then we can consider upgrade to community 7.0 then upgrade to enterprise 7.0 with ACS patch/hotfix, will it be ok ?
"If you are already planning to upgrade then better to proceed with that plan instead of investing time on existing version with latest DB upgrade. "
you suspect there are problems if I do in this way ?
Its up to you whether you want to upgrade to pg13.x with acs 5.x or do a direct acs 7 upgrade. Note that acs5.x + pg13.x is not documented in the supported platforms, meaning its not tested. That's why i mentioned you to whatever you decide to do, you do a poc first if you really want to do acs5.x with pg13.x.