Migrating from Postgresql 9.1 (non drupal) to Percona Server 5.5
I end up using the feeds importers modules. You may have to change (rewrite/delete) your tables.


dump my table in a csv file (*.csv) make sure to add the headers. 
create a content type with the name of my table and have all the columns of my tables
create a feed importer make sure to map the sources (postgreql) and target (drupal mysql) columns
got the import link (homepage/import) to upload the file. this may take a few minutes depending on how big you DB is.
when you go to content you should see all the newly added rows


Hope it helps.