PGConf.Russia 2018

Lomonosov Moscow State University, Moscow, Russia

Talks
Photo

PGConf.Russia 2018

PGConf.Russia is a leading Russian PostgreSQL international conference, annually taking together more than 500 PostgreSQL professionals from Russia and other countries — core and software developers, DBAs and IT-managers. The 3-day program includes training workshops presented by leading PostgreSQL experts, more than 40 talks, panel discussions and a lightning talk session.

Thems

PostgreSQL at the cutting edge of technology: big data, internet of things, blockchain
New features in PostgreSQL and around: PostgreSQL ecosystem development
PostgreSQL in business software applications: system architecture, migration issues and operating experience
Integration of PostgreSQL to 1C, GIS and other software application systems.

more than
0 participants
0 speakers
0
minutes of conversation
54 talks
offline
format

Dmitry Cremer Federal State Unitary Enterprise Rossiya Segodnya
Cases for monitoring & troubleshooting at highload PosgreSQL DB

A database is one of the key components in any information system, requiring the monitoring of multiple metrics. The talk highlights examples and approaches of monitoring and analysis of PostgreSQL performance that allow to minimize the load on the database server from the monitoring and data collection system for the subsequent analysis of problem situations.
- Quantum effects or as an observer affect the observed system
- Features of collecting metrics while monitoring the database with Zabbix
- Data collection for analytics and visualization PostgreSQL queries with rsyslog + kafka + clickhouse + grafana
- Operational Analysis Tools for DB loglile
Presentation materials
Vadim Yatsenko

Sergei Kim Ingram Micro Cloud

PostgreSQL High Availability cluster for Enterprise

Lately, the PostgreSQL is more widely being used for Enterprise. Our company, Ingram Micro Cloud, is one of the first companies that did it. We have been using PostgreSQL for many years as the main DBMS for our products. In our report, we want to tell about the evolution of our High Availability (HA) PostgreSQL cluster. We will tell about how quickly we implemented the solution using pgpool-II, wrote failover scripts, tested Postgres-XL, and came up with unusual configurations of Stolon. We will also cover the problems of load balancing, pooling connections, and backups.

Presentation materials
Dmitry Belyavskiy Technical Center of Internet

Crypto-related parameters of PostgreSQL

The presentation describes crypto-related parameters of PostgreSQL configuration (both authentication and TLS-protection of the connection to DB) and what do they mean

Presentation materials
Alex Lustin SilverBulleters, LLC
Docker, PostgreSQL, Production ....

I would like to share experience in runing PostgreSQL in dockerized environments, describe the specific issues and tools you will need to solve them.
- Which problems could be solved by Docker for PostgreSQL, e.g. PostgreSQLPro.9.6
- Work of IT team with Docker in development, testing and production environments
  - Using image repository and build servers for image testing
- Issues in production environment:
  - With network activity
  - With persistent repositories for Docker
  - With additional services
  - With load balancing and fail-safety
- Running PostgreSQL-base applications, such as:
  - SonarQube
  - Gitlab
  - 1С platform
Presentation materials