PGD Reference

The reference section is a definitive listing of all functions, views and commands available in EDB Postgres Distributed.

User visible catalogs and views

---

• bdr.camo_decision_journal

• bdr.commit_scopes

• bdr.conflict_history

• bdr.conflict_history_summary

• bdr.consensus_kv_data

• bdr.crdt_handlers

• bdr.ddl_replication

• bdr.depend

• bdr.global_consensus_journal

• bdr.global_consensus_journal_details

• bdr.global_consensus_response_journal

• bdr.global_lock

• bdr.global_locks

• bdr.group_camo_details

• bdr.group_raft_details

• bdr.group_replslots_details

• bdr.group_subscription_summary

• bdr.group_versions_details

• bdr.local_consensus_snapshot

• bdr.local_consensus_state

• bdr.local_node

• bdr.local_node_summary

• bdr.local_sync_status

• bdr.node_config

• bdr.node_catchup_info

• bdr.node_catchup_info_details

• bdr.node_conflict_resolvers

• bdr.node_group_config

• bdr.node_group_replication_sets

• bdr.node_group_summary

• bdr.node_local_info

• bdr.node_log_config

• bdr.node_peer_progress

• bdr.node_replication_rates

• bdr.node_slots

• bdr.node_summary

• bdr.queue

• bdr.replication_set

• bdr.replication_set_table

• bdr.replication_set_ddl

• bdr.replication_sets

• bdr.schema_changes

• bdr.sequence_alloc

• bdr.sequences

• bdr.stat_activity

• bdr.stat_relation

• bdr.stat_subscription

• bdr.subscription

• bdr.subscription_summary

• bdr.tables

• bdr.taskmgr_work_queue

• bdr.taskmgr_workitem_status

• bdr.taskmgr_local_work_queue

• bdr.taskmgr_local_workitem_status

• bdr.trigger

• bdr.triggers

• bdr.workers

• bdr.writers

• bdr.worker_tasks

System functions

---

Version information functions

---

• bdr.bdr_version

• bdr.bdr_version_num

System information functions

---

• bdr.get_relation_stats

• bdr.get_subscription_stats

System and progress information parameters

---

• bdr.local_node_id

• bdr.last_committed_lsn

• transaction_id

• bdr.is_node_connected

• bdr.is_node_ready

Consensus function

---

• bdr.consensus_disable

• bdr.consensus_enable

• bdr.consensus_proto_version

• bdr.consensus_snapshot_export

• bdr.consensus_snapshot_import

• bdr.consensus_snapshot_verify

• bdr.get_consensus_status

• bdr.get_raft_status

• bdr.raft_leadership_transfer

Utility functions

---

• bdr.wait_slot_confirm_lsn

• bdr.wait_for_apply_queue

• bdr.get_node_sub_receive_lsn

• bdr.get_node_sub_apply_lsn

• bdr.replicate_ddl_command

• bdr.run_on_all_nodes

• bdr.run_on_nodes

• bdr.run_on_group

• bdr.global_lock_table

• bdr.wait_for_xid_progress

• bdr.local_group_slot_name

• bdr.node_group_type

• bdr.alter_node_kind

• bdr.alter_subscription_skip_changes_upto

Global advisory locks

---

• bdr.global_advisory_lock

• bdr.global_advisory_unlock

Monitoring functions

---

• bdr.monitor_group_versions

• bdr.monitor_group_raft

• bdr.monitor_local_replslots

• bdr.wal_sender_stats

• bdr.get_decoding_worker_stat

• bdr.lag_control

CAMO functions

---

• bdr.is_camo_partner_connected

• bdr.is_camo_partner_ready

• bdr.get_configured_camo_partner

• bdr.wait_for_camo_partner_queue

• bdr.camo_transactions_resolved

• bdr.logical_transaction_status

Commit Scope functions

---

• bdr.add_commit_scope

• bdr.alter_commit_scope

• bdr.remove_commit_scope

PGD settings

---

Exploring conflict handling with PGD

---

• bdr.default_conflict_detection

Global sequence parameters

---

• bdr.default_sequence_kind

DDL handling

---

• bdr.default_replica_identity

