Currently we warehouse our postgres db using SSIS, but there are certain things we can't do, for example with an ADO.Net provider it isn't possible to use parameters in a data source of the data flow component, we're trying out an OLEDB provider PGNP which looks like it does what we require.
I'd like to know what other options are available and your opinions of them. I've used open talend, but the performance wasn't that good compared to SSIS.
You can try Pentaho Data Integration (PDI, formerly, kettle).
Community Edition is free.
It has a GUI similar to SSIS, easy to use after a short introduction.
It is a Java application, and it uses original, native postgresql JDBC driver - performance should be at least comparable to SSIS.
PDI CE download: http://sourceforge.net/projects/pentaho/files/