Postgres@CERN - PostgreSQL Meetup at CERN - January 13th

Contribution List

1. Introduction

Eva Dafonte Perez (CERN)

13/01/2023, 14:00

2. Citus Data: The database distributed without complex

Cédric Villemain (Data Bene)

13/01/2023, 14:30

Interested in the issues of High Availability and Quality of Service, he contributes to the various projects he uses and promotes.
Citus Data is an extension of PostgreSQL that extends this famous relational database server to design distributed databases.
Distributed calculations, multi-tenant with isolated customers, resharding without downtime, ...
If this already sounds familiar, you'll...

3. Patroni + pgBackRest : Hero + Hero = Superhero?

Julia Gugel (DBI Services)

13/01/2023, 15:50

The first hero gives you high availability and reliability. The second hero gives you disaster recovery and recovery from human errors. What happens if we combine those heroes to get a kind of superhero?
We're talking about Patroni and pgBackRest here: Can/will they integrate? We'll see that live, reproducible for you with easy step by step instructions.

4. PostgreSQL: The Time-Series Database You Actually Want

Chris Engelbert (Timescale)

13/01/2023, 16:50

Time-series data, or data being associated with its respective time of occurrence, is everywhere. From the obvious cases, such as metrics, observability, IoT data, all the way to logs, invoicing, or payment records.

While storing some of these in relational databases is standard practice, people often reach for specific time-series databases when volume gets high. But imagine if you could...

5. YugabyteDB: Distributed SQL Open-Source PostgreSQL-compatible

Franck Pachot (Yugabyte)

13/01/2023, 17:35

A short introduction to Distributed SQL databases, to scale-out OLTP with cloud-native High Availability, Elasticity, and geo-distribution