Converting VCS from MySQL to PostgreSQL

[Andrew Stolarz]

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 omnihis.nl> 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
> http://www.omnihis.nl
> E-mail:
> h.noppe at omnihis.nl_____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>