Did exactly that, with a simple in-house ETL in python that has not failed us once and is virtually real-time, something the SAAS solutions could not do. Also blogged about not doing this: https://unwindprotect.com/postgres-fdw