Changes required for migrating from Oracle to Postgre

[alphaThippesh]

Hi, I was running ejbca 9.1.1 using wildfly-36.0.1 and for DB I use oracle.
Now I want to migrate to postgre. Even with empty data is also fine.
I made certain changes, ejbca is connecting to postgre DB, but the ddl scripts that ejbca executes while coming up is generated in oracle format and as a result am getting few errors.

Can you please suggest what are the changes to be done to work with postgre DB.
Thanks

[primetomas]

You have to change your database.type in database.properties for the ddl to be for your selected database type.

[alphaThippesh]

Hi Thanks, for your reply. It worked for me.
I have one more question on the same, I have multiple instances where ejbca is running. And different instance use different DB type.
If I change the database.properties , I have to build the code base and which result in a new image tag. And I cannot use different image tags for different instances. So, is there a way to externalise this property to support multiple DB types?

[primetomas]

If you are playing with source you can do anything you want. In the official EJBCA container it's handled in scripts on container start, sensing what database it is from the url. You can always investigate how it's done there.