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

Alexey Klyukin Zalando SE

Alexander Kukushkin Zalando SE
Tutorial: Management of High-Availability PostgreSQL clusters with Patroni

Patroni is a Python application to create high-availability PostgreSQL clusters based on the streaming replication. It is used by Red Hat, IBM Compose, Zalando and many other companies. This tutorial will highlight Patroni architecture, provide attendees with hands-on experience of configuring high-availability PostgreSQL clusters with Patroni, describe how to take advantage of numerous additional features and give an opportunity to learn more about common mistakes related to running Patroni and its troubleshooting.

In order to take most out of the Patroni tutorial one needs a laptop with git, vagrant and virtual box installed.
Vagrant can be obtained from https://www.vagrantup.com Virtualbox is at https://www.vagrantup.com
Alternatively, one can install your Linux distribution packages (or use homebrew on Mac).
Once Vagrant and Virtualbox are installed one can run the Patroni VM by issuing the following commands:
```
$ git clone https://github.com/alexeyklyukin/patroni-training
$ cd patroni-training
$ vagrant up
```
When the setup concludes Patroni box can be accessed via ssh using vagrant ssh command.
Presentation materials
Максим Милютин Wildberries

Dmitry Ivanov PostgresPro

Vanilla and external partitioning in PostgreSQL

Presentation materials
Alexander Pogodin Corporation PARUS

Alexander Pankratov SPC Parus

Migration Technology of client-server applcations from Oracle to PostgreSQL: Principles, approaches and features.

The report reviews approaches and implementattion options for the migration of Parus-Budget 8 client-server application from the Oracle Database platform to the PostgreSQL platform without changing the client application for Desktop and the Web. The proposed solution allows to make transparent transition of the existing users' workplaces.

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