Re: Adding data from mysql to postgresql periodically

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] <
ml-node+3264406-1436673590-144075(at)n5(dot)nabble(dot)com<ml-node%2B3264406-1436673590-144075(at)n5(dot)nabble(dot)com>
> 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]<http://user/SendEmail.jtp?type=node&node=3264406&i=0>)
>
> 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<http://postgresql.1045698.n5.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=3264392&code=ZnJhbnJ0b3JyZXM3N0BnbWFpbC5jb218MzI2NDM5MnwtMTgwNDc3ODEwMw==>.
>
>
>

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Adding-data-from-mysql-to-postgresql-periodically-tp3264392p3264415.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.