Converting VCS from MySQL to PostgreSQL
Henk Noppe
henk at omnihis.nl
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
http://www.omnihis.nl
E-mail: h.noppe at omnihis.nl
On 25 Aug 2014, at 16:02, Andrew Stolarz <stolarz at gmail.com> 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 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
>>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
More information about the omnisdev-en
mailing list