Re: Adding data from mysql to postgresql periodically

From: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Adding data from mysql to postgresql periodically
Date: 2010-11-14 13:12:39
Message-ID: 201011141412.39270.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sunday 14. November 2010 13.44.53 franrtorres77 wrote:
>
> Hi there
>
> I need to add periodically some data from a remote mysql database into our
> postgresql database. So, does anyone know how to do it having in mind that
> it must be runned every minute or so for adding new records to the
> postresql?

It should be trivial to write a Perl script that pulls the data from MySQL,
inserts them into PostgreSQL, and then goes to sleep for 60 seconds.

regards,
Leif B. Kristensen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message franrtorres77 2010-11-14 13:30:25 Re: Adding data from mysql to postgresql periodically
Previous Message franrtorres77 2010-11-14 12:44:53 Adding data from mysql to postgresql periodically