How to switch to Postgres

[Tyree731]

I was wondering how one would switch the backend database of Mirth to be Postgres (or any other database manager for that matter). I know in conf/mirth.properties there is an option for changing the database. When I set it to postgres however Mirth flips out.

[chrisl]

Re:How to switch to Postgres

That is half the process!

1. Change mirth.properties to use postgres (just set db = postgres)
2. Go to postgres-SqlMapConfig.properties and set the proper database URL and credentials
3. Create a Mirth db on your postgres server
4. Run postgres-database.sql (in main mirth directory) on your db. You might need to remove the "Drop table" statements

Mirth 1.4.1 includes a GUI tool that makes this much easier.

[Tyree731]

Re:How to switch to Postgres

Thank you