From: | franrtorres77 <franrtorres77(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Adding data from mysql to postgresql periodically |
Date: | 2010-11-14 13:30:25 |
Message-ID: | AANLkTimSMwQ4fxVvD_ra+DausF4WQU4LUw6HL6KtcwyN@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | franrtorres77 | 2010-11-14 13:33:39 | Re: Adding data from mysql to postgresql periodically |
Previous Message | Leif Biberg Kristensen | 2010-11-14 13:12:39 | Re: Adding data from mysql to postgresql periodically |