topic Re: Restore Alfresco Database (PostgreSQL) in Alfresco Forum

Restore Alfresco Database (PostgreSQL)

ddtien66 — Thu, 23 May 2019 02:31:29 GMT

Hi all, Due to a server crash, I have to restore the whole Alfresco Community (ver 5.2). I am trying to follow the guide in https://community.alfresco.com/thread/202783-backup-and-restore-procedures , but get stuck at recovery of Postgres database, since I cannot login with 'postgres' account (mine

Re: Restore Alfresco Database (PostgreSQL)

AlfrescoZZZ — Thu, 23 May 2019 08:32:52 GMT

Try this with root privileges:

Enter with postgres user

su - postgres

Go to the directory

cd /opt/alfresco-community/postgresql/bin/

Run bin

./psql

Insert the password (usually on the alfresco-global-properties)

> YOUR_SQL_COMMAND

>\q

Exit from postgres user

exit

If you want just do a dump then

su - postgres

cd /opt/alfresco-community/postgresql/bin/

./pg_dump -h 127.0.0.1 -U alfresco -W alfresco > /opt/alfresco/alfresco52dump.sql

for restore

./psql -h 127.0.0.1 -U alfresco -W alfresco < /opt/alfresco/alfresco52dump.sql

Re: Restore Alfresco Database (PostgreSQL)

ddtien66 — Fri, 24 May 2019 08:29:04 GMT

Thanks a lot. It works fantastically!

Re: Restore Alfresco Database (PostgreSQL)

AlfrescoZZZ — Fri, 24 May 2019 12:07:40 GMT

Mark as Corrected Answer then