in reply to Looking to convert all my MySQL DB's to postgresql, any experiences with mysql2pgsql?
Before committing potential suicide...
pg_dumpall -c --attribute-inserts > copy_of_mycluster_of-databases-$(date +%F_%H\:%M).sqlif you have oids copy also this objects with the option --oids
To restore simply load the file with something like psql -f copy_of_mycluster_of-databases-*.sql postgres
|
|---|