Limit initial snapshot
#30093
-
|
Is it possible to limit or skip initial snapshot with PostgreSQL connector? I want to quickly test materialize with massive database and don't need most existing data, just real-time changes. |
Beta Was this translation helpful? Give feedback.
Answered by
morsapaes
Oct 19, 2024
Replies: 1 comment
-
|
This is not possible, since we need to take a consistent snapshot of the existing database state before resuming real-time ingestion. For testing, we recommend limiting the number of tables you add to the publication by using the |
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
mwisnicki
# for free
to join this conversation on GitHub.
Already have an account?
# to comment
This is not possible, since we need to take a consistent snapshot of the existing database state before resuming real-time ingestion. For testing, we recommend limiting the number of tables you add to the publication by using the
CREATE PUBLICATION...FOR TABLE(instead ofFOR ALL TABLES) clause (as described in the documentation).