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
  • Andrey Hitrin
    Andrey Hitrin RedSys
    Alexander Fedorov
    Alexander Fedorov dbeaver.com

    DBeaver is the Universal Databases Manager. We creating DBeaver using Open Source Software model. We pay special attention to the PotgreSQL because of its capabilities, popularity and OSS nature. We will talk about DBeaver evolution and structure, will demonstrate the basic functionality. We are going to cover challenges of PostgreSQL client creation. Also we will discuss requirements management model and interaction with the PostgreSQL community. We will show in details how to debug the PL/pgSQL stored procedures interactively. We are going to introduce some new features of the nearest DBeaver release and to share our plans.

  • Игорь Успенский
    Игорь Успенский Rambler&Co

    Rambler & Co is a lot of publications, services and projects. Appear new and grow existing. This environment requires a reliable, fault-tolerant, scalable, automated system.

    I'll tell you about the structure of our PostgreSQL SaaS, what tools and technologies we use. Quorum of 3 Data Centers. A single entry point for clients based on dynamic routing. Emergency switching of the primary server. Transparent scaling for reading. Create a replica without load on the cluster. Transparent transfer of PostgreSQL cluster to other servers. Update dev environment from prod for development. Backup with compression and the use of multiple CPUs on the side of the database, the restoration of one database from basebackup. Monitoring of sql queries.

  • Максим Милютин
    Максим Милютин Wildberries
    Dmitry Ivanov
    Dmitry Ivanov PostgresPro
  • Alex Lustin
    Alex Lustin SilverBulleters, LLC

    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

All talks

Partners

PGConf.Russia 2018

Silver

Organizational

Informational

Partner