PGD reference v5.6.1
Warning: You are not reading the most recent version of this documentation.
Documentation improvements are made only to the latest version.
As per semantic versioning, PGD minor releases remain backward compatible and may include important bug fixes and enhancements.
We recommend upgrading the latest minor release as soon as possible.
If you want up-to-date information, read the latest PGD documentation.
Documentation improvements are made only to the latest version.
As per semantic versioning, PGD minor releases remain backward compatible and may include important bug fixes and enhancements.
We recommend upgrading the latest minor release as soon as possible.
If you want up-to-date information, read the latest PGD documentation.
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.leaderbdr.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_commit_scopebdr.stat_commit_scope_statebdr.stat_raft_followers_statebdr.stat_raft_statebdr.stat_receiverbdr.stat_relationbdr.stat_routing_candidate_statebdr.stat_routing_statebdr.stat_subscriptionbdr.stat_workerbdr.stat_writerbdr.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_node_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_resolvedbdr.logical_transaction_status
Commit Scope functions
bdr.add_commit_scopebdr.create_commit_scopebdr.alter_commit_scopebdr.drop_commit_scopebdr.remove_commit_scope
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.lock_table_lockingbdr.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
Topology settings
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.drop_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 targets
- Commit scope groups
- Confirmation level
- Commit Scope kinds
- SYNCHRONOUS COMMIT
- GROUP COMMIT
- CAMO
- LAG CONTROL
Conflicts
Conflict functions
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.autopartition_partitionsbdr.autopartition_rulesbdr.ddl_epochbdr.event_historybdr.event_summarybdr.local_leader_changebdr.node_configbdr.node_config_summarybdr.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
bdr.taskmgr_set_leaderbdr.taskmgr_get_last_completed_workitembdr.taskmgr_work_queue_check_statusbdr.pglogical_proto_version_rangesbdr.get_min_required_replication_slotsbdr.get_min_required_worker_processesbdr.stat_get_activitybdr.worker_role_id_namebdr.lag_historybdr.get_raft_instance_by_nodegroupbdr.monitor_camo_on_all_nodesbdr.monitor_raft_details_on_all_nodesbdr.monitor_replslots_details_on_all_nodesbdr.monitor_subscription_details_on_all_nodesbdr.monitor_version_details_on_all_nodesbdr.node_group_member_info
Conflict functions
Column-level conflict functions
Conflicts
- On this page
- User visible catalogs and views
- System functions
- PGD settings
- Node management
- Node management interfaces
- Routing functions
- Commit scopes
- Conflicts
- Conflict functions
- 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
- Column-level conflict functions
- Conflicts