pglogical
pglogical copied to clipboard
Is it possible to use pglogical for only bulk load
We're migrating data from AWS Postgres RDS v10.6 to AWS Aurora postgres 13.4 across accounts and have setup replication using pglogical such that any new data written into postgres is also replicated into aurora.
We've used row-filters in our replication sets to copy-over only a few days worth of historical data as we're mostly concerned with new data coming in every day.
That being said, we would still like to have the remaining historical data be copied over.
Is it possible to use pgological for only bulk-loading of data and not replication? The idea being that we'll use row-filters to migrated over days/weeks of historical data at a time while maintaining the ongoing replication.