Skip to main content
Gold ⭐️⭐️
Jun 27, 2023 7:59 AM UTC
Question

Execute export dump commands and transfer using nifi

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 ?

1 reply

joseomjr
Gold ⭐️⭐️
Jul 2, 2023 7:15 PM UTC

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/

Translate