Using the Postgres Service

With the Postgres service, you can create additional databases for other uses, set up replication of the database, view logs, and view current database queries.

Select Services > Postgres to open a sub-menu. If you select Postgres, it is the same as selecting the first entry in the sub-menu, Database Management. The other entries in the sub-menu are shortcuts to actions that are available using buttons on the Database Management window.

An instance of PostgreSQL (or Postgres) runs on the appliance that is used by Mirth® Connect. With the Postgres service, you can create additional databases for other uses, set up replication of the database, view logs, and view current database queries.

To set up a new database, select Add Database. Adding a database enables you, for example, to create a local database to use as the source or destination of a Mirth® Connect channel or to use as the backend database for an external application.

Selecting Add Database opens the Add Database window. Enter a Database Name, Database Username, and a Password. You can optionally select Enable Read-Only User (_ro) and Enable External Access. You could also secure external access by entering specific IP addresses in Restrict connections to IP Address(es). When you select Add, the database and user are created. The database service only allows one user per database.

You can edit an existing database by selecting the linked name in the list on the Database Management window. You can change the user’s password, modify external access options, or delete the entire database. When you delete a database, the user is removed and the database is deleted, reclaiming any disk space used. You cannot remove the Mirth® Connect (mirthdb) database.

Because the PostgreSQL database used by the Database Service is also used by Mirth® Connect, the Database Service must be running when the Mirth® Connect Server is running, and vice versa.

You can view the database logs from the Database Management window by selecting View Logs. After the log viewer opens, you can download the full log by selecting Download Full Log at the bottom of the window.

You can also view and end queries currently running on the databases by selecting View Current Queries.