Upgrading from 4.2.c to 4.2.d

[eswbitto]

I am trying to test upgrading from 4.2.c to 4.2.d and I'm running into issue with the postgresql. It seems when I insert the alf_data (from 4.2.c) to the updated version it doesn't like it.

This is the error that I am getting…

LOG:  unrecognized configuration parameter "silent_mode" in file "/opt/alfresco-4.2.d/alf_data/postgresql/postgresql.conf" line 293
FATAL:  configuration file "/opt/alfresco-4.2.d/alf_data/postgresql/postgresql.conf" contains errors
FATAL:  database files are incompatible with server
‍‍‍‍‍

My guess is that there isn't a way to migrate the data from the previous version to the new one. I can't find any instructions or work arounds on this. Has anyone run into this issue and have you solved it?

[zannafar]

Hello ESWBitto,

As I can see this is not a problem from a migration, it's about some connfiguration in full installer Alfresco's embebed PostgreSQL.

Did you tried to test if Alfresco 4.2.d works with a out-of-the-box repository (a new one)?
Could you tell me what steps have you done in this upgrade?, did you maybe replace PostgreSQL folder from your old Alfresco 4.2.c?

Regards.

[eswbitto]

I installed 4.2.d from the bin file.(tested and worked fine)

Installed the out-of-the-box repository.
Renamed Alf_Data to something else.
unzipped a backup copy of Alf_Data(with database)(from 4.2.c)
Dropped it into the new install…tried to start the service.

When I did that I looked at the postgresql.log and that is when I noticed that the new install came with an updated version of postgresql.

I'm wondering how I would be able to upgrade to the new install and not have to start all over.

[eswbitto]

I am still having problems with upgrading. So the next step that I have done is the following:

I'm on a Centos 6.4 box

Version 4.2.c installed at
/opt/alfresco-4.2.c
Then….
Installed Version 4.2.d at
/opt/alfresco-4.2.d

With neither install running I pointed the dir.root(on 4.2.d) to the alf_data on 4.2.c. That didn't work.

Then Tried to replace just the content store that didn't work either.

I'm at a loss as to what the proper upgrade process is. I've followed the instructions from here…
http://docs.alfresco.com/4.2/index.jsp

I'm apparently missing something.

[zannafar]

Hi ESWBitto,

As I can see you are doing wrong your BD restore. There are a lot of config files in alf_data/postgresql, so you are replacing or loosing configurations of Alfresco 4.2.d Postgres.

I would recommend you just create a dump of Alfresco 4.2.c database and restore in original Alfresco 4.2.d database. Here are the necessary steps:

1. Generate db dump, you need to execute "pg_dump" command, you need to go to ${OLD_ALFRESCO_INSTALL_DIR}/postgresql/bin/. Execute this in your console:
    >>> <b>pg_dump -Fc alfresco > backup.pgb<b>
   NOTE:You need to have running Alfresco 4.2.c PostgreSQL service, but Tomcat service needs to be stopped.

2. You need to restore this dump file in your Alfresco 4.2.d postgres. In this example I going to create an empty schema to restore dump file. First you have to do this entering to postgresql
    >>> <b>psql -U postgres -h localhost

       psql (8.4.12)
       SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
       Type "help" for help.

       postgres=# create DATABASE alfresco_42c;</b>
  
   NOTE: If you do not want to create new schema you can delete alfresco schema of empty repository and create it again.
   NOTE: Here you need to have running Alfresco 4.2.d PostgreSQL service, but Tomcat service needs to be stopped.

3. Restore dump file in empty schema alfresco_42c, to do this operation you need the "pg_restore" command, this command is located in ${NEW_ALFRESCO_INSTALL_DIR}/postgresql/bin/. Execute the following
    >>> <b>pg_restore -d alfresco_42c backup.pgb </b>

4. Point to the restored schema in alfresco-global-properties and the location of restored alf_data.

5. Run Tomcat service and check in your log files for applied patches.

6. Enjoy your repository in latest Alfresco Community version.

Take care,
Diego

[eswbitto]

Thank you so much for explaining it out for me. I have been tackling this all week with no success. It is now working and all of my data has been moved over to the new install. Thanks again and have a great weekend!!

[zannafar]

Congrats ESWBitto!

Enjoy new Alfresco 4.2.d features!

Regards