Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding data from mysql to postgresql periodically - Mailing list pgsql-general

From franrtorres77
Subject Re: Adding data from mysql to postgresql periodically
Date
Msg-id AANLkTimSMwQ4fxVvD_ra+DausF4WQU4LUw6HL6KtcwyN@mail.gmail.com
Whole thread Raw
In response to Re: Adding data from mysql to postgresql periodically  (Leif Biberg Kristensen <leif@solumslekt.org>)
List pgsql-general
Tree view
So, do you know where I can find out an example for that?

Fran


On 14 November 2010 14:13, Leif Biberg Kristensen [via PostgreSQL] <[hidden email]> wrote:
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

--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


View message @ http://postgresql.1045698.n5.nabble.com/Adding-data-from-mysql-to-postgresql-periodically-tp3264392p3264406.html
To unsubscribe from Adding data from mysql to postgresql periodically, click here.



View this message in context: Re: Adding data from mysql to postgresql periodically
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Leif Biberg Kristensen
Date:
Subject: Re: Adding data from mysql to postgresql periodically
Next
From: franrtorres77
Date:
Subject: Re: Adding data from mysql to postgresql periodically