Migrating from one database to another with Pentaho ETL
From PostgreSQL wiki
Migration (schema + data) from one database to another can easily be done with Pentaho ETL. It's an opensource software and I personally recommend you to take a look at.
Steps for migration are very simple:
1) Create a New Job
2) Create Source Database Connection
3) Create Destination Database Connection
4) From Wizard menu, choose Copy Tables Wizard...
5) Choose Source and Destination
6) Run the task
That's all folks !!!