4 ms·
Have you considered using PostgreSQL foreign data wrapper (mysql_fdw) to pull data directly out of MySQL instead of the dump/load process? It would be great to
by nigma 14y ago
Have you considered using PostgreSQL foreign data wrapper (mysql_fdw) to pull data directly out of MySQL instead of the dump/load process?
It would be great to know more about your new setup, i.e. do you use streaming replication and some resource manager like Pacemaker?
- simonw 14y agoNo, we didn't look at mysql_fdw. We're using standard PostgreSQL 9 streaming replication.