Expand description
PostgreSQL sink: applies decoded changes inside target transactions and stores the job checkpoint in the same transaction.
Structs§
- PgSink
- Runtime
Row - One heartbeat of the running process, written outside any data transaction.
- Sink
Limits
Constants§
Functions§
- configure_
session - Settings every pgsync session on the target needs: a fixed search path, durable commits,
and no inherited timeouts. A
statement_timeoutoridle_in_transaction_session_timeoutset on the target role or database would otherwise cancel long transactions or large copies on every attempt (SQLSTATE 57014 is retried, so the job would stall, not fail). - delete_
job - Delete the job’s metadata rows (used by
cleanup). - set_
job_ state - upsert_
checkpoint - Insert or update the job row (autocommit).
- upsert_
runtime