• bdr.ddl_replication

• bdr.role_replication

• bdr.ddl_locking

• :ref:``bdr.truncate_locking` <bdr.truncate_locking>`

Global locking

---

• bdr.global_lock_max_locks

• bdr.global_lock_timeout

• bdr.global_lock_statement_timeout

• :ref:``bdr.global_lock_idle_timeout` <bdr.global_lock_idle_timeout>`

• :ref:``bdr.predictive_checks` <bdr.predictive_checks>`

Node management

---

• bdr.replay_progress_frequency

• bdr.standby_slot_names

• Generic replication

• bdr.writers_per_subscription

• bdr.max_writers_per_subscription

• :ref:``bdr.xact_replication` <bdr.xact_replication>`

• bdr.permit_unsafe_commands

• bdr.batch_inserts

• bdr.maximum_clock_skew

• bdr.maximum_clock_skew_action

• :ref:``bdr.accept_connections` <bdr.accept_connections>`

• bdr.standby_slot_names

• bdr.standby_slots_min_confirmed

• bdr.writer_input_queue_size

• bdr.writer_output_queue_size

• bdr.min_worker_backoff_delay

CRDTs

---

• :ref:``bdr.crdt_raw_value` <bdr.crdt_raw_value>`

Commit scopes

---

• bdr.commit_scopes

Commit At Most Once

---

• bdr.camo_local_mode_delay

• :ref:``bdr.camo_enable_client_warnings` <bdr.camo_enable_client_warnings>`

Transaction streaming

---

• bdr.default_streaming_mode

Lag Control

---

• bdr.lag_control_max_commit_delay

• :ref:``bdr.lag_control_max_lag_size` <bdr.lag_control_max_lag_size>`

• bdr.lag_control_max_lag_time

• bdr.lag_control_min_conforming_nodes

• bdr.lag_control_commit_delay_adjust

• bdr.lag_control_sample_interval

• bdr.lag_control_commit_delay_start

Timestamp-based snapshots

---

• bdr.timestamp_snapshot_keep

Monitoring and logging

---

• bdr.debug_level

• :ref:``bdr.trace_level` <bdr.trace_level>`

• bdr.track_subscription_apply

• bdr.track_relation_apply

• bdr.track_apply_lock_timing

Decoding Worker

---

• bdr.enable_wal_decoder

• bdr.receive_lcr

• bdr.lcr_cleanup_interval

Connectivity settings

---

• bdr.global_connection_timeout

• bdr.global_keepalives

• bdr.global_keepalives_idle

• bdr.global_keepalives_interval

• bdr.global_keepalives_count

• bdr.global_tcp_user_timeout

Internal settings - Raft timeouts bdr.raft_global_election_timeout

---

• Internal settings - Raft timeouts bdr.raft_global_election_timeout

• bdr.raft_local_election_timeout

• bdr.raft_response_timeout

Internal settings - Other Raft values

---

• bdr.raft_keep_min_entries

• bdr.raft_log_min_apply_duration

• bdr.raft_log_min_message_duration

• bdr.raft_group_max_connections

Internal settings - Other values

---

• bdr.backwards_compatibility

• bdr.track_replication_estimates

• bdr.lag_tracker_apply_rate_weight

Node management

---

• List of node states

• Node-management commands

• bdr_init_physical

Node management interfaces

---

• bdr.alter_node_group_config

• bdr.alter_node_group_option

• bdr.alter_node_interface

• bdr.alter_node_option

• bdr.alter_subscription_enable

• bdr.alter_subscription_disable

• bdr.create_node

• bdr.create_node_group

• bdr.join_node_group

• bdr.part_node

• bdr.promote_node

• bdr.switch_node_group

• bdr.wait_for_join_completion

Routing functions

---

• bdr.create_proxy

• bdr.alter_proxy_option

• bdr.drop_proxy

• bdr.routing_leadership_transfer

Commit scopes

---

• Commit scope syntax

• Commit scope groups

• ANY

• ANY NOT

• MAJORITY

• MAJORITY NOT

• Installing xpanes

• ALL NOT

• Confirmation level

• ON received

• ON replicated

