by   February 01 2015   
Upgrade Alfresco Community 4.0f to 5.0c with PortgreSQL The simple short version. One, Backup your PortgreSQL data. Two, Backup your alf_data contentstore and solr4 folders. others as needed but not your postgresql. Three, install a new fresh version of Alfresco 5.0c. Four, copy your backup files. Five, restore your database from your backup.

Upgrade Alfresco Community 4.0f to 5.0c PortgreSQL

How I upgraded my Alfresco Community 4.0f to 5.0c just before the game started. 

I have all the screenshots for your SQL Manager for PortgreSQL which was the first time I have ever used this program. 

The instructions on how to backup your PortgreSQL from the Community just doesn't seem to work on Windows as well as you would want. Actaully, I have not been able to successfully. 

I hope you know what to backup based on what you installed. 
I'll be focusing you on the SQL backup and recovery because that's something many do not do often enough. 

This is the process I take with my live version. You can skip the parts of replacing your hard drive if you're working from a single drive. Just rename the folder you have used for your Alfresco .. I suggest renaming it from Alfresco to Alfresco_old_4.x

1. Backup your Alfresco portgreSQL.

2. Backup your alf_data / contentstore and solr4 folders

3. Backup any and all other folders in the alf_data folder that you need.

4. Optional: Remove the hard drive you used for your Alfresco folder. (If you are practicing a drive failure.)

5. Optional: Replace the drive with a new un-formatted hard drive of equal of greater size.

6. Optional: Format the drive.

7. Install Alfresco Community DMS to that hard drive.

8. Check to make sure it is all working with just the base installation.

9. Stop the Tomcat services but keep the portgreSQL service running.

10. Copy over your files that you backed up. (contentstore, solr4)

11. Drop the current SQL db and recover from your backup. Follow guide below.

12. Start your services or reboot if it's stuck.

13. Check your working Alfresco CMS recovery data.

 Large Rectangle (336 x 280)

You're done, simple, and depending on the size of your physical contentstore size the rest should take just about 20 minutes. 

This is the Windows platform.

The server I'm using is a Windows 2008 Web 32bit with 3Gb useable RAM.
It's an old Pentium 4 D Xeon 2.3Ghz with a few SCSI cards and SATA controllers and drives.

Anyway, follow the step by step picture guide or the video linked in my Google+.

By the end of this project you should be able to recover from a drive failure or any other type of failure you could think of. 

 

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

SQL Manager For Postgresql 1

 

 

 

Upgrade Alfresco Community 4.0f to 5.0c with PortgreSQL The simple short version. One, Backup your PortgreSQL data. Two, Backup your alf_data contentstore and solr4 folders. others as needed but not your postgresql. Three, install a new fresh version of Alfresco 5.0c. Four, copy your backup files. Five, restore your database from your backup.