Rural Hunter <ruralhunter@xxxxxxxxx> wrote: > it's a problem of migrating vast data from mysql to pgsql. I don't know how helpful you'll find this, but when we migrated to PostgreSQL a few years ago, we had good luck with using Java to stream from one database to another. Be sure to include a lot of inserts in each database transactions. We used prepared statements for the inserts. I don't know whether you would consider our data "vast" -- we had about 100 production databases. At the time the largest was 200 GB. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin