..................................................................................648 25. High Availability, Load Balancing, and Replication........................................................... ................................................................661 25.2.8.3. Planning for High Availability ...........................................................661 25.2.9. Continuous archiving their types: CREATE TABLE weather ( city varchar(80), temp_lo int, -- low temperature temp_hi int, -- high temperature prcp real, -- precipitation date date ); You can enter this into psql with the line breaks

..................................................................................613 25. High Availability, Load Balancing, and Replication.........................................................615 Performance............................................................625 25.2.8.3. Planning for High Availability ....................................................626 xiv 25.2.9. Continuous archiving in their types: CREATE TABLE weather ( city varchar(80), temp_lo int, -- low temperature temp_hi int, -- high temperature prcp real, -- precipitation date date ); You can enter this into psql with the line breaks

replicas – or use pgpool-II • Adds more complexity and an extra hop though • But can help with availability Postgres Conference China 2016 中国用户大会 PostgreSQL 9.6 Parallel Query • New in 9.6: Parallel Postgres-XL Postgres Conference China 2016 中国用户大会 Postgres-XL Missing Features • Built-in High Availability • Use external like Corosync/Pacemaker • Area for future improvement • “Easy” to re-shard analytical platform – Distributed Foreign Data Wrappers • Columnar compressed FDW • SQL on HDFS • High Availability • Elasticity – Break 1-1 mapping of shard to node Postgres Conference China 2016 中国用户大会 Postgres

..................................................................................624 25. High Availability, Load Balancing, and Replication........................................................... ................................................................637 25.2.8.3. Planning for High Availability ...........................................................637 25.3. Failover............. their types: CREATE TABLE weather ( city varchar(80), temp_lo int, -- low temperature temp_hi int, -- high temperature prcp real, -- precipitation date date ); You can enter this into psql with the line breaks

Continuous Archiving and Point-in-Time Recovery (PITR) ............................. 664 26. High Availability, Load Balancing, and Replication .................................................. 676 26.1 Conversions ...................................................................... 646 26.1. High Availability, Load Balancing, and Replication Feature Matrix .................................. 678 28.1 Language temp_lo int, -- low temperature temp_hi int, -- high temperature prcp real, -- precipitation date date ); You can

Continuous Archiving and Point-in-Time Recovery (PITR) ............................. 741 26. High Availability, Load Balancing, and Replication .................................................. 754 26.1 Conversions ........................................................................ 722 26.1. High Availability, Load Balancing, and Replication Feature Matrix .................................. 756 27.1 varchar(80), temp_lo int, -- low temperature temp_hi int, -- high temperature prcp real, -- precipitation date date ); You can

..................................................................................589 25. High Availability, Load Balancing, and Replication.........................................................591 Performance............................................................601 25.2.8.3. Planning for High Availability ....................................................602 25.3. Failover.................... their types: CREATE TABLE weather ( city varchar(80), temp_lo int, -- low temperature temp_hi int, -- high temperature prcp real, -- precipitation date date ); You can enter this into psql with the line breaks

3. Continuous Archiving and Point-in-Time Recovery (PITR) ........................ 632 26. High Availability, Load Balancing, and Replication ............................................ 643 26.1. Comparison Set Conversions ................................................................ 615 26.1. High Availability, Load Balancing, and Replication Feature Matrix ............................. 645 28.1. Dynamic varchar(80), temp_lo int, -- low temperature temp_hi int, -- high temperature prcp real, -- precipitation date date 7 The SQL

3. Continuous Archiving and Point-in-Time Recovery (PITR) ........................ 703 26. High Availability, Load Balancing, and Replication ............................................ 715 26.1. Comparison Set Conversions .................................................................. 684 26.1. High Availability, Load Balancing, and Replication Feature Matrix ............................. 717 27.1. Dynamic varchar(80), temp_lo int, -- low temperature temp_hi int, -- high temperature prcp real, -- precipitation date date ); You can

..................................................................................681 26. High Availability, Load Balancing, and Replication........................................................... ................................................................693 26.2.8.4. Planning for High Availability ...........................................................694 26.2.9. Continuous archiving their types: CREATE TABLE weather ( city varchar(80), temp_lo int, -- low temperature temp_hi int, -- high temperature prcp real, -- precipitation date date ); You can enter this into psql with the line breaks