Re: Adding data from mysql to postgresql periodically

Hi,

franrtorres77 <franrtorres77@gmail.com> writes:
> 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?

I've been doing that with pgloader already, using mysqldump -T -w
options to get csv output and a where clause (incremental dumps of some
sort). It worked and allows to validate that we'd be better served with
PostgreSQL, so we migrated away from MySQL as soon as possible.

Don't miss the pgloader user module reformat feature, and the mysql to
PostgreSQL timestamp that you have to use sometime (depends on the MySQL
minor version, if memory serves).

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support