PgConf.Russia 2019

Talks
Photo

PgConf.Russia 2019

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
63 talks
offline
format

Joshua Drake Command Prompt, Inc.

The Power of Logical Replication

One of the most soft after features of Postgres v10 is logical replication. In this presentation we will cover what Logical Replication is, how it compares to Binary (Streaming Replication), how Logical Replication works, configuring Logical Replication, Logical Replication limitations, gotchas, security and management. We will also discuss potential deployed architectures with Logical and Binary Replication and some neat features of the underlying technology.

At the end of this presentation an attendee with a reasonable understanding of how to manage Postgres will be able to configure Logical replication for use.

Presentation materials
Sergey Andreev Ortikon Group

What stops the transition on PostgreSQL and how to overcome it

Several real cases from those who stopped the migration to PostgreSQL.

Presentation materials
Joshua Drake Command Prompt, Inc.

Practical Postgres Replication

In this tutorial we will discuss Binary and Logical replication in a practitioner format. The topics that will be included are native Postgres replication technologies, configuring and managing them. We will also discuss performance and draw backs of various architectures (sync vs async etc...). At the end of this presentation the attendees will be able to configure a basic replication deployment with HOT Standby and well as have an understanding of other technologies such as Point in Time Recovery and cascading replication.
Aleksander Sheludchenkov GK "Mitra"
Non-standard 1C cluster
- Migration of the standard 1C cluster to MPI environment - "machine to machine migration of services".
- PostgreSQL migration to GPU powered machine.
Presentation materials