February 05 – 07 | Lomonosov Moscow State University, Moscow, Russia

PGConf.Russia 2018

What is PGConf.Russia 2018?

About

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.

i

When and Where

February 05 – 07, 2019
Lomonosov Moscow State University,
Faculty of Economics, Moscow, Russia, 1-46 Leninskiye Gory

>500
participants

>50
talks

1440
minutes of networking

Selected talks

Dmitriy Sarafannikov

Yandex

Software developer

Talk

How to save statistics during major update, and what can be the consequences

It's not a secret for anyone that statistics can not be transferred with a major upgrade. For small and not heavily loaded databases this is not a problem, you can quickly collect new statistics. But we have databases with a volume of about 5TB and a load of about 100k rps, for which it became a big problem: taking off without statistics, the replicas could not even replay WAL. In my report I'll tell you what tricks we went to upgrade these databases with requirements of 100% read only availability, about what mistakes were made, and about how these errors were painfully corrected. The result of these errors was the extension called "pg_dirty_hands", in which we will collect various hacks, which can be last resort to repair data corruption.

Slides

Bruce Momjian

EnterpriseDB

Senior Database Architect

Talk

Securing PostgreSQL From External Attack

This talk explores the ways attackers with no authorized database access can steal Postgres passwords, see database queries and results, and even intercept database sessions and return false data. Postgres supports features to eliminate all of these threats, but administrators must understand the attack vulnerabilities to protect against them. This talk covers all known Postgres external attack methods.

Slides

Program All talks

Recall the event

Conference Organizer
Postgres Professional

Main partners

Lomonosov Moscow State University

Economics Department of Moscow State University

National center for Digital Economy

Silver partners

Partners

Media partners

Get our latest news!
Subscribe to our news

Feedback

Conferences like this give people a personal feeling for the software. You can understand why people are passioned about it. They get confidence in using it and confidence that the software is gonna be around for a long time. The conference has people who is responsible for and designing Postgres. And I really think it excites to continue using Postgres.

Bruce Momjian

Enterprise DB Senior Database Architect
This is a very technically oriented conference. There is a lot of knowledge sharing happening. A lot of really talented people. And it is also for us a great opportunity to tap into the Russian market, a very interesting market for Postgres.

Alvaro Hernandez

OnGres CEO

Pluggable storages

PGConf.Russia 2018

What is PGConf.Russia 2018?

About

When and Where