• ON durable

• ON visible

• Commit Scope kinds

• Group commit

• GROUP COMMIT parameters

• ABORT ON parameters

• transaction_tracking settings

• conflict_resolution settings

• commit_decision settings

• CAMO or commit-at-most-once

• Degrade On parameters

• Lag Control

• LAG CONTROL parameters

• SYNCHRONOUS_COMMIT

Replication set management

---

• bdr.create_replication_set

• bdr.alter_replication_set

• bdr.drop_replication_set

• bdr.alter_node_replication_sets

Replication set membership

---

• bdr.replication_set_add_table

• bdr.replication_set_remove_table

DDL replication filtering

---

• bdr.replication_set_add_ddl_filter

• bdr.replication_set_remove_ddl_filter

Testing and tuning commands

---

• pgd_bench

Global sequence management interfaces

---

Sequence functions

---

• bdr.alter_sequence_set_kind

• bdr.extract_timestamp_from_snowflakeid

• bdr.extract_nodeid_from_snowflakeid

• bdr.extract_localseqid_from_snowflakeid

• bdr.timestamp_to_snowflakeid

• bdr.extract_timestamp_from_timeshard

• bdr.extract_nodeid_from_timeshard

• bdr.extract_localseqid_from_timeshard

• bdr.timestamp_to_timeshard

KSUUID v2 Functions

---

• bdr.gen_ksuuid_v2

• bdr.ksuuid_v2_cmp

• bdr.extract_timestamp_from_ksuuid_v2

KSUUID v1 functions

---

• bdr.gen_ksuuid_v2

• bdr.uuid_v1_cmp

• bdr.extract_timestamp_from_ksuuid_v2

Autopartition

---

• bdr.autopartition

• bdr.drop_autopartition

• bdr.autopartition_wait_for_partitions

• bdr.autopartition_wait_for_partitions_on_all_nodes

• bdr.autopartition_find_partition

• bdr.autopartition_enable

• :ref:``bdr.autopartition_disable` <bdr.autopartition_disable>`

• Internal functions

• bdr.autopartition_create_partition

• bdr.autopartition_drop_partition

Stream Triggers Reference

Stream triggers manipulation interfaces

---

• bdr.create_conflict_trigger

• bdr.create_transform_trigger

• bdr.drop_trigger

Stream triggers row functions

---

• bdr.trigger_get_row

• bdr.trigger_get_committs

• bdr.trigger_get_xid

• bdr.trigger_get_type

• bdr.trigger_get_conflict_type

• bdr.trigger_get_origin_node_id

• bdr.ri_fkey_on_del_trigger

Stream triggers row variables

---

• TG_NAME

• TG_WHEN

• TG_LEVEL

• TG_OP

• TG_RELID

• TG_TABLE_NAME

• TG_TABLE_SCHEMA

• TG_NARGS

• TG_ARGV[]

Internal catalogs and views

---

• bdr.ddl_epoch

• bdr.event_history

• bdr.event_summary

• bdr.node_config

• bdr.node_group_config

• bdr.node_group_routing_config_summary

• bdr.node_group_routing_info

• bdr.node_group_routing_summary

• bdr.node_routing_config_summary

• bdr.proxy_config

• bdr.proxy_config_summary

• bdr.sequence_kind

Internal system functions

---

General internal functions

---

• bdr.bdr_get_commit_decisions

• bdr.bdr_track_commit_decision

• bdr.consensus_kv_fetch

• bdr.consensus_kv_store

• bdr.decode_message_payload

• bdr.decode_message_response_payload

• bdr.difference_fix_origin_create

• bdr.difference_fix_session_reset

• bdr.difference_fix_session_setup

• bdr.difference_fix_xact_set_avoid_conflict

• bdr.drop_node

• bdr.get_global_locks

• bdr.get_node_conflict_resolvers

• bdr.get_slot_flush_timestamp

• bdr.internal_alter_sequence_set_kind

• bdr.internal_replication_set_add_table

• bdr.internal_replication_set_remove_table

• bdr.internal_submit_join_request

• bdr.isolation_test_session_is_blocked

• bdr.local_node_info

• bdr.msgb_connect

