Major upgrade for PostgreSQL
In this master class, I will take you step-by step through a major upgrade of PostgreSQL. Through our practice we see a lot of different PostgreSQL servers in production environment and often, almost too often teams who once made PostgreSQL their database of choice never update it following the initial installation. The are many different reasons for it, the result, however, is the same - they all miss out on the new useful features of the newer releases and reduced database performance.
The goal of my masterclass is to equip attendees with necessary tools for performing PostgreSQL upgrade. I will take you through each step of the major upgrade and will dive into each executed command. I will also explain the particular order in which I perform an upgrade and explain the consequences of not following this order or missing a particular step. We will perform an upgrade of PostgreSQL 9.0 to 11. My hope is that following this masterclass number of outdated PostgreSQL database will reduce since participants will then go back to their databases and make sure that they are running the most recent version.
Darafei Praliaskouski Juno
PostGIS is spatial extension for PostgreSQL.
This talk will go in depth on using PostGIS for disaster management: which functions can be used and for what.
Dmitry Belyavskiy ТЦИTeodor Sigaev Postgres Professional
At the end of 2018, I've got a request to extend the syntax of the ltree contrib. I'm finalizing the patch and going to speak about:
- the current state of the extension,
- the extended syntax, and
- the process of development and testing the extension.
Ivan Frolkov Postgres Professional
Software applications working on PostgreSQL is a very typical case in my practice. Some of them manage to work well, some of them do not. In the talk I will focus on errors and problems of the last ones.
Sergey Andreev ООО "Ортикон-Групп"
Several real cases from those who stopped the migration to PostgreSQL.