title

text

Gregory Smolkin
Gregory Smolkin Postgres Professional
14:30 03 February
90 мин

Database backup with 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.

Материалы к докладу

Видео

Другие доклады

  • Oleg Bartunov
    Oleg Bartunov Postgres Professional
    45 мин

    Everything about full text seach

    PostgreSQL built-in full text search gives unique possibilities inaccessible for external search engines, such as virtual or generated document search and search with access restrictions. I will talk about these and other features, full text search configuration, indexes, and highlight the latest advances and future expectations

  • Александр Кварацхелия
    Александр Кварацхелия БАРС Груп
    Александр Чирков
    Александр Чирков Барс Груп
    45 мин

    Migration from Oracle to PostgreSQL using an automatic converter

    In the report, we want to talk about the experience of migrating one large system from Oracle to PostgreSQL. The system itself was built on the PHP + Oracle stack; its distinguishing feature was that all business logic was implemented in PL / SQL code. In a DBMS, there are more than 3000 packages with 4-10 functions (procedures) in each. In PHP - more than 10,000 forms with inserts of anonymous blocks used to receive data, process and save results in Oracle.

    To solve this extremely voluminous work, we took ANTLR4 (a powerful parser generator for reading, processing, executing, or translating structured text), PL/SQL grammar, and created an automatic converter that allows you to convert all objects in the schema and our system from Oracle to working code for PostgreSQL.

  • Виктор Еремченко
    Виктор Еремченко Miro
    45 мин

    Fault-tolerance cluster PostgreSQL + Patroni

    I will speak about our experience in solving the fault-tolerance problem for PostgreSQL, which options we reviewed and how we chose Patroni.

    I will cover solution testing, quick implementation to the production and issues we faced as well as the way we solved them.

  • Alexey Fadeev
    Alexey Fadeev Sibedge
    22 мин

    GraphQL backend on PostgreSQL with plv8.

    Recently, I was working on a project where graphQL was used for sending requests to its .NET Core backend, but this was not a good idea. The point is, a graphQL query is a hierarchical structure with a dynamic set of fields. It’s difficult to perform such requests via a statically-typed programming language and a relational database as suggested by the tools available. So, I came up with the idea of using the plv8 extension and perform graphQL queries right on the database side. It took me about two hours to develop a working prototype that could perform the same queries as the software under development for more than one month! Then various improvements have been made and I want to introduce them all. If you are thinking of using graphQL instead of REST, my speech could be most useful and could help you to save a lot of time.