Dig the WAL Tuesday 13:30 Berlin B
Twitter: @jcarnu LinkedIn: jean-christophe-arnu Company website: www.loxodata.com
Hi, my name is Jean-Christophe. I live in the south of France.
I'm a PostgreSQL enthusiast since 1997 when I started using PostgreSQL at the end of my university. At that time, Postgres95 was just renamed PostgreSQL.
In my professional life, I used various RDBMS but PostgreSQL was still a first choice. I get more and more experience in administration whereas mainly involved into development tasks. I've used PostgreSQL in many use-cases but the most representative is a flood disaster warning system to prevent life and material issues on a wide area.
Today I work for Loxodata, The French PostgreSQL consulting company.
I'm still developing tools for our customers and contribute to the PostgreSQL project.
I started to chat (on IRC) with the community around 2000/2001. With some other French people we decided to create PostgreSQLFr, a non-profit organization for French-speaking PostgreSQL users in 2004/2005.
In 2008, I organized the first PGDay.fr with PostgreSQLFr in Toulouse (France). And this year I was at the 10th anniversary edition of this event as a speaker! I ran trainings for RMLL years ago. I also attended my first PGDay Europe in Prato (Italy) and then it became PostgreSQL Europe.
Recently I was speaker in Toulouse PostgreSQL users Meetup. I'm also involved in translations or proofreading French translations for press releases.
As you can see, my contribution is small, but I hope I could give more time and produce more with time!
Oh yes I have!
Each pgconf.eu I was attending was awesome. I was in Prato, Stuttgart, Amsterdam. This year I was also for the first time in FOSDEM conference. And this pgconf.eu 2019 edition is my first time as a trainer! I can't wait meeting all the people I've already met the previous years and new PostgreSQL enthusiast people!
Well, it's all about WAL files. You know, the famous files in pg_wal directory (you had previously in pg_xlog) with strange hex names. I always wondered what was actually inside these files, what kind of information could be found in them, how they could be used? I mean, how can a crashed cluster be recovered using the information stored in these files? I also wanted to know the tools that can be used to perform different tasks with WAL files. These were real questions I had as a DBA and as a developer. Therefore, if I had these questions, others should have too. That’s why I thought I should share my discoveries. Isn’t it what opensource is all about? Sharing knowledge. All these questions will be answered in that training (well partially because I surely couldn’t imagine all the use cases one can think of). We've built special virtual machine image in order to create specific use cases for that training, this is a hands-on training!
Any DBA or DevOps who already has a previous experience in Point In Time Recovery and PostgreSQL Administration.
Well, medium knowledges are prerequisites:
Definitively all the features around performance enhancements like parallelism and JIT.
There are lots of interesting talks so it's difficult to choose one in particular. My favourite ones: