max_wal_senders (integer) ; max_replication_slots (integer) ; wal_keep_size (integer) ; max_slot_wal_keep_size (integer) ; wal_sender_timeout (integer) ; Record commit time of transactions. This parameter can only be set in postgresql.conf file or on the server command line. The default value is off. synchronized_standby_slots (string)
Replication 타입 Postgresql(포스트그레스)에서는 다양한 Replication 구성 전략을 제공합니다.... synchronous_commit synchronous_commit 옵션은 Logical 또는 Physical Replication에 적용할 수 있는 옵션입니다....
Continuous archiving can be used to create a high availability (HA) cluster configuration with one or more standby servers ready to take over operations if the primary server fails. This capability is widely referred to as warm standby or log shipping. The primary and standby server work together to provide this capability, though the servers are only loosely coupled. The primary server operates in continuous archiving mode, while each standby server operates in continuous recovery mode, reading...
19.5.1. Settings · 19.5.2. Checkpoints · 19.5.3. Archiving · 19.5.4. Recovery · 19.5.5. Archive Recovery · 19.5.6. Recovery Target · 19.5.7. WAL Summarization
Database servers can work together to allow a second server to take over quickly if the primary server fails (high availability), or to allow several computers to serve the same data (load balancing). Ideally, database servers could work together seamlessly. Web servers serving static web pages can be combined quite easily by merely load-balancing web requests to multiple machines. In fact, read-only database servers can be combined relatively easily too. Unfortunately, most database servers hav...
Shared Disk Failover ; File System (Block Device) Replication ; Write-Ahead Log Shipping ; Logical Replication ; Trigger-Based Primary-Standby Replication ; SQL-Based Replication Middleware ; Asynchronous Multimaster Replication ; Synchronous Multimaster Replication
E.24.1. Overview ; Logical replication using publish/subscribe · Declarative table partitioning · Improved query parallelism · Significant general performance improvements · Stronger password authentication based on SCRAM-SHA-256 · Improved monitoring and control
Two new options have been added to PostgreSQL's synchronous replication feature which allow it to be used to maintain consistent reads across database clusters. First, it now allows...
동기식 스트리밍 리플리케이션(Synchronous streaming replication)은 PostgreSQL 9.1 버전부터 구현되었습니다.
PostgreSQL 은 다양한 방법으로 replication 을 구성하는 방법들을 제시한다. 아래의 내용은 공식 Doc 및 기타 사이트에서 발췌한 Replication 구성 방법 종류다. (출처 : https://www.postgresql.org/docs/9.6/different-replication-solutions.html) (출처 : https:...