⚫ 多种规格、满足不同场景需求 -交互式分析 -ETL数据清洗 增强的企业级特性-安全  -数据的备份&恢复  -SQL访问安全审计 增强的企业级特性-高可用  -Master HA切换  -故障自动恢复  -监控服务 云管控高可用 1. 阿里云分析型数据库产品介绍 2. AnalyticDB for PostgreSQL 典型场景 3. AnalyticDB for

25.2. Log-Shipping Standby Servers 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 This does not provide any worthwhile improvement in server robustness, nor would it be described as HA. 25.4.2. Record-based Log Shipping It is also possible to implement record-based log shipping using Linnakangas) • Make pg_dump exclude data of unlogged tables when running on a hot-standby server (Magnus Ha- gander) This would fail anyway because the data is not available on the standby server, so it seems

25.2. Log-Shipping Standby Servers 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 This does not provide any worthwhile improvement in server robustness, nor would it be described as HA. 25.4.2. Record-based Log Shipping It is also possible to implement record-based log shipping using Linnakangas) • Make pg_dump exclude data of unlogged tables when running on a hot-standby server (Magnus Ha- gander) This would fail anyway because the data is not available on the standby server, so it seems

25.2. Log-Shipping Standby Servers 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 This does not provide any worthwhile improvement in server robustness, nor would it be described as HA. 569 Chapter 25. High Availability, Load Balancing, and Replication 25.4.2. Record-based Log Shipping Linnakangas) • Make pg_dump exclude data of unlogged tables when running on a hot-standby server (Magnus Ha- gander) This would fail anyway because the data is not available on the standby server, so it seems

Standby Servers for High Availability 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 take considerably longer, so that technique only really offers a solution for disaster recovery, not HA. 23.4.1. Planning It is usually wise to create the primary and standby servers so that they are as This does not provide any worthwhile improvement in server robustness, nor would it be described as HA. 23.4.3. Failover If the primary server fails then the standby server should begin failover procedures

Standby Servers for High Availability 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 take considerably longer, so that technique only really offers a solution for disaster recovery, not HA. 23.4.1. Planning It is usually wise to create the primary and standby servers so that they are as This does not provide any worthwhile improvement in server robustness, nor would it be described as HA. 23.4.3. Failover If the primary server fails then the standby server should begin failover procedures

25.2. Log-Shipping Standby Servers 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 This does not provide any worthwhile improvement in server robustness, nor would it be described as HA. 577 Chapter 25. High Availability, Load Balancing, and Replication 25.4.2. Record-based Log Shipping constructor functions. • In pg_xlogdump, retry opening new WAL segments when using --follow option (Magnus Ha- gander) This allows for a possible delay in the server’s creation of the next segment. • Fix pg_xlogdump

25.2. Log-Shipping Standby Servers 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 This does not provide any worthwhile improvement in server robustness, nor would it be described as HA. 25.4.2. Record-based Log Shipping It is also possible to implement record-based log shipping using Chernikov) • Retry after receiving an invalid response packet from a RADIUS authentication server (Magnus Ha- gander) This fixes a low-risk potential denial of service condition. • Fix missed unlink of temporary

25.2. Log-Shipping Standby Servers 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 This does not provide any worthwhile improvement in server robustness, nor would it be described as HA. 604 Chapter 25. High Availability, Load Balancing, and Replication 25.4.2. Record-based Log Shipping constructor functions. • In pg_xlogdump, retry opening new WAL segments when using --follow option (Magnus Ha- gander) This allows for a possible delay in the server’s creation of the next segment. • Fix pg_xlogdump

25.2. Log-Shipping Standby Servers 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 This does not provide any worthwhile improvement in server robustness, nor would it be described as HA. 25.4.2. Record-based Log Shipping It is also possible to implement record-based log shipping using for some reason. • In pg_xlogdump, retry opening new WAL segments when using --follow option (Magnus Ha- gander) This allows for a possible delay in the server’s creation of the next segment. • Fix pg_xlogdump