Hello everyone,
I recently performed a backup and restore operation for an Alfresco Community instance and ran into an issue I can’t resolve. Here is what I did step-by-step:
✅ Backup Process:
On the source server (Alfresco + PostgreSQL), I created a SQL dump using:
pg_dump -U alfresco -d alfresco > alfresco_backup.sql
✅ Transfer to VM:
I copied the backup file to a clean Linux VM using:
scp alfresco_backup.sql user@vm-ip:/home/user/
✅ Restore Process:
Inside the VM, I created a new PostgreSQL database, then restored the dump using:
psql -U alfresco -d alfresco < /home/user/alfresco_backup.sql
Note: I used the same database name and user credentials as the original instance.
✅ Verification:
After the restore, I verified that the database contains the expected tables and data using:
docker exec -it <your-postgres-container> psql -U alfresco -d alfresco
Inside the PostgreSQL shell:
SELECT COUNT(*) FROM alf_node;
SELECT COUNT(*) FROM alf_authority;
SELECT COUNT(*) FROM alf_store;These queries returned valid counts, indicating that the node metadata and authorities were restored.
❌ Problem:
Even though the database seems to contain all the data (e.g., alf_node has thousands of rows), Alfresco Share shows no folders, or users or aspects after starting the containers.