• bdr.msgb_deliver_message

• bdr.node_catchup_state_name

• bdr.node_kind_name

• bdr.peer_state_name

• bdr.pg_xact_origin

• bdr.request_replay_progress_update

• bdr.reset_relation_stats

• bdr.reset_subscription_stats

• bdr.resynchronize_table_from_node

• bdr.seq_nextval

• bdr.show_subscription_status

• bdr.show_workers

• bdr.show_writers

Task Manager Functions

---

• bdr.taskmgr_set_leader

• bdr.taskmgr_get_last_completed_workitem

• bdr.taskmgr_work_queue_check_status

• User visible catalogs and views
  • bdr.camo_decision_journal
  • bdr.camo_decision_journal columns
  • bdr.commit_scopes
  • bdr.commit_scopes columns
  • bdr.conflict_history
  • bdr.conflict_history columns
  • bdr.conflict_history_summary
  • bdr.conflict_history_summary columns
  • bdr.consensus_kv_data
  • bdr.consensus_kv_data Columns
  • bdr.crdt_handlers
  • bdr.crdt_handlers Columns
  • bdr.ddl_replication
  • bdr.ddl_replication columns
  • bdr.depend
  • bdr.global_consensus_journal
  • bdr.global_consensus_journal columns
  • bdr.global_consensus_journal_details
  • bdr.global_consensus_journal_details columns
  • bdr.global_consensus_response_journal
  • bdr.global_consensus_response_journal columns
  • bdr.global_lock
  • bdr.global_lock columns
  • bdr.global_locks
  • bdr.global_locks columns
  • bdr.group_camo_details
  • bdr.group_camo_details columns
  • bdr.group_raft_details
  • bdr.group_raft_details columns
  • bdr.group_replslots_details
  • bdr.group_replslots_details columns
  • bdr.group_subscription_summary
  • bdr.group_subscription_summary columns
  • bdr.group_versions_details
  • bdr.group_versions_details columns
  • bdr.local_consensus_snapshot
  • bdr.local_consensus_snapshot columns
  • bdr.local_consensus_state
  • bdr.local_consensus_state columns
  • bdr.local_node
  • bdr.local_node columns
  • bdr.local_node_summary
  • bdr.local_sync_status
  • bdr.local_sync_status columns
  • bdr.node
  • bdr.node columns
  • bdr.node_catchup_info
  • bdr.node_catchup_info columns
  • bdr.node_catchup_info_details
  • bdr.node_conflict_resolvers
  • bdr.node_conflict_resolvers columns
  • bdr.node_group
  • bdr.node_group columns
  • bdr.node_group_replication_sets
  • bdr.node_group_replication_sets columns
  • bdr.node_group_summary
  • bdr.node_group_summary columns
  • bdr.node_local_info
  • bdr.node_local_info columns
  • bdr.node_log_config
  • bdr.node_log_config columns
  • bdr.node_peer_progress
  • bdr.node_peer_progress columns
  • bdr.node_replication_rates
  • bdr.node_replication_rates columns
  • bdr.node_slots
  • bdr.node_slots columns
  • bdr.node_summary
  • bdr.node_summary columns
  • bdr.queue
  • bdr.queue columns
  • bdr.replication_set
  • bdr.replication_set columns
  • bdr.replication_set_table
  • bdr.replication_set_table columns
  • bdr.replication_set_ddl
  • bdr.replication_set_ddl Columns
  • bdr.replication_sets
  • bdr.replication_sets columns
  • bdr.schema_changes
  • bdr.schema_changes columns
  • bdr.sequence_alloc
  • bdr.sequence_alloc columns
  • bdr.sequences
  • bdr.sequences columns
  • bdr.stat_activity
  • bdr.stat_relation
  • bdr.stat_relation columns
  • bdr.stat_subscription
  • bdr.stat_subscription columns
  • bdr.subscription
  • bdr.subscription columns
  • bdr.subscription_summary
  • bdr.subscription_summary columns
  • bdr.tables
  • bdr.tables columns
  • bdr.taskmgr_work_queue
  • bdr.taskmgr_work_queue columns
  • bdr.taskmgr_workitem_status
  • bdr.taskmgr_workitem_status columns
  • bdr.taskmgr_local_work_queue
  • bdr.taskmgr_local_work_queue columns
  • bdr.taskmgr_local_workitem_status
  • bdr.taskmgr_local_workitem_status columns
  • bdr.trigger
  • bdr.trigger columns
  • bdr.triggers
  • bdr.workers
  • bdr.workers Columns
  • bdr.writers
  • bdr.writers columns
  • bdr.worker_tasks
  • bdr.worker_tasks columns
