PostgreSQL High Availability with Corosync/Pacemaker
The Corosync/Pacemaker framework which is part of the LinuxHA stack can be used to provide monitoring and automatic failover capabilities. Now with streaming replication in place, it makes sense to use this robust infrastructure for PostgreSQL master and its replica handling. The open source pgsql resource agent also does this now. This talk will talk about using Corosync/Pacemaker with Postgres.
Видео доступно только участникам мероприятия, выполнившим вход в личный кабинет
In this session, we will go through the most important additions since the widely known SQL-92, explain how they work and how PostgreSQL supports and extends them. We will cover common table expressions and window functions in detail and have a very short look at the temporal features of SQL:2011 and the related features of PostgreSQL.
Мониторинг, миграция, бэкапы...
Опыт использования PL Proxy для масштабирования СУБД