topic Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe in Alfresco Forum

upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

dba100 — Fri, 24 Sep 2021 07:07:03 GMT

hi,

we are trying to upgrade from community 5.0 to 5.2 and from :

1. https://docs.alfresco.com/content-services/5.2/upgrade/#upgrading-on-a-single-instance

2. https://docs.alfresco.com/content-services/5.2/install/#using-the-installers-on-windows

I know we need to download the installer : alfresco-content-services-installer-5.2.7-win-x64.exe as the start point and upgrade files, but I can't see where I can downlaod it, please suggest.

anything else we need to download together with alfresco-content-services-installer-5.2.7-win-x64.exe ?

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

cristinamr — Fri, 24 Sep 2021 07:11:14 GMT

Good morning.

That version belong to Enterprise version. If you are using community version, please check this post.

Cheers.

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

dba100 — Fri, 24 Sep 2021 09:21:44 GMT

tks. let's see if we can find one to upgrade instead of New installation.

but one thing, I read the upgrade guide, it seem the upgrade = NEW installation + restore of producion data from old server over to the new server?

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

cristinamr — Fri, 24 Sep 2021 13:39:23 GMT

@dba100 wrote:

but one thing, I read the upgrade guide, it seem the upgrade = NEW installation + restore of producion data from old server over to the new server?

Yes, it is the recommeded way to process 🙂

Cheers!

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

dba100 — Mon, 27 Sep 2021 04:20:51 GMT

hi.

tks.

So even PostgreSQL folder can be copy like that ...... ? I doubt that. and we should use pgdump for that ..?

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

cristinamr — Mon, 27 Sep 2021 06:43:14 GMT

Good morning.

Why don't you try with a fresh installation (create 1 doc on it)? You can follow the upgrade instructions and if you have a problem you can let us know.

Cheers,

Cris.

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

dba100 — Wed, 29 Sep 2021 08:42:00 GMT

hi,

we will try it soon but what amaze me is how can we during setup, ALREADY tell alfresco that the PostgreSQL DB is in other box instead of local one!

is the installation wizard allow us to point to EXISTING postgreSQL ?

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

cristinamr — Wed, 29 Sep 2021 10:35:46 GMT

Hi!

As far as I remeber: yes you have one step where you can specify where is located your pogresql configuration path. But anyway, if you has missed this step, you can edit your alfresco-global.properties (under tomcat/shared/classes) and modify its details there.

Cheers,

Cristina.

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

dba100 — Thu, 30 Sep 2021 03:50:52 GMT

hi,

Tks. right now our postgreSQL has 406GB of data and what it store actually? I see some tables very large, e.g 280GB.

If I login to that PostgreSQL and rebuilt all index and update all statistics, what is this action going to improve?

"r: yes you have one step where you can specify where is located your pogresql configuration path"

Tks. as the upgrade guide said in place upgrade is not good and we are told to install the new alfresco on ANOTHER box , if we can left the postgresQL in the orignal box, then alfresco and PostgreSQL separated.

Someone even tell me to kill/cancel the POST installation wizard, I am not sure how can I get do it? it is not going to kill the whole Alfresco upgrade?

"you can edit your alfresco-global.properties (under tomcat/shared/classes) and modify its details there.

Cheers,"

yeah, tks. you told me before.

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

heiko_robert — Fri, 01 Oct 2021 20:51:43 GMT

5.2.7 is an enterprise version. Don't you have support from a Alfresco partner for your upgrade process?

You can (re)use the existing db - even on a new install. Just run the installer like for a fresh system and then modify the db and contentstore url in the alfresco-global.properties. What could be a real pain is how to upgrade the postgres binaries and update the database within your local windows directory created by the Alfresco installer(s). You should check if pg_upgrade is included in your bin directory. Some weeks ago I did a inplace postres upgrade on linux system for a > 400 GB alfresco db and that took ~ 20 mins but on that system we already stored the db in a postres installed from the OS package manager, not from the Alfresco installer. Also I'm not sure if inplace postgres upgrade is supported on Windows at all since the mechanism creates symlinks in the new install dir.

What do you think to take this as a chance to move your db on a independant system using an official Postgres installer/deployment? I would even encourage you to move from Windows to Linux in this step, which makes updates/upgrade/tuning/clustering easier. For this migration you would need to pg_dump and pg_restore once but you you may play with parallel dump and parallel restoration to reduce the downtime.

Rebuilding postgres' indexes and updating statistics would not reduce any table/db sizes. For that size I would guess something like 100 mio nodes/documents. If you think it should be less you could check the trash bin (archive store) and the trash cleaner.

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

dba100 — Tue, 05 Oct 2021 04:40:25 GMT

hi,

tks.

"5.2.7 is an enterprise version."

so what is the latest 5.2.x community edition? the information I got here from other member is , 5.2.7 is community edition.

"You can (re)use the existing db - even on a new install. Just run the installer like for a fresh system and then modify the db and contentstore url in the alfresco-global.properties."

understood.

"What could be a real pain is how to upgrade the postgres binaries and update the database within your local windows directory created by the Alfresco installer(s). You should check if pg_upgrade is included in your bin directory. "

so if the alfresoc binary has the pg_upgrade.exe we are fine ? but we will check postgreSQL version by logging in to the PostgreSQL and see if it is different.

"ome weeks ago I did a inplace postres upgrade on linux system for a > 400 GB alfresco db and that took ~ 20 mins but on that system we already stored the db in a postres installed from the OS package manager, not from the Alfresco installer. "