• System functions
  • Version information functions
    • bdr.bdr_version
    • bdr.bdr_version_num
  • System information functions
    • bdr.get_relation_stats
    • bdr.get_subscription_stats
  • System and progress information parameters
    • bdr.local_node_id
    • bdr.last_committed_lsn
    • transaction_id
    • bdr.is_node_connected
    • Synopsis
    • bdr.is_node_ready
    • Synopsis
  • Consensus function
    • bdr.consensus_disable
    • bdr.consensus_enable
    • bdr.consensus_proto_version
    • bdr.consensus_snapshot_export
    • Synopsis
    • bdr.consensus_snapshot_import
    • Synopsis
    • bdr.consensus_snapshot_verify
    • Synopsis
    • bdr.get_consensus_status
    • bdr.get_raft_status
    • bdr.raft_leadership_transfer
    • Synopsis
  • Utility functions
    • bdr.wait_slot_confirm_lsn
    • Synopsis
    • Parameters
    • bdr.wait_for_apply_queue
    • Synopsis
    • Parameters
    • bdr.get_node_sub_receive_lsn
    • Synopsis
    • Parameters
    • bdr.get_node_sub_apply_lsn
    • Synopsis
    • Parameters
    • bdr.replicate_ddl_command
    • Synopsis
    • Parameters
    • Notes
    • bdr.run_on_all_nodes
    • Synopsis
    • Parameters
    • Notes
    • Example
    • bdr.run_on_nodes
    • Synopsis
    • Parameters
    • Notes
    • bdr.run_on_group
    • Synopsis
    • Parameters
    • Notes
    • bdr.global_lock_table
    • Synopsis
    • Parameters
    • Notes
    • bdr.wait_for_xid_progress
    • Synopsis
    • Parameters
    • Notes
    • bdr.local_group_slot_name
    • Example
    • bdr.node_group_type
    • Example
    • bdr.alter_node_kind
    • Synopsis
    • Parameters
    • bdr.alter_subscription_skip_changes_upto
    • Synopsis
    • Example
  • Global advisory locks
    • bdr.global_advisory_lock
    • Synopsis
    • parameters
    • Synopsis
    • parameters
    • bdr.global_advisory_unlock
    • Synopsis
    • Parameters
    • Synopsis
    • Parameters
  • Monitoring functions
    • bdr.monitor_group_versions
    • Synopsis
    • Notes
    • bdr.monitor_group_raft
    • Synopsis
    • Parameters
    • Notes
    • bdr.monitor_local_replslots
    • Synopsis
    • Notes
    • bdr.wal_sender_stats
    • Synopsis
    • Output columns
    • bdr.get_decoding_worker_stat
    • Synopsis
    • Output columns
    • Notes
    • bdr.lag_control
    • Synopsis
    • Output columns
  • CAMO functions
    • bdr.is_camo_partner_connected
    • Synopsis
    • Return value
    • bdr.is_camo_partner_ready
    • Synopsis
    • Return value
    • bdr.get_configured_camo_partner
    • Synopsis
    • bdr.wait_for_camo_partner_queue
    • Synopsis
    • bdr.camo_transactions_resolved
    • Synopsis
    • bdr.logical_transaction_status
    • Synopsis
    • Parameters
    • Return value
  • Commit Scope functions
    • bdr.add_commit_scope
    • Synopsis
    • bdr.alter_commit_scope
    • Synopsis
    • bdr.remove_commit_scope
    • Synopsis
