Сертификация PostgreSQL: вопросы и ответы
In May 2019 «Postgres Professional» launched the PostgreSQL Certification Program. Now you can not only get training in our courses, but also confirm your knowledge by passing an appropriate set of tests.
In this presentation, I will share the results of the first months of the program and answer the most frequently asked questions:
Where can I get information about the certification program?
PostgreSQL or Postgres Pro certification?
Certificates for PostgreSQL version 10. When will you upgrade to the current version?
Do I have to attend training centers?
Can I pass the test remotely? Not in Moscow?
Is it possible to take several tests at once in one day?
How to prepare for the test? Are there any examples of training questions?
During the test I got an incorrect question, what should I do?
How to find out exactly which questions the answers were not correct?
When can I retake after an unsuccessful attempt?
How to appeal the test results?
Слайды
Видео
Другие доклады
-
90 мин
Gregory Smolkin Postgres ProfessionalРезервное копирование с помощью pg_probackup
pg_probackup is a flexible tool that allows choosing the backup strategy depending on the write load of the PostgreSQL cluster, as well as offers a number of other features that can facilitate this vital aspect of database maintenance. In this tutorial, we will see how to apply this tool in practice.
-
180 мин
Anton Doroshkevich ИнфоСофтМастер-класс настройки PostgreSQL для 1С
You will have a fascinating journey through PostgreSQL settings. We will talk about that with 1C not so or on the contrary so that under it it is necessary to adjust specially DBMS. We will discuss approaches to testing the speed of 1C. Consider the various options for backup schemes and fault tolerance. In the process, we will compare the speed of 1C on PostgreSQL configured by default with the speed of 1C configured for PostgreSQL. Also, we will create a replica of PostgreSQL, and switch to it the 1C Server "live", see what users will see 1C during this operation. And a separate block will be devoted to Postgres Pro Enterprise Edition, how the use of its advantages affects the speed of 1C.
-
22 мин
Георгий Рылов ЯндексWAL-G: новые возможности и расширение сообщества
Open-source maintainers face many challenges as projects grow. How to write more required features, fix more issues and have time to watch more pull requests? On the example of WAL-G(backup tool for PostgreSQL) I will tell you about how we solved these problems by launching a course of Open-source development at Ural Federal University, what we achieved and what will we do next.
-
90 мин
Максим Милютин OzonPatroni и stolon: инсталляция и отработка падений
Patroni and Stolon are two of the most popular and advanced solutions for orchestrating PostgreSQL and ensuring auto-failover for clusters with the Leader-Followers configuration. However, engineers who migrate from good old tools like Corosync&Pacemaker or built-in solutions of other DBMS often run into issues when installing these tools and figuring out the purpose of each component.
In this tutorial, we will go through a typical installation procedure of Patroni and Stolon clusters on virtual machines (not in containers), as well as review their behavior in case of various infrastructure failures. The whole process will be demonstrated on three vagrant virtual machines with pre-built images. You can follow along on your own system if you set up the required environment.