Daily Log for #alfresco IRC Channel

Alfresco discussion and collaboration. Stick around a few hours after asking a question.

Official support for Enterprise subscribers: support.alfresco.com.

Joining the Channel:

Join in the conversation by getting an IRC client and connecting to #alfresco at Freenode. Our you can use the IRC web chat.

More information about the channel is in the wiki.

Getting Help

More help is available in this list of resources.

Daily Log for #alfresco

2019-12-30 06:55:01 GMT <alfresco-discord> <monica> @jpotts Thanks for your reponse. I have an instance on alfresco 5.2 with some GBs contentstore and default database. I want to migrate this instance to alfresco 6.2. So I have tried it using docker. it was working fine when started. Then I have synced alfreso_old/alf_data/content* to alfresco_new/data/alf-repo-data/ using rsync (as suggested in that particular link). Then I took dump of old instance

2019-12-30 06:55:01 GMT <alfresco-discord> and tried to restoring on new alfreco's postgres docker container. But its not restoring and after printing thousands of lines related to copy failed and alter table, its saying owner postgres does not exists. everything is failing in process of restoring. Please guide, why its not restoring or there is something else I need to do. I am just trying to move all the existing data of alfresco 5.2's instance to the

2019-12-30 06:55:02 GMT <alfresco-discord> alfresco 6.2's instance. Please guide. Thanks.

2019-12-30 11:50:16 GMT <alfresco-discord> <monica> Also, getting the below errors on restoring from inside postgres container. pg_restore: [archiver (db)] Error from TOC entry 2957; 0 0 ACL SCHEMA public postgres pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist Command was: REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM postgres; GRANT ALL ON SCHEMA public TO postgres; GRANT

2019-12-30 11:50:17 GMT <alfresco-discord> ALL ON SCHEMA public TO PUBLIC; WARNING: errors ignored on restore: 2

2019-12-30 18:27:33 GMT <alfresco-discord> <MartinM> Hi Monica :). You could try to use postgres as teh user name https://github.com/Alfresco/acs-deployment/blob/master/docker-compose/docker-compose.yml#L168 I saw that in the web https://dba.stackexchange.com/questions/221663/psql-fatal-role-postgres-does-not-exist

2019-12-30 18:27:34 GMT <alfbot> Title:acs-deployment/docker-compose.yml at master · Alfresco/acs-deployment · GitHub (at github.com)

End of Daily Log

The other logs are at http://esplins.org/hash_alfresco