• PGD settings
  • Conflict handling
    • bdr.default_conflict_detection
  • Global sequence parameters
    • bdr.default_sequence_kind
  • DDL handling
    • bdr.default_replica_identity
    • bdr.ddl_replication
    • bdr.role_replication
    • bdr.ddl_locking
    • bdr.truncate_locking
  • Global locking
    • bdr.global_lock_max_locks
    • bdr.global_lock_timeout
    • bdr.global_lock_statement_timeout
    • bdr.global_lock_idle_timeout
    • bdr.predictive_checks
  • Node management
    • bdr.replay_progress_frequency
    • bdr.standby_slot_names
  • Generic replication
    • bdr.writers_per_subscription
    • bdr.max_writers_per_subscription
    • bdr.xact_replication
    • bdr.permit_unsafe_commands
    • bdr.batch_inserts
    • bdr.maximum_clock_skew
    • bdr.maximum_clock_skew_action
    • bdr.accept_connections
    • bdr.standby_slot_names
    • bdr.standby_slots_min_confirmed
    • bdr.writer_input_queue_size
    • bdr.writer_output_queue_size
    • bdr.min_worker_backoff_delay
  • CRDTs
    • bdr.crdt_raw_value
  • Commit Scope
    • bdr.commit_scope
  • Commit At Most Once
    • bdr.camo_local_mode_delay
    • bdr.camo_enable_client_warnings
  • Transaction streaming
    • bdr.default_streaming_mode
  • Lag Control
    • bdr.lag_control_max_commit_delay
    • bdr.lag_control_max_lag_size
    • bdr.lag_control_max_lag_time
    • bdr.lag_control_min_conforming_nodes
    • bdr.lag_control_commit_delay_adjust
    • bdr.lag_control_sample_interval
    • bdr.lag_control_commit_delay_start
  • Timestamp-based snapshots
    • bdr.timestamp_snapshot_keep
  • Monitoring and logging
    • bdr.debug_level
    • bdr.trace_level
    • bdr.track_subscription_apply
    • bdr.track_relation_apply
    • bdr.track_apply_lock_timing
  • Decoding Worker
    • bdr.enable_wal_decoder
    • bdr.receive_lcr
    • bdr.lcr_cleanup_interval
  • Connectivity settings
    • bdr.global_connection_timeout
    • bdr.global_keepalives
    • bdr.global_keepalives_idle
    • bdr.global_keepalives_interval
    • bdr.global_keepalives_count
    • bdr.global_tcp_user_timeout
  • Internal settings - Raft timeouts ### bdr.raft_global_election_timeout
    • bdr.raft_local_election_timeout
    • bdr.raft_response_timeout
  • Internal settings - Other Raft values
    • bdr.raft_keep_min_entries
    • bdr.raft_log_min_apply_duration
    • bdr.raft_log_min_message_duration
    • bdr.raft_group_max_connections
  • Internal settings - Other values
    • bdr.backwards_compatibility
    • bdr.track_replication_estimates
    • bdr.lag_tracker_apply_rate_weight
• Node management
  • List of node states
  • Node-management commands
    • bdr_init_physical
    • Synopsis
    • Options
    • Notes
• Node management interfaces
  • bdr.alter_node_group_config
    • Synopsis
    • Parameters
    • Notes
  • bdr.alter_node_group_option
    • Synopsis
    • Parameters
    • Return value
    • Notes
  • bdr.alter_node_interface
    • Synopsis
    • Parameters
    • Notes
  • bdr.alter_node_option
    • Synopsis
    • Parameters
  • bdr.alter_subscription_enable
    • Synopsis
    • Parameters
    • Notes
  • bdr.alter_subscription_disable
    • Synopsis
    • Parameters
    • Notes
  • bdr.create_node
    • Synopsis
    • Parameters
    • Notes
  • bdr.create_node_group
    • Synopsis
    • Parameters
    • Notes
  • bdr.join_node_group
    • Synopsis
    • Parameters
    • Notes
  • bdr.part_node
    • Synopsis
    • Parameters
    • Notes
  • bdr.promote_node
    • Synopsis
    • Notes
  • bdr.switch_node_group
    • Synopsis
    • Parameters
    • Notes
  • bdr.wait_for_join_completion
    • Synopsis
    • Parameters
    • Notes
