PGD reference v5
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_journalbdr.commit_scopesbdr.conflict_historybdr.conflict_history_summarybdr.consensus_kv_databdr.crdt_handlersbdr.ddl_replicationbdr.dependbdr.global_consensus_journalbdr.global_consensus_journal_detailsbdr.global_consensus_response_journalbdr.global_lockbdr.global_locksbdr.group_camo_detailsbdr.group_raft_detailsbdr.group_replslots_detailsbdr.group_subscription_summarybdr.group_versions_detailsbdr.local_consensus_snapshotbdr.local_consensus_statebdr.local_nodebdr.local_node_summarybdr.local_sync_statusbdr.nodebdr.node_catchup_infobdr.node_catchup_info_detailsbdr.node_conflict_resolversbdr.node_groupbdr.node_group_replication_setsbdr.node_group_summarybdr.node_local_infobdr.node_log_configbdr.node_peer_progressbdr.node_replication_ratesbdr.node_slotsbdr.node_summarybdr.queuebdr.replication_setbdr.replication_set_tablebdr.replication_set_ddlbdr.replication_setsbdr.schema_changesbdr.sequence_allocbdr.sequencesbdr.stat_activitybdr.stat_relationbdr.stat_subscriptionbdr.subscriptionbdr.subscription_summarybdr.tablesbdr.taskmgr_work_queuebdr.taskmgr_workitem_statusbdr.taskmgr_local_work_queuebdr.taskmgr_local_workitem_statusbdr.triggerbdr.triggersbdr.workersbdr.writersbdr.worker_tasks
System functions
Version information functions
System information functions
System and progress information parameters
Consensus function
bdr.consensus_disablebdr.consensus_enablebdr.consensus_proto_versionbdr.consensus_snapshot_exportbdr.consensus_snapshot_importbdr.consensus_snapshot_verifybdr.get_consensus_statusbdr.get_raft_statusbdr.raft_leadership_transfer
Utility functions
bdr.wait_slot_confirm_lsnbdr.wait_for_apply_queuebdr.get_node_sub_receive_lsnbdr.get_node_sub_apply_lsnbdr.replicate_ddl_commandbdr.run_on_all_nodesbdr.run_on_nodesbdr.run_on_groupbdr.global_lock_tablebdr.wait_for_xid_progressbdr.local_group_slot_namebdr.node_group_typebdr.alter_node_kindbdr.alter_subscription_skip_changes_upto
Global advisory locks
Monitoring functions
bdr.monitor_group_versionsbdr.monitor_group_raftbdr.monitor_local_replslotsbdr.wal_sender_statsbdr.get_decoding_worker_statbdr.lag_control
CAMO functions
bdr.is_camo_partner_connectedbdr.is_camo_partner_readybdr.get_configured_camo_partnerbdr.wait_for_camo_partner_queuebdr.camo_transactions_resolved- bdr.logical_transaction_status
Commit Scope functions
PGD settings
Conflict handling
Global sequence parameters
DDL handling
bdr.default_replica_identitybdr.ddl_replicationbdr.role_replicationbdr.ddl_lockingbdr.truncate_locking
Global locking
bdr.global_lock_max_locksbdr.global_lock_timeoutbdr.global_lock_statement_timeoutbdr.global_lock_idle_timeoutbdr.predictive_checks
Node management
Generic replication
bdr.writers_per_subscriptionbdr.max_writers_per_subscriptionbdr.xact_replicationbdr.permit_unsafe_commandsbdr.batch_insertsbdr.maximum_clock_skewbdr.maximum_clock_skew_actionbdr.accept_connectionsbdr.standby_slot_namesbdr.standby_slots_min_confirmedbdr.writer_input_queue_sizebdr.writer_output_queue_sizebdr.min_worker_backoff_delay
CRDTs
Commit Scope
Commit At Most Once
Transaction streaming
Lag Control
bdr.lag_control_max_commit_delaybdr.lag_control_max_lag_sizebdr.lag_control_max_lag_timebdr.lag_control_min_conforming_nodesbdr.lag_control_commit_delay_adjustbdr.lag_control_sample_intervalbdr.lag_control_commit_delay_start
Timestamp-based snapshots
Monitoring and logging
bdr.debug_levelbdr.trace_levelbdr.track_subscription_applybdr.track_relation_applybdr.track_apply_lock_timing
Decoding Worker
Connectivity settings
bdr.global_connection_timeoutbdr.global_keepalivesbdr.global_keepalives_idlebdr.global_keepalives_intervalbdr.global_keepalives_countbdr.global_tcp_user_timeout
Internal settings - Raft timeouts
Internal settings - Other Raft values
bdr.raft_keep_min_entriesbdr.raft_log_min_apply_durationbdr.raft_log_min_message_durationbdr.raft_group_max_connections
Internal settings - Other values
bdr.backwards_compatibilitybdr.track_replication_estimatesbdr.lag_tracker_apply_rate_weightbdr.enable_auto_sync_reconcile
Node management
Node management interfaces
bdr.alter_node_group_optionbdr.alter_node_interfacebdr.alter_node_optionbdr.alter_subscription_enablebdr.alter_subscription_disablebdr.create_nodebdr.create_node_groupbdr.join_node_groupbdr.part_nodebdr.promote_nodebdr.switch_node_groupbdr.wait_for_join_completionbdr.alter_node_group_config
Routing functions
Commit scopes
- Commit scope syntax
- Commit scope groups
- Confirmation level
- Commit Scope kinds
- GROUP COMMIT
- CAMO
- LAG CONTROL
- SYNCHRONOUS_COMMIT
Replication set management
bdr.create_replication_setbdr.alter_replication_setbdr.drop_replication_setbdr.alter_node_replication_sets
Replication set membership
DDL replication filtering
Testing and tuning commands
Global sequence management interfaces
Sequence functions
bdr.alter_sequence_set_kindbdr.extract_timestamp_from_snowflakeidbdr.extract_nodeid_from_snowflakeidbdr.extract_localseqid_from_snowflakeidbdr.timestamp_to_snowflakeidbdr.extract_timestamp_from_timeshardbdr.extract_nodeid_from_timeshardbdr.extract_localseqid_from_timeshardbdr.timestamp_to_timeshard
KSUUID v2 Functions
KSUUID v1 functions
Autopartition
bdr.autopartitionbdr.drop_autopartitionbdr.autopartition_wait_for_partitionsbdr.autopartition_wait_for_partitions_on_all_nodesbdr.autopartition_find_partitionbdr.autopartition_enablebdr.autopartition_disable- Internal functions
bdr.autopartition_create_partitionbdr.autopartition_drop_partition
Stream triggers reference
Stream triggers manipulation interfaces
Stream triggers row functions
bdr.trigger_get_rowbdr.trigger_get_committsbdr.trigger_get_xidbdr.trigger_get_typebdr.trigger_get_conflict_typebdr.trigger_get_origin_node_idbdr.ri_fkey_on_del_trigger
Stream triggers row variables
Internal catalogs and views
bdr.ddl_epochbdr.event_historybdr.event_summarybdr.node_configbdr.node_group_configbdr.node_group_routing_config_summarybdr.node_group_routing_infobdr.node_group_routing_summarybdr.node_routing_config_summarybdr.proxy_configbdr.proxy_config_summarybdr.sequence_kind
Internal system functions
General internal functions
bdr.bdr_get_commit_decisionsbdr.bdr_track_commit_decisionbdr.consensus_kv_fetchbdr.consensus_kv_storebdr.decode_message_payloadbdr.decode_message_response_payloadbdr.difference_fix_origin_createbdr.difference_fix_session_resetbdr.difference_fix_session_setupbdr.difference_fix_xact_set_avoid_conflictbdr.drop_nodebdr.get_global_locksbdr.get_node_conflict_resolversbdr.get_slot_flush_timestampbdr.internal_alter_sequence_set_kindbdr.internal_replication_set_add_tablebdr.internal_replication_set_remove_tablebdr.internal_submit_join_requestbdr.isolation_test_session_is_blockedbdr.local_node_infobdr.msgb_connectbdr.msgb_deliver_messagebdr.node_catchup_state_namebdr.node_kind_namebdr.peer_state_namebdr.pg_xact_originbdr.request_replay_progress_updatebdr.reset_relation_statsbdr.reset_subscription_statsbdr.resynchronize_table_from_nodebdr.seq_currvalbdr.seq_lastvalbdr.seq_nextvalbdr.show_subscription_statusbdr.show_workersbdr.show_writers
Task Manager Functions
Conflict functions
- On this page
- User visible catalogs and views
- System functions
- PGD settings
- Node management
- Node management interfaces
- Routing functions
- Commit scopes
- Replication set management
- Replication set membership
- DDL replication filtering
- Testing and tuning commands
- Global sequence management interfaces
- Autopartition
- Stream triggers reference
- Stream triggers manipulation interfaces
- Stream triggers row functions
- Stream triggers row variables
- Internal catalogs and views
- Internal system functions
- Conflict functions