./psql -U postgres DROP DATABASE alfresco; CREATE DATABASE alfresco WITH OWNER alfresco; ctrl-d (exit) ./psql -U alfresco -d alfresco ALTER USER alfresco WITH PASSWORD 'mypassword'; ctrl-d (exit) ./pg_restore -d alfresco /home/temp/alfresco_db.tar exit // from postgres ID cd /opt/alfresco-community ./alfresco.sh stop postgresql // stop postgresq
As I could see database restored without errors.
Also, I deleted contentstore, contentstore.deleted and solr4 folders from my new server and replaced it with folders from previous server I already backed up. But after I did reset of alfresco service and postgres service I have unchanged content in my share repository, I have nothing from my first server, content restore was not successfull.
I want to give one more notice and it is that I changed name of my shared files folder at first server, I don`t know if it can cause problems with backup/restore.
Yes I am trying to restore on a new server. I did not make any changes on alfresco-global.properties at new server. There is configuration for data path and jdbc and it is same as server from which I did restore.