• Routing functions
  • bdr.create_proxy
  • Synopsis
  • Parameters
  • bdr.alter_proxy_option
  • Synopsis
  • Parameters
  • bdr.drop_proxy
  • Synopsis
  • Parameters
  • bdr.routing_leadership_transfer
  • Synopsis
  • Parameters
• Commit scopes
  • Commit scope syntax
  • Commit scope groups
    • ANY
    • ANY NOT
    • MAJORITY
    • MAJORITY NOT
    • ALL
    • ALL NOT
  • Confirmation level
    • ON received
    • ON replicated
    • ON durable
    • ON visible
  • Commit Scope kinds
  • GROUP COMMIT
    • GROUP COMMIT parameters
    • ABORT ON parameters
    • transaction_tracking settings
    • conflict_resolution settings
    • commit_decision settings
  • CAMO
    • Degrade On parameters
  • LAG CONTROL
    • LAG CONTROL parameters
  • SYNCHRONOUS_COMMIT
• Replication set management
  • bdr.create_replication_set
    • Synopsis
    • Parameters
    • Notes
  • bdr.alter_replication_set
    • Synopsis
    • Parameters
    • Notes
  • bdr.drop_replication_set
    • Synopsis
    • Parameters
    • Notes
  • bdr.alter_node_replication_sets
    • Synopsis
    • Parameters
    • Notes
• Replication set membership
  • bdr.replication_set_add_table
    • Synopsis
    • Parameters
    • Notes
  • bdr.replication_set_remove_table
    • Synopsis
    • Parameters
    • Notes
• DDL replication filtering
  • bdr.replication_set_add_ddl_filter
  • Synopsis
  • Parameters
  • Notes
  • Examples
  • bdr.replication_set_remove_ddl_filter
  • Synopsis
  • Parameters
  • Notes
• Testing and tuning commands
  • pgd_bench
    • Synopsis
    • Options
    • Setting mode
    • Setting GUC variables
    • Initialization options
    • Options to select what to run
    • Benchmarking options
    • Common options:
• Global sequence management interfaces
  • Sequence functions
    • bdr.alter_sequence_set_kind
    • Synopsis
    • Parameters
    • Notes
    • bdr.extract_timestamp_from_snowflakeid
    • Synopsis
    • Parameters
    • Notes
    • bdr.extract_nodeid_from_snowflakeid
    • Synopsis
    • Parameters
    • Notes
    • bdr.extract_localseqid_from_snowflakeid
    • Synopsis
    • Parameters
    • Notes
    • bdr.timestamp_to_snowflakeid
    • Synopsis
    • Parameters
    • Notes
    • bdr.extract_timestamp_from_timeshard
    • Synopsis
    • Parameters
    • Notes
    • bdr.extract_nodeid_from_timeshard
    • Synopsis
    • Parameters
    • Notes
    • bdr.extract_localseqid_from_timeshard
    • Synopsis
    • Parameters
    • Notes
    • bdr.timestamp_to_timeshard
    • Synopsis
    • Parameters
    • Notes
  • KSUUID v2 Functions
    • bdr.gen_ksuuid_v2
    • Synopsis
    • Notes
    • bdr.ksuuid_v2_cmp
    • Synopsis
    • Parameters
    • Notes
    • bdr.extract_timestamp_from_ksuuid_v2
    • Synopsis
    • Parameters
    • Notes
  • KSUUID v1 functions
    • bdr.gen_ksuuid
    • Synopsis
    • Notes
    • bdr.uuid_v1_cmp
    • Synopsis
    • Notes
    • Parameters
    • bdr.extract_timestamp_from_ksuuid
    • Synopsis
    • Parameters
    • Notes
• Autopartition
  • bdr.autopartition
  • Synopsis
  • Parameters
  • Examples
  • bdr.drop_autopartition
  • Parameters
  • bdr.autopartition_wait_for_partitions
  • Synopsis
  • Parameters
  • bdr.autopartition_wait_for_partitions_on_all_nodes
  • Synopsis
  • Parameters
  • bdr.autopartition_find_partition
  • Synopsis
  • Parameters
  • bdr.autopartition_enable
  • Synopsis
  • Parameters
  • bdr.autopartition_disable
  • Synopsis
  • Parameters
  • Internal functions
  • bdr.autopartition_create_partition
  • Synopsis
  • Parameters
  • Notes
  • bdr.autopartition_drop_partition
  • Synopsis
  • Parameters
  • Notes
