Functions and command#
- Tables, views and functions reference
- User visible catalogs and views
- System functions
- PGD settings
- CRDTs vs conflict handling/reporting
- Global sequence parameters
- DDL handling
- Global locking
- Node management
- Generic replication
- CRDTs Overview
- Commit Scopes
- Commit At Most Once
- Using with transaction streaming
- Lag Control
- Monitoring and logging
- Decoding worker
- Connectivity settings
- Topology settings
- Internal settings - Raft timeouts
- Internal settings - Other Raft values
- Internal settings - Other values
- Node management
- Node management interfaces
- Routing functions
- Commit Scopes
- bdr_read_all_conflicts
- Column-level conflict functions
- Replication set management
- Replication set membership
- DDL replication filtering
- Testing and tuning commands
- Sequences
- Autopartitioning
- Stream triggers reference
- Stream triggers manipulation interfaces
- Stream triggers row functions
- Stream triggers row variables
- Internal catalogs and views
- Internal system functions
- Column-level conflict functions
- Column-level conflict functions
- bdr_read_all_conflicts
- User visible catalogs and views
- bdr.camo_decision_journal
bdr.camo_decision_journalcolumns- bdr.commit_scopes
bdr.commit_scopescolumns- bdr.conflict_history
bdr.conflict_historycolumns- bdr.conflict_history_summary
bdr.conflict_history_summarycolumns- bdr.consensus_kv_data
bdr.consensus_kv_dataColumns- bdr.crdt_handlers
bdr.crdt_handlersColumns- bdr.ddl_replication
bdr.ddl_replicationcolumns- bdr.depend
- bdr.failover_replication_slots
bdr.failover_replication_slotscolumns- bdr.global_consensus_journal
bdr.global_consensus_journalcolumns- bdr.global_consensus_journal_details
bdr.global_consensus_journal_detailscolumns- bdr.global_consensus_response_journal
bdr.global_consensus_response_journalcolumns- bdr.global_lock
bdr.global_lockcolumns- bdr.global_locks
bdr.global_lockscolumns- bdr.group_camo_details
bdr.group_camo_detailscolumns- bdr.group_raft_details
bdr.group_raft_detailscolumns- bdr.group_replslots_details
bdr.group_replslots_detailscolumns- bdr.group_subscription_summary
bdr.group_subscription_summarycolumns- bdr.group_versions_details
bdr.group_versions_detailscolumns- bdr.leader
bdr.leadercolumns- bdr.local_consensus_snapshot
bdr.local_consensus_snapshotcolumns- bdr.local_consensus_state
bdr.local_consensus_statecolumns- bdr.local_node
bdr.local_nodecolumns- bdr.local_node_summary
- bdr.local_sync_status
bdr.local_sync_statuscolumns- bdr.node
bdr.nodecolumns- bdr.node_catchup_info
bdr.node_catchup_infocolumns- bdr.node_catchup_info_details
- bdr.node_conflict_resolvers
bdr.node_conflict_resolverscolumns- bdr.node_group
bdr.node_groupcolumns- bdr.node_group_replication_sets
bdr.node_group_replication_setscolumns- bdr.node_group_summary
bdr.node_group_summarycolumns- bdr.node_local_info
bdr.node_local_infocolumns- bdr.node_log_config
bdr.node_log_configcolumns- bdr.node_peer_progress
bdr.node_peer_progresscolumns- bdr.node_replication_rates
bdr.node_replication_ratescolumns- bdr.node_slots
bdr.node_slotscolumns- bdr.node_summary
bdr.node_summarycolumns- bdr.parted_origin_catchup_info
bdr.parted_origin_catchup_infocolumns- bdr.parted_origin_catchup_info_details
bdr.parted_origin_catchup_info_detailscolumns- bdr.queue
bdr.queuecolumns- bdr.replication_set
bdr.replication_setcolumns- bdr.replication_set_table
bdr.replication_set_tablecolumns- bdr.replication_set_ddl
bdr.replication_set_ddlColumns- bdr.replication_sets
bdr.replication_setscolumns- bdr.schema_changes
bdr.schema_changescolumns- bdr.sequence_alloc
bdr.sequence_alloccolumns- bdr.sequences
bdr.sequencescolumns- bdr.stat_activity
bdr.stat_activityadditional columns- bdr.stat_commit_scope
bdr.stat_commit_scopecolumns- bdr.stat_commit_scope_state
bdr.stat_commit_scope_statecolumns- bdr.stat_connection_manager
bdr.stat_connection_managercolumns- bdr.stat_connection_manager_connections
bdr.stat_connection_manager_connectionscolumns- bdr.stat_connection_manager_node_stats
bdr.stat_connection_manager_node_statscolumns- bdr.stat_connection_manager_hba_file_rules
bdr.stat_connection_manager_hba_file_rulescolumns- bdr.stat_raft_followers_state
bdr.stat_raft_followers_statecolumns- bdr.stat_raft_state
bdr.stat_raft_statecolumns- bdr.stat_receiver
bdr.stat_receivercolumns- bdr.stat_receiver_transactions
bdr.stat_receiver_transactionscolumns- bdr.stat_relation
bdr.stat_relationcolumns- bdr.stat_routing_candidate_state
bdr.stat_routing_candidate_statecolumns- bdr.stat_routing_state
bdr.stat_routing_statecolumns- bdr.stat_subscription
bdr.stat_subscriptioncolumns- bdr.stat_worker
bdr.stat_workercolumns- bdr.stat_writer
bdr.stat_writercolumns- bdr.subscription
bdr.subscriptioncolumns- bdr.subscription_summary
bdr.subscription_summarycolumns- bdr.tables
bdr.tablescolumns- bdr.taskmgr_work_queue
bdr.taskmgr_work_queuecolumns- bdr.taskmgr_workitem_status
bdr.taskmgr_workitem_statuscolumns- bdr.taskmgr_local_work_queue
bdr.taskmgr_local_work_queuecolumns- bdr.taskmgr_local_workitem_status
bdr.taskmgr_local_workitem_statuscolumns- bdr.trigger
bdr.triggercolumns- bdr.triggers
- bdr.workers
bdr.workersColumns- bdr.writers
bdr.writerscolumns- bdr.worker_tasks
bdr.worker_taskscolumns
- System functions
- Version information functions
- System information functions
- System and progress information parameters
- Node status functions
- Consensus function
- Utility functions
- bdr.wait_slot_confirm_lsn
- Synopsis
- Notes
- Parameters
- bdr.wait_node_confirm_lsn
- Synopsis
- Parameters
- Notes
- 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
- Monitoring functions
- Routing functions
- CAMO functions
- Commit Scope functions
- PGD settings
- Conflict handling
- Global sequence parameters
- DDL handling
- Global locking
- Node management
- Generic replication
- CRDTs
- Commit scope
- Commit At Most Once
- Transaction streaming
- Lag Control
- Monitoring and logging
- Decoding worker
- Connectivity settings
- Topology settings
- Internal settings - Raft timeouts
- Internal settings - Other Raft values
- Internal settings - Other values
- Node management
- Node management interfaces
- 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.drop_node_group
- bdr.join_node_group
- bdr.part_node
- bdr.promote_node
- bdr.switch_node_group
- bdr.sync_node_cancel
- bdr.wait_for_join_completion
- Routing functions
- Commit scopes
- Conflicts
- Conflict functions
- Replication set management
- Replication set membership
- DDL replication filtering
- Testing and tuning commands
- 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
- bdr.galloc_chunk_info
- Synopsis
- Parameters
- Notes
- KSUUID v2 functions
- KSUUID v1 functions
- Sequence functions
- 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
- Internal catalogs and views
- bdr.autopartition_partitions
bdr.autopartition_partitionscolumns- bdr.autopartition_rules
bdr.autopartition_rulescolumns- bdr.ddl_epoch
bdr.ddl_epochcolumns- bdr.event_history
bdr.event_historycolumns- bdr.event_summary
- bdr.local_leader_change
- bdr.node_config
bdr.node_configcolumns- bdr.node_config_summary
bdr.node_config_summarycolumns- bdr.node_group_config
bdr.node_group_configcolumns- bdr.node_group_routing_config_summary
bdr.node_group_routing_config_summarycolumns- bdr.node_group_routing_info
bdr.node_group_routing_infocolumns- bdr.node_group_routing_summary
bdr.node_group_routing_summarycolumns- bdr.node_routing_config_summary
bdr.node_routing_config_summarycolumns- bdr.sequence_kind
bdr.sequence_kindcolumns- bdr.sync_node_requests
bdr.sync_node_requestscolumns- bdr.sync_node_requests_summary
bdr.sync_node_requests_summarycolumns
- 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
- 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_currval
- bdr.seq_lastval
- bdr.seq_nextval
- bdr.show_subscription_status
- bdr.show_workers
- Synopsis
- bdr.show_writers
- bdr.sync_status_name
- Synopsis
- Parameters
- Task manager functions
- bdr.taskmgr_set_leader
- Synopsis
- bdr.taskmgr_get_last_completed_workitem
- Synopsis
- bdr.taskmgr_work_queue_check_status
- Synopsis
- Parameters
- Notes
- bdr.get_min_required_replication_slots
- bdr.get_min_required_worker_processes
- bdr.stat_get_activity
- bdr.worker_role_id_name
- bdr.lag_history
- bdr.get_raft_instance_by_nodegroup
- bdr.monitor_camo_on_all_nodes
- bdr.monitor_raft_details_on_all_nodes
bdr.monitor_replslots_details_on_all_nodes- bdr.monitor_subscription_details_on_all_nodes
- bdr.monitor_version_details_on_all_nodes
- bdr.node_group_member_info
- General internal functions
- Column-level conflict functions
- User visible catalogs and views
- EDB Postgres Distributed Command Line Interface (PGD CLI)