PgConf.Russia 2017 talks

Troubleshooting PostgreSQL Streaming Replication

Alexey Lesovsky
Data Egret, PostgreSQL DBA

Alexey Lesovsky is a PostgreSQL DBA and Linux system administrator at the PostgreSQL consultancy company. He has over ten years of experience working in Linux administration and KVM virtualization. Last five years he works with RDBMS and particularly PostgreSQL. He has huge experience in troubleshooting, monitoring and Postgres internals. He every day works with PostgreSQL resolving issues that users are faced with on daily basis. In his spare time Alexey does C programming and creates Ansible playbooks.

Streaming replication has been introduced in 2010 and quickly became one of the most popular features of PostgreSQL. Today, it is hard to imagine PostgreSQL installation without streaming replication. With its stability, high efficiency and ease of configuration one would have thought it is an optimal feature. However, while using it you might sometimes enter murky waters. This often can be resolved by using a combination of built-in and third party troubleshooting tools. In my talk I will provide an overview of these tools and explain how with their help one can diagnose, understand and eliminate problems related to streaming replication. I will also go through the most frequent issues occurring when streaming replication is used and will propose possible solutions. This talk is primarily aimed at DBAs and system administrators who use PostgreSQL in their day-to-day.