What is a good solution for reliably transferring data between SQL Server and PostgreSQL?
Pentaho have an open-source tool called Kettle that we use for ETL development with Postgres. It is quite good and very comprehensive.

http://community.pentaho.com/projects/data-integration/