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 >
