I researched that over 80% of migration problems can be solved with Apache SeaTunnel (https://seatunnel.apache.org/) itself, as a sister project. We could build around it for more Fineract-specific needs.
On Thu, Nov 12, 2026 at 11:34 AM Aman Mittal <[email protected]> wrote: > Also looking for Apache SeaTunnel if it can replace the need. > > On Thu, Nov 12, 2026 at 10:27 AM Aman Mittal <[email protected]> > wrote: > >> Hi All, >> >> We have long voted on and accepted FSIP-9. Since the community suggested >> and the majority agreed, provided that "Proper migration steps were >> considered for Postgres," I want to revive discussions on the next steps. >> >> >> https://cwiki.apache.org/confluence/spaces/FINERACT/pages/406622736/FSIP-9+Standardize+on+PostgreSQL >> >> I think we can brainstorm ideas for the migration steps. One of the >> suggestion it received was that we can use pgloader. However, many >> companies or vendors are concerned that their data volume may be large >> based on their organizational size. >> >> I suggest we create a dedicated plugin or perhaps a shared plugin that >> exists outside of Fineract Core. >> >> What the plugin will do: (It will parallelly sync and monitor the >> migration in real time 1:1 with MariaDB or MySQL). Then the vendors can >> implement and sync to PostgreSQL via CDC or other available methods. >> >> When the data keeps syncing to PostgreSQL. Vendors can validate and test >> schema changes live without incurring downtime. >> >> HARD Requirement: Plugin dependency should be ASF compliant (Category A >> dependencies) >> >> I think this idea is worth exploring. >> >> Regards >> Aman >> >
