Skip to main content
Ctrl+K
EDB Postgres Distributed 5.5.0 ドキュメント - Home
  • Compatibility
  • EDB Postgres Distributed release notes
    • EDB Postgres Distributed 5.5.0 release notes
    • EDB Postgres Distributed 5.4.1 release notes
    • EDB Postgres Distributed 5.4.0 release notes
    • EDB Postgres Distributed 5.3.0 release notes
    • EDB Postgres Distributed 5.2.0 release notes
    • EDB Postgres Distributed 5.1.0 release notes
    • EDB Postgres Distributed 5.0.1 release notes
    • EDB Postgres Distributed 5.0.0 release notes
  • Known issues
  • Concepts
    • Terminology
    • PGD overview
  • Introducing PGD quick starts
    • Deploying an EDB Postgres Distributed example cluster on Docker
    • Deploying an EDB Postgres Distributed example cluster on Linux hosts
    • Deploying an EDB Postgres Distributed example cluster on AWS
    • Deploying an EDB Postgres Distributed example cluster on Azure and Google cloud platforms
    • Connecting to your database
    • Exploring failover handling with PGD
    • Exploring conflict handling with PGD
    • Next steps with PGD
  • Planning your PGD deployment
    • Choosing your architecture
    • Choosing a Postgres distribution
    • Choosing your deployment method
    • Other considerations
    • Limitations
  • Manual deployment and configuration of PGD
    • Deploying PGD manually
      • Step 1 - Provisioning hosts
      • Step 2 - Installing Postgres
      • Step 3 - Configuring PGD repositories
      • Step 5 - Creating the PGD cluster
      • Step 4 - Installing the PGD software
      • Step 6 - Checking the cluster
      • Step 7 - Configure proxies
      • Step 8 - Using PGD CLI
  • Deployment and management with TPA
    • Deploying PGD using TPA
      • Configuring a PGD cluster with TPA
      • Provisioning, deploying, and testing
  • Deploying and configuring PGD on Kubernetes
  • Deploying and configuring PGD on EDB BigAnimal
  • Application use
    • Application behavior
    • Nodes with differences
    • General rules for applications
    • Timing considerations and synchronous replication
    • Use of table access methods (TAMs) in PGD
    • Feature compatibility
  • DDL replication
    • DDL overview
    • DDL replication options
    • DDL locking details
    • Managing DDL with PGD replication
    • DDL command handling matrix
    • DDL and role manipulation statements
    • Workarounds for DDL restrictions
    • PGD functions that behave like DDL
  • Sequences
  • Node management
    • Node types
    • Groups and subgroups
    • Creating and joining PGD groups
    • Witness nodes
    • Logical standby nodes
    • Subscriber-only nodes and groups
    • Viewing PGD topology
    • Removing nodes and groups
    • Joining a heterogeneous cluster
    • Connection DSNs and SSL (TLS)
    • Decoding worker
    • Replication slots created by PGD
    • Node restart and down node recovery
  • Postgres configuration
  • PGD Proxy
    • EDB Postgres Distributed Proxy overview
    • Installing PGD Proxy
    • PGD Proxy configuration
    • Administering PGD Proxy
    • Monitoring PGD Proxy
    • Read-only routing with PGD Proxy
    • Proxies, Raft, and Raft subgroups
      • Creating Raft subgroups using TPA
      • Working with Raft subgroups and PGD CLI
      • Migrating to Raft subgroups
      • Raft elections in depth
  • Backup and recovery
  • Security and roles
    • Roles
    • Role management
    • PGD predefined roles
    • Roles and replication
    • Access control
  • Monitoring
    • OpenTelemetry integration
    • Monitoring through SQL
  • Testing and tuning PGD clusters
  • Upgrading
    • Upgrading PGD clusters with TPA
    • Upgrading PGD clusters manually
    • Supported PGD upgrade paths
    • Compatibility changes
    • In-place Postgres major version upgrades
    • Application schema upgrades
  • EDB Postgres Distributed Command Line Interface (PGD CLI)
    • Installing PGD CLI
      • Installing PGD CLI on Linux
      • Installing PGD CLI on macOS
      • Installing PGD CLI with TPA
    • Using PGD CLI
    • Configuring PGD CLI
    • Discovering connection strings
    • Command reference
      • check-health
      • create-proxy
      • delete-proxy
      • set-group-options
      • set-node-options
      • set-proxy-options
      • show-clockskew
      • show-events
      • show-groups
      • show-nodes
      • show-proxies
      • show-raft
      • show-replslots
      • show-subscriptions
      • show-version
      • switchover
      • verify-cluster
      • verify-settings
  • Durability
    • An overview of durability options
    • Durability terminology
    • Commit scopes
    • Commit scope rules
    • Comparing durability options
    • Group Commit
    • Commit At Most Once
    • Lag Control
    • PGD Synchronous Commit
    • Administering
    • Legacy synchronous replication using PGD
    • Limitations
  • Consistency
    • Conflicts
    • Column-level conflict detection
    • Conflict-free replicated data types
    • Eager conflict resolution
  • Parallel Apply
  • Replication sets
  • Stream triggers
  • PGD AutoPartition
  • Explicit two-phase commit (2PC)
  • Transaction streaming
  • Timestamp-based snapshots
  • PGD reference
    • 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
  • .rst

  • Application use
    • Application behavior
      • レプリケーション動作
      • Truncate
      • 行レベルのロック
      • シークエンス
      • バイナリオブジェクト
      • ルール
      • ベーステーブルのみ
      • パーティション化されたテーブル
      • トリガー
      • トースト
      • その他の制限
    • Nodes with differences
      • 差分を含むノード間のレプリケーション
      • 違いがあるノード間の比較
      • 異なるリリースレベル間のレプリケーション
    • General rules for applications
      • 背景
      • アプリケーションのルール
    • Timing considerations and synchronous replication
    • Use of table access methods (TAMs) in PGD
    • Feature compatibility
      • サーバー機能/コミットスコープの相互運用性
      • コミットスコープ/コミットスコープの相互運用性
  • DDL replication
    • DDL overview
      • レプリケートDDL
      • PostgreSQLとの違い
      • PGDシステムでのDDLの実行
    • DDL replication options
    • DDL locking details
      • グローバルDDLロック
      • グローバルDMLロック
    • Managing DDL with PGD replication
      • DDLのインパクトの最小化
      • ダウンしたノードでのDDLの処理
      • ステートメント固有のDDLレプリケーションの問題
    • DDL command handling matrix
      • コマンドマトリックス
      • コマンドの注意事項
    • DDL and role manipulation statements
    • Workarounds for DDL restrictions
      • コンストレインの追加
      • 列の追加
      • カラムのタイプの変更
    • PGD functions that behave like DDL
  • Sequences
    • PGDグローバルシーケンス
      • SnowflakeIdシーケンス
      • タイムシャードシーケンス
      • グローバルに割り当てられたレンジシーケンス
      • ローカルシーケンスのgallocシーケンスへの変換
    • UUID、KSUUID、およびその他のアプローチ
      • UUID
      • KSUUID
      • ステップシーケンスとオフセットシーケンス
      • 複合キー
    • 関連項目

前へ

Deploying and configuring PGD on EDB BigAnimal

次へ

Application use

著者 EnterpriseDB Corporation.

© Copyright EnterpriseDB Corporation..