• Stream Triggers Reference
  • Stream triggers manipulation interfaces
    • bdr.create_conflict_trigger
    • bdr.create_transform_trigger
    • bdr.drop_trigger
  • Stream triggers row functions
    • bdr.trigger_get_row
    • Synopsis
    • Parameters
    • bdr.trigger_get_committs
    • Synopsis
    • Parameters
    • bdr.trigger_get_xid
    • Synopsis
    • Parameters
    • bdr.trigger_get_type
    • Synopsis
    • bdr.trigger_get_conflict_type
    • Synopsis
    • bdr.trigger_get_origin_node_id
    • Synopsis
    • Parameters
    • bdr.ri_fkey_on_del_trigger
    • Synopsis
  • Stream triggers row variables
    • TG_NAME
    • TG_WHEN
    • TG_LEVEL
    • TG_OP
    • TG_RELID
    • TG_TABLE_NAME
    • TG_TABLE_SCHEMA
    • TG_NARGS
    • TG_ARGV[]
• Internal catalogs and views
  • bdr.ddl_epoch
  • bdr.ddl_epoch columns
  • bdr.event_history
  • bdr.event_history columns
  • bdr.event_summary
  • bdr.node_config
  • bdr.node_config columns
  • bdr.node_group_config
  • bdr.node_group_config columns
  • bdr.node_group_routing_config_summary
  • bdr.node_group_routing_info
  • bdr.node_group_routing_info columns
  • bdr.node_group_routing_summary
  • bdr.node_routing_config_summary
  • bdr.proxy_config
  • bdr.proxy_config columns
  • bdr.proxy_config_summary
  • bdr.sequence_kind
  • bdr.sequence_kind columns
• Internal system functions
  • General internal functions
    • bdr.bdr_get_commit_decisions
    • Synopsis
    • bdr.bdr_track_commit_decision
    • Synopsis
    • bdr.consensus_kv_fetch
    • Synopsis
    • Parameters
    • Notes
    • bdr.consensus_kv_store
    • Synopsis
    • Parameters
    • Notes
    • bdr.decode_message_payload
    • bdr.decode_message_response_payload
    • bdr.difference_fix_origin_create
    • bdr.difference_fix_session_reset
    • Synopsis
    • bdr.difference_fix_session_setup
    • Synopsis
    • bdr.difference_fix_xact_set_avoid_conflict
    • Synopsis
    • bdr.drop_node
    • Synopsis
    • Parameters
    • Notes
    • bdr.get_global_locks
    • bdr.get_node_conflict_resolvers
    • bdr.get_slot_flush_timestamp
    • bdr.internal_alter_sequence_set_kind
    • bdr.internal_replication_set_add_table
    • bdr.internal_replication_set_remove_table
    • bdr.internal_submit_join_request
    • bdr.isolation_test_session_is_blocked
    • bdr.local_node_info
    • bdr.msgb_connect
    • bdr.msgb_deliver_message
    • bdr.node_catchup_state_name
    • Synopsis
    • Parameters
    • bdr.node_kind_name
    • bdr.peer_state_name
    • bdr.pg_xact_origin
    • Synopsis
    • Parameters
    • bdr.request_replay_progress_update
    • bdr.reset_relation_stats
    • bdr.reset_subscription_stats
    • bdr.resynchronize_table_from_node
    • Synopsis
    • Parameters
    • Notes
    • bdr.seq_nextval
    • Notes
    • bdr.show_subscription_status
    • bdr.show_workers
    • Synopsis
    • bdr.show_writers
  • Task Manager Functions
    • bdr.taskmgr_set_leader
    • Synopsis
    • bdr.taskmgr_get_last_completed_workitem
    • Synopsis
    • bdr.taskmgr_work_queue_check_status
    • Synopsis
    • Parameters
    • Notes