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.

Note: The functionality associated with the Replication button, which enables you to create a duplicate of the database that can be used as a backup in case of a failure, is described in detail in the Replicate the Database section.

After setting up replication, you can then begin Set Up Automatic Failover.

If you want to set up clustering for Mirth® Connect, you must first set up replication and automatic failover. After these are set up, you can go to Applications > Manage > Clustering > Configuration.

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.

Note: Terminating database queries can result in application errors and could potentially lead to data loss. You should only end a query if you are absolutely certain of what you are doing.

Using the Postgres Service

Recommendations

Set Up Clustering Using the Appliance Control Panel

Replicate the Database

Set Up Automatic Failover

Services Menu