https://community.cloudera.com/t5/Support-Questions/Execute-export-dump-commands-and-transfer-using-nifi/m-p/373283#M241545 <P>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.<BR />can anyone provide a flow to do so ?</P> Tue, 27 Jun 2023 07:59:53 GMT Fanxxx 2023-06-27T07:59:53Z https://community.cloudera.com/t5/Support-Questions/Execute-export-dump-commands-and-transfer-using-nifi/m-p/373283#M241545 <P>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.<BR />can anyone provide a flow to do so ?</P> Tue, 27 Jun 2023 07:59:53 GMT https://community.cloudera.com/t5/Support-Questions/Execute-export-dump-commands-and-transfer-using-nifi/m-p/373283#M241545 Fanxxx 2023-06-27T07:59:53Z https://community.cloudera.com/t5/Support-Questions/Execute-export-dump-commands-and-transfer-using-nifi/m-p/373498#M241607 <P>If you download the Postgres JDBC driver's you can leverage any of the SQL processors to query Postgres directly instead of using pgdump.&nbsp;</P><P>&nbsp;</P><P><A href="https://jdbc.postgresql.org/download/" target="_blank">https://jdbc.postgresql.org/download/</A></P> Sun, 02 Jul 2023 19:15:48 GMT https://community.cloudera.com/t5/Support-Questions/Execute-export-dump-commands-and-transfer-using-nifi/m-p/373498#M241607 joseomjr 2023-07-02T19:15:48Z