so not by Alfresco installation binary buy by linux package manager and Alfresco still works ?

"What do you think to take this as a chance to move your db on a independant system using an official Postgres installer/deployment?"

as you said, just change the DB configuration path and point back to the existing one.

"I would even encourage you to move from Windows to Linux in this step, which makes updates/upgrade/tuning/clustering easier. "

for me window installer is easier than linux, right ? just next next and next.. ?

"For this migration you would need to pg_dump and pg_restore once but you you may play with parallel dump and parallel restoration to reduce the downtime"

any command for me to reference to do parallel pg_dump and pg_restore ? is the pg_dump and store do good to backup and restore username and security role as well as Alfresco related application role ?

"If you think it should be less you could check the trash bin (archive store) and the trash cleaner."

is it good for us to keep deleted trash bin regularily? how can I do it regularily ?

"Rebuilding postgres' indexes and updating statistics would not reduce any table/db sizes"

we are not doing rebulid index and statistic for that! actually what can be faster if we rebuild ALL postgreSQL index and updates statistics for Alfresco database?

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

dba100 — Tue, 05 Oct 2021 06:50:25 GMT

Do you think we can upgrade PostgreSQL 9.3.x bundled with Alfresco 5.0 to PostgreSQL 11 directly?

any news on when we can upgrade PostgreSQL 13/14 for Alfresco community 7?

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

heiko_robert — Tue, 05 Oct 2021 10:43:44 GMT

https://docs.alfresco.com/content-services/latest/support/

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

heiko_robert — Tue, 05 Oct 2021 10:58:33 GMT

> so what is the latest 5.2.x community edition? the information I got here from other member is , 5.2.7 is community edition.

https://hub.alfresco.com/t5/alfresco-content-services-hub/alfresco-community-edition-201707-ga-release-notes/ba-p/291286

> so not by Alfresco installation binary buy by linux package manager and Alfresco still works ?

sure : postgres is postgres and I would not recommend to use the alfresco installer provided version https://docs.alfresco.com/content-services/latest/support/

> for me window installer is easier than linux, right ? just next next and next.. ?

easier for you doen't mean better for your organisation. We never use(d) the installer version on any production systems.

> any command for me to reference to do parallel pg_dump and pg_restore ?

off topic

> is it good for us to keep deleted trash bin regularily?

of course - depending on your usage scenario trash bin could increase dramatically if not managed

> how can I do it regularily ?

alfresco-trashcan-cleaner

> we are not doing rebulid index and statistic for that! actually what can be faster if we rebuild ALL postgreSQL index and updates statistics for Alfresco database?

updating statistics may help the db optimizer to choose the fastest query plan

I would not expect any performance optimization from rebuilding ALL postgreSQL indexes

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

dba100 — Wed, 06 Oct 2021 06:57:09 GMT

"https://docs.alfresco.com/content-services/latest/support/"

ok,, Here we have alfresco 7.1 and it support PostgreSQL 13.1 and 13.1

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

dba100 — Wed, 06 Oct 2021 10:17:53 GMT

"https://hub.alfresco.com/t5/alfresco-content-services-hub/alfresco-community-edition-201707-ga-relea..."

I see this :

Maven repository

Alfresco Community 201707 artifacts are available in our Maven repository under the versions.

5.2.g for Alfresco Platform
5.2.f for Alfresco Share.

So 5.2.g is the one we needed for community 5.2 for upgrade from 5.0?

"postgres is postgres and I would not recommend to use the alfresco installer provided version https://docs.alfresco.com/content-services/latest/support/"

ok ,got you!

"alfresco-trashcan-cleaner"

so it is the alfresco-trashcan-cleaner.exe command on windows too ?

I can't find alfresco-trashcan-cleaner.exe in my host installed with community 5.0

"updating statistics may help the db optimizer to choose the fastest query plan
I would not expect any performance optimization from rebuilding ALL postgreSQL indexes"

from alfresco application's point of view, nothing perform better after index rebuild and update statistics.

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

heiko_robert — Wed, 06 Oct 2021 10:44:29 GMT

We build our own versions but I guess 5.2.g is the correct version. Why don't you use the war from the installer/zip-archive referenced on the release page?

trashcan-cleaner: there is no exe. Alfresco didn't have such a feature like a trashcan-cleaner but started to prepackage the Alfresco product with the trashcan-cleaner module originally developed by the ATOL CD team. There are still others providing their own module with that functionality. If it's not already installed on your system (I don't remember the Alfresco version when this is preinstalled) you may build and install it - but be careful to use the very latest version since the module had a heavy issue with large repos/many docs in the trash.

> from alfresco application's point of view, nothing perform better after index rebuild and update statistics.

I don't understand what you're trying to tell. Does a reindex change the performance? If so, you may take a look on your postgres configuration to optimize memory allocation.

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

dba100 — Wed, 20 Oct 2021 09:11:35 GMT

hi,

tks.

" from alfresco application's point of view, nothing perform better after index rebuild and update statistics."

sorry typo..

I want to know if I rebuild all index of PostgreSQL, will the speed of Alfresco application will be increase?

or what function of Alfresco will have speed improvement ?

"If so, you may take a look on your postgres configuration to optimize memory allocation."

but I am only focus on index rebuild at this moment

Re: upgrade 5.2, where is the alfresco-content-services-installer-5.2.7-win-x64.exe

dba100 — Tue, 30 Nov 2021 09:39:08 GMT

any update for me ?