Hi, franrtorres77 <franrtorre...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
