Execute export dump commands and transfer using nifi

[#1]

I want to execute export command to take the PSQL dump of the database and transfer it using NIFI and the execute the import command at the destination db.
can anyone provide a flow to do so ?

[#2]

If you download the Postgres JDBC driver's you can leverage any of the SQL processors to query Postgres directly instead of using pgdump. 

https://jdbc.postgresql.org/download/