PostgreSQL is an awesome project and it evolves at an amazing rate. The talk will focus on the evolution of fault tolerance capabilities in PostgreSQL throughout its versions.
The talk will cover the topics listed below:
• Robustness of PostgreSQL
• PostgreSQL Fault Tolerance: WAL
• Transaction? Commit? Checkpoint?
• Replication Methods for PostgreSQL
• Physical Replication
The talk firstly introduces all appropriate levels of
database scheduling and then focuses on PostgreSQL and the means it
provides. The talk explains the meaning and importance of key
approaches. Postgres community has already developed several tools in
that area. Some popular common options will be highlighted together
with the problems that different scheduling approaches have....
As database size and complexity grow, DBAs may face the fact that the functionality offered by built-in tools
such as pg_dump and pg_basebackup is insufficient, and more flexibility is required to create reliable backups
and manage them.
This talk cover various advanced topics in the area of backups:
- incremental backups;
- archive management;
- backup validation;
SQL is a rich language and can do more than you think. The short talk will show some techniques I learned by trying to solve general-purpose programming challenges using just a single query.
The computer science department of Université Claude Bernard Lyon 1 (France) has progressively introduced PostgreSQL in its courses since 2018.
Now, more than 400 students enrolled from second to fifth year use PostgreSQL in databases, web, security or system administration courses.
In this talk, we will briefly showcase our platform and give feedback on some common pitfalls students and...