pg2os.yaml

source:
  postgres:
    url: "postgres://postgres:postgres@localhost:5432?sslmode=disable"
    mode: snapshot_and_replication # options are replication, snapshot or snapshot_and_replication
    snapshot: # when mode is snapshot or snapshot_and_replication
      mode: full # options are data_and, schema or data
      tables: ["*"] # tables to snapshot, can be a list of table names or a pattern
      recorder:
        postgres_url: "postgres://postgres:postgres@localhost:5432?sslmode=disable" # URL of the database where the snapshot status is recorded
      snapshot_workers: 1 # number of schemas to be snapshotted in parallel
      data: # when mode is full or data
        schema_workers: 4 # number of schema tables to be snapshotted in parallel
        table_workers: 4 # number of workers to snapshot a table in parallel
        batch_bytes: 83886080 # bytes to read per batch (defaults to 80MiB)
      schema: # when mode is full or schema
        mode: pgdump_pgrestore

target:
  search:
    engine: "opensearch" # options are elasticsearch or opensearch
    url: "http://admin:StrongAdmin123!@localhost:9200" # URL of the search engine
    batch:
      timeout: 5000 # batch timeout in milliseconds
      size: 100 # number of messages in a batch
    backoff: # one of exponential or constant
      exponential:
        max_retries: 0 # maximum number of retries
        initial_interval: 1000 # initial interval in milliseconds
        max_interval: 60000 # maximum interval in milliseconds


modifiers:
  injector:
    enabled: true # whether to inject pgstream metadata into the WAL events
    source_url: "postgres://postgres:postgres@localhost:5432?sslmode=disable" # optional for postgres sources, defaults to source URL
  filter:
    exclude_tables:
    - pgstream.*