title

text

February 05 – 07 , 2018

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

Talks

Talks archive

PGConf.Russia 2018
  • Dmitry Belyavskiy
    Dmitry Belyavskiy Technical Center of Internet

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

  • Alexey Klyukin
    Alexey Klyukin Zalando SE
    Alexander Kukushkin
    Alexander Kukushkin Zalando SE

    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.

  • Oleg Bartunov
    Oleg Bartunov PostgresPro
    Teodor Sigaev
    Teodor Sigaev PostgresPro
    Alexander Korotkov
    Alexander Korotkov PostgresPro
  • Alexey Lesovsky
    Alexey Lesovsky Data Egret

    When one faces the issues with PostgreSQL, the main suspicion falls on vacuum. Experience of Data Egret team proves how many DBAs are attacking this rake. While there are tons of information, documentation and discussions on vacuum itself, the topic is still associated with a lot of myths, tales, horror stories and misconceptions. In my talk I will try to reveal the key points concerning the inner structure of vacuum, basic approaches to its adjustment and tuning, performance monitoring, and so on.

All talks

Partners

PGConf.Russia 2018

Silver

Organizational

Informational

Partner