web stats
Postgres Setup - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 01-02-2017, 11:09 PM
Thoughts_Shared Thoughts_Shared is offline
OBX.2 Kenobi
 
Join Date: Dec 2016
Posts: 58
Thoughts_Shared is on a distinguished road
Angry Postgres Setup

I am attempting to connect Postgres to Mirth Connect. After few initial hiccups, I was able configure it in Mirth Connect Server Manager, restarted Mirth Services. Post restarting the service, I get a clean Mirth Connect - all the channels are gone - clean slate.

I followed the steps provided below:

http://www.mirthcorp.com/community/w...ing+PostgreSQL

Is there a bug or is there something I did not do correctly?

Also how do I recover the old channels?

Last edited by Thoughts_Shared; 01-03-2017 at 12:33 AM.
Reply With Quote
  #2  
Old 01-03-2017, 01:30 AM
Thoughts_Shared Thoughts_Shared is offline
OBX.2 Kenobi
 
Join Date: Dec 2016
Posts: 58
Thoughts_Shared is on a distinguished road
Default

The issue was with Switching the DB from Derby to POSTGRE. Had to migrate the data.
Reply With Quote
  #3  
Old 01-03-2017, 02:01 AM
siddharth siddharth is offline
Mirth Guru
 
Join Date: Feb 2013
Posts: 832
siddharth is on a distinguished road
Default

When you made the switch, mirth created its own structured DB on Postgre. So its in clean state now.

If you are worried about your existing channel data, that might still be available on its default location where derby was residing, in the appdata folder inside mirth connect folder.

You can re-point to the previous db and get your channels back.

To Re-point
open mcmanager(tray icon) ->Database tab->select derby and use this setting jdbc:derby:${dir.appdata}/mirthdb;

Last edited by siddharth; 01-03-2017 at 02:02 AM. Reason: Added more content
Reply With Quote
Reply

Tags
postgres, postgres mirth setup

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 11:03 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation