PGD Reference¶
The reference section is a definitive listing of all functions, views and commands available in EDB Postgres Distributed.
:ref:``bdr.truncate_locking` <bdr.truncate_locking>`
:ref:``bdr.global_lock_idle_timeout` <bdr.global_lock_idle_timeout>`
:ref:``bdr.predictive_checks` <bdr.predictive_checks>`
:ref:``bdr.xact_replication` <bdr.xact_replication>`
:ref:``bdr.accept_connections` <bdr.accept_connections>`
:ref:``bdr.crdt_raw_value` <bdr.crdt_raw_value>`
:ref:``bdr.camo_enable_client_warnings` <bdr.camo_enable_client_warnings>`
:ref:``bdr.lag_control_max_lag_size` <bdr.lag_control_max_lag_size>`
:ref:``bdr.trace_level` <bdr.trace_level>`
:ref:``bdr.autopartition_disable` <bdr.autopartition_disable>`
Stream Triggers Reference¶
- 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.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.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_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.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_relation
bdr.stat_relationcolumns- bdr.stat_subscription
bdr.stat_subscriptioncolumns- 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
- Consensus function
- 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.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
- PGD settings
- Conflict handling
- Global sequence parameters
- DDL handling
- Global locking
- Node management
- 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
- Eager Replication
- Commit At Most Once
- Transaction streaming
- Lag Control
- Timestamp-based snapshots
- Monitoring and logging
- Decoding Worker
- Connectivity settings
- Internal settings
- Node management
- Node management interfaces
- bdr.create_node
- bdr.drop_node
- bdr.create_node_group
- bdr.alter_node_group_config
- bdr.join_node_group
- bdr.switch_node_group
- bdr.promote_node
- bdr.wait_for_join_completion
- bdr.part_node
- bdr.alter_node_interface
- bdr.alter_subscription_enable
- bdr.alter_subscription_disable
- bdr.alter_node_group_option
- bdr.alter_node_option
- Routing functions
- Replication set management
- Replication set membership
- DDL replication filtering
- 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
- 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.ddl_epoch
bdr.ddl_epochcolumns- bdr.event_history
bdr.event_historycolumns- bdr.event_summary
- bdr.node_config
bdr.node_configcolumns- bdr.node_group_config
bdr.node_group_configcolumns- bdr.node_group_routing_config_summary
- bdr.node_group_routing_info
bdr.node_group_routing_infocolumns- bdr.node_group_routing_summary
- bdr.node_routing_config_summary
- bdr.proxy_config
bdr.proxy_configcolumns- bdr.proxy_config_summary
- bdr.sequence_kind
bdr.sequence_kindcolumns
- Internal system functions
- General internal functions
- bdr.decode_message_response_payload
- bdr.decode_message_payload
- bdr.get_global_locks
- 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.peer_state_name
- bdr.request_replay_progress_update
- bdr.seq_nextval
- Notes
- bdr.show_subscription_status
- bdr.get_node_conflict_resolvers
- bdr.reset_subscription_stats
- bdr.reset_relation_stats
- bdr.pg_xact_origin
- Synopsis
- Parameters
- bdr.difference_fix_origin_create
- bdr.difference_fix_session_setup
- Synopsis
- bdr.difference_fix_session_reset
- Synopsis
- bdr.difference_fix_xact_set_avoid_conflict
- Synopsis
- bdr.resynchronize_table_from_node
- Synopsis
- Parameters
- Notes
- bdr.consensus_kv_store
- Synopsis
- Parameters
- Notes
- bdr.consensus_kv_fetch
- Synopsis
- Parameters
- Notes
- 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.node_catchup_state_name
- Synopsis
- Parameters
- bdr.bdr_track_commit_decision
- Synopsis
- bdr.bdr_get_commit_decisions
- Synopsis
- bdr.show_workers
- Synopsis
- bdr.show_writers
- bdr.node_kind_name
- General internal functions
