Converting VCS from MySQL to PostgreSQL

Andrew Stolarz stolarz at
Mon Aug 25 10:02:55 EDT 2014


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?



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.


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

More information about the omnisdev-en mailing list