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

2018-10-31 11:08:00 GMT *** angelborroy_ is now known as angelborroy

2018-10-31 15:30:11 GMT <alfresco-discord> <Thijs> @angel.borroy I have been working on an Oracle -> PG migration for Alfresco, and I was inspired by https://github.com/mikelasla/database-transformations

2018-10-31 15:30:12 GMT <alfbot> Title:GitHub - mikelasla/database-transformations (at github.com)

2018-10-31 15:30:26 GMT <alfresco-discord> <Thijs> Am I correct that you were involved in that?

2018-10-31 15:31:26 GMT <alfresco-discord> <Thijs> Do you have any indication what performance can be expected from Ora2PG?

2018-10-31 15:38:03 GMT <angelborroy> Not really, but I can recap some information

2018-10-31 15:38:07 GMT <angelborroy> let me find it

2018-10-31 15:39:26 GMT <alfresco-discord> <yreg> @Thijs are you trying to migrate that 1.5 TB database to postgres ?

2018-10-31 15:39:50 GMT <alfresco-discord> <Thijs> @yreg I would like to, but no

2018-10-31 15:39:57 GMT <angelborroy> I have records of 2 hours

2018-10-31 15:40:06 GMT <angelborroy> I’m trying to find Oracle DB size

2018-10-31 15:40:12 GMT <alfresco-discord> <Thijs> thanks

2018-10-31 15:41:22 GMT <alfresco-discord> <Thijs> @yreg I don't think they can handle the "downtime" or "read-only" time for that migration.

2018-10-31 15:41:37 GMT <angelborroy> we migrated from a DUMP

2018-10-31 15:41:43 GMT <angelborroy> not online

2018-10-31 15:41:48 GMT <alfresco-discord> <yreg> well... over a long weekend, they could <grin>

2018-10-31 15:41:54 GMT <angelborroy> we made this process three times in the past

2018-10-31 15:43:10 GMT <alfresco-discord> <Thijs> thanks, I get a running Oracle, but doesn't make a huge difference (the process), since you need to import the dump to a running Oracle before running ora2pg

2018-10-31 15:43:43 GMT <angelborroy> yep

2018-10-31 15:43:53 GMT <alfresco-discord> <yreg> If you really have the motivation you can make it work 😉

2018-10-31 15:43:55 GMT <angelborroy> ok 2 hours for 15 GB

2018-10-31 15:44:03 GMT <angelborroy> so for 1,5 TB…

2018-10-31 15:44:09 GMT <alfresco-discord> <Thijs> thanks

2018-10-31 15:44:20 GMT <alfresco-discord> <Thijs> the one I need to move now is 35G

2018-10-31 15:44:31 GMT <angelborroy> so about 6 hours

2018-10-31 15:44:42 GMT <alfresco-discord> <Thijs> but this is not a dump file, so I guess a dump would be smaller

2018-10-31 15:44:46 GMT <alfresco-discord> <Thijs> but I don't know

2018-10-31 15:44:57 GMT <angelborroy> we made the process twice before going with prod

2018-10-31 15:45:12 GMT <angelborroy> just to take times and to planify stopping windows

2018-10-31 15:45:26 GMT <alfresco-discord> <Thijs> @angel.borroy thanks for the info

2018-10-31 15:45:29 GMT <alfresco-discord> <Thijs> it is appreciated

2018-10-31 15:45:41 GMT <angelborroy> we used some Docker template, but I don’t know if it’s still working

2018-10-31 15:46:20 GMT <alfresco-discord> <Thijs> I used it as an example

2018-10-31 15:46:40 GMT <alfresco-discord> <Thijs> but I made my own docker image, with updated versions

2018-10-31 15:47:05 GMT <alfresco-discord> <Thijs> willing to share it, but it contains these proprietary Oracle libraries, so I don't think I'm allowed to

2018-10-31 15:47:39 GMT <alfresco-discord> <Thijs> it seems to be working well on a small db

2018-10-31 15:47:50 GMT <angelborroy> we made also some arrangements on postgresql database

2018-10-31 15:48:14 GMT <alfresco-discord> <Thijs> @angel.borroy to do what?

2018-10-31 15:48:56 GMT <angelborroy> I’m reading the report now

2018-10-31 15:48:57 GMT <angelborroy> let me see

2018-10-31 15:49:35 GMT <angelborroy> ah, ok

2018-10-31 15:49:40 GMT <angelborroy> to create postgresql schema

2018-10-31 15:50:04 GMT <angelborroy> creating tables, indexes, constraints and sequences

2018-10-31 15:50:07 GMT <alfresco-discord> <Thijs> yes, that java application I used, but I had to update it for the new Alfresco schema

2018-10-31 15:50:11 GMT <angelborroy> and also an updating on sequences

2018-10-31 15:50:15 GMT <alfresco-discord> <Thijs> and I sent back the PR

2018-10-31 15:50:35 GMT <angelborroy> Mikel is now working for Zylk

2018-10-31 15:50:44 GMT <angelborroy> He left keensoft some months ago

2018-10-31 15:50:55 GMT <angelborroy> But he will open to accept that contribution

2018-10-31 15:50:56 GMT <angelborroy> for sure

End of Daily Log

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