Hello All,
I have a requirement to do incremental replication of postgres databases to another db which will be used only for analytics purpose.
Since the db is huge, for first time replication, instead of selecting 5000-10000 rows at each query and inserting in destination, i want to use pgdump operation.
Is this operation supported if i use Prefect workflows or only select queries are supported ?
Thanks in advance.