Closed torgeirl closed 2 months ago
I have been able to start INCEpTION with postgres some time back, but I believe there were still various places in the database schema where INCEpTION is not quite compatible with postgres. Feel free to experiment if you like, but know that for me postgres is not a priority atm.
Noted! I'll see what I can do myself.
To fix these issues, it would be necessary to change the db-changelog.xml
files in the project. However, those changes would need to be made very careful such that they not only work with postgres but also with hsqldb (embedded) and mariadb/mysql and that they would not break existing user's setups. Thus, they would need to be made in such a way that they migrate the existing database setup to a version that would be compatible with Postgres without losing data.
Closed this issue since I'm unable to fix it myself, but now realizing you had put it in the maintenance backlog milestone I'll re-open it as I do really want to see this in the future if possible. :crossed_fingers: :crossed_fingers:
Is your feature request related to a problem? Please describe. I would like to use PostgreSQL instead of MariaDB for my Inception deployment since it has better support in my organization, and are therefore wondering if it would be possible to add experimental Postgres support to Inception?
Describe the solution you'd like There is a mention of testing Postgres dating back to October 2021 (#2681), and since then there have been quite a few updates with the goal of improve database compatibility (#3400).
Adding the hacks mentioned in the #3400 to a local Snapshot build I'm able to start the application just fine, but trying to either create a new project or importing the example projects I run into error such as:
Would it be possible to:
database.globally_quoted_identifiers
,database.ddl-auto
and others if needed to allow this to be tested beyond local snapshots(Not sure how much work this would entail so please say no / not now if this isn't possible / possible now!)
Additional context Changes to
inception/inception-app-webapp/src/main/resources/application.yml
(as suggested in #3400):Database settings in
settings.properties
: