nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Delete AlfrescoDB from new alfresco installation

ejike

Good day All,

I am performing an alfresco community upgrade from Alfresco community 5.0 to 5.1. I have done the backup and copied the alf_data from the old installation i.e. 5.0, I have installed the Alfresco community 5.1.

My question is how do I go about removing the alfrescoDB in 5.1 and restoring the backup DB from 5.0 to 5.1, if anyone can list the process of doing this or how i go about it, I would be glad.

I look forward to hearing from you guys.

Thanks and BR,

Find more posts tagged with

Alfresco Content Services

Comments

fedorow

You should do dump/restore of database 5.0 into 5.1 installation.

1. delete default installed database in 5.1 and create empty database 'alfresco'

$ ./psql
postgres=# drop database alfresco;

postgres=# CREATE DATABASE alfresco
postgres-# WITH OWNER = alfresco
postgres-# ENCODING = 'UTF8'
postgres-# TABLESPACE = pg_default
postgres-# CONNECTION LIMIT = -1
postgres-# TEMPLATE template0;
 
postgres-# \q

3. stop alfresco 5.0. dump old 5.0

$ pg_dump --username alfresco alfresco > database_dump.sql

4. restore database 5.0 into 5.1

$ cat database_dump.sql | psql -q -U alfresco -d alfresco

5. rsync alf_data from 5.0 into 5.1

$ rsync -avh ./alfresco5.0/alf_data ./alfresco5.1/

5. start alfresco 5.1 to upgrade

ejike

Hi @fedorow

Please where do I run these commands, is it "cmd" terminal or should it be run in "pgAdmin3" or "psql" inside the /postgresql > bin folder.

I look forwrad to hearing from you.

Regards,

Ejike

ejike

Hi @fedorow I have implemented all the steps from step 1 to step 5.

For step 5, I deleted the alf_data in Alfresco 5.1 and implemented "rsync" which was completed successfully.

But anytime I start Alfresco 5.1, it goes from "stopped" to "starting" and goes back to "stopped". It never moves to "running".

Please what do you think could be the issue?

I look forwrad to hearing from you.