Converting VCS from MySQL to PostgreSQL

Henk Noppe henk at
Mon Aug 25 10:47:58 EDT 2014

Thank you Andrew,

I will look in to this and report what the results are.

With kind regards,
Henk Noppe
OmniHis BV
E-mail: h.noppe at

On 25 Aug 2014, at 16:02, Andrew Stolarz <stolarz at> wrote:

> Henk,
> I dont think switching to PostgresQL is going to solve your "timeout"
> issue. I have gone for over a week of inactivity without any issues.
> Have you adjusted all the MySQL server variable settings correctly?
> ie:
> connect_timeout
> interactive_timeout
> net_read_timeout
> net_write_timeout
> wait_timeout
> If your connection is dropping after setting these variables correctly,
> then there is something else at play here and not so much a mysql issue.
> Andrew
> On Mon, Aug 25, 2014 at 3:05 AM, Henk Noppe <henk at> wrote:
>> Hejhej dear people,
>> Due to some connectivity problems we want to switch the VCS from MySQL to
>> PostgreSQL. The problem we have is that the connection is cut off after a
>> periode of time of inactivity or when you working in method windows for a
>> certain amount of time. In the past we have received a MySQL ping library
>> which should solve this problem, but this has never solved completely. Now
>> we use the scheduled build function of the VCS this problem has become
>> annoying, because our testers and the automated tests are relying on this.
>> On the internet I saw some scripts to convert a MySQL database to
>> PostgreSQL, but I am not sure how reliable that is. Are there other
>> possibilities. Does any of you have experience with switching from MySQL to
>> PostgreSQL?
>> With kind regards,
>> Henk Noppe
>> OmniHis BV
>> E-mail:
>> h.noppe at omnihis.nl_____________________________________________________________
>> Manage your list subscriptions at
> _____________________________________________________________
> Manage your list subscriptions at

More information about the omnisdev-en mailing list