Automic Workload Automation

Expand all | Collapse all

Replacing Oracle with Postgres

Jump to Best Answer
  • 1.  Replacing Oracle with Postgres

    Posted 11-06-2019 08:20 AM

    Hi Folks


    We are planning on moving to 12.3 early next year and have spotted that 12.3 supports Postgres as the underlying database.


    Has anyone migrated from Oracle to Postgres and if so did you encounter any issues ?





    Please note that Revenue cannot guarantee that any personal and sensitive data, sent in plain text via standard email, is fully secure. Customers who choose to use this channel are deemed to have accepted any risk involved. The alternative communication methods offered by Revenue include standard post and the option to use our (encrypted) MyEnquiries service which is available within myAccount and ROS. You can register for either myAccount or ROS on the Revenue website.  Tabhair faoi deara nach féidir leis na Coimisinéirí Ioncaim ráthaíocht a thabhairt go bhfuil aon sonraí pearsanta agus íogair a gcuirtear isteach i ngnáth-théacs trí r-phost caighdeánach go huile is go hiomlán slán. Meastar go nglacann custaiméirí a úsáideann an cainéal seo le haon riosca bainteach. I measc na modhanna cumarsáide eile atá ag na Coimisinéirí ná post caighdeánach agus an rogha ár seirbhís (criptithe) M'Fhiosruithe a úsáid, tá sí ar fáil laistigh de MoChúrsaí agus ROS. Is féidir leat clárú le haghaidh ceachtar MoChúrsaí nó ROS ar shuíomh gréasáin na gCoimisinéirí.

  • 2.  RE: Replacing Oracle with Postgres
    Best Answer

    Posted 11-13-2019 08:44 AM
    I can just give you some approaches on migrating from oracle to postgresql:

    1) Use Unload in oracle / and Load in posgresql to migrate
    This can take quite some time and memory (on the utilities)
    Not recommended to unload / load with all statistics/execution data for that reason but only for definitions. Make sure you only export the last month of statistics by reorg/unload/... before starting the migration or only migrate definitions and skip all statistics records.

    2) Setup a new system with postgresql and use transportcase or client copy to move project by project to this new system.

    Hope that helps.

  • 3.  RE: Replacing Oracle with Postgres

    Posted 11-13-2019 09:32 AM

    Thanks Tobias


    I was hoping it was that straight forward.

    We never brought the stats and reports with us when we migrated to a new oracle database , so these are  no loss.


    Have you  encountered any issues with characters sets ?