Skip to content

PostgreSQL Upgrades are hard!

Together with Lætitia Avrot and Nikolay Samokhvalov I was invited to participate in a Community Panel (YouTube video) about PostgreSQL Upgradability at Postgres Vision 2022. The panel was moderated by Bruce Momjian and initiated and organized by Jimmy Angelakos. Bruce did talk with each of us before, which helped a lot to guide the discussion in the right direction. The recording of the panel discussion is available on the Postgres Vision website.

During this panel each of us provided examples for how easy or complicated PostgreSQL upgrades still are.


Continue reading "PostgreSQL Upgrades are hard!"

Reversing pg_rewind into the future

During Nordic PGDay 2015, I attended Heikki's talk about "pg_rewind". Someone in the audience asked, if it's possible to roll a PostgreSQL database forward, ahead of the master. The answer was that currently it's not possible, but there is no technical reason why this should not work.


Continue reading "Reversing pg_rewind into the future"

Chemnitz Linux Days 2013

"Chemnitz Linux Days" is one of the main Open Source and Linux conferences in Germany, for the 15th consecutive year now. And personally it's one of my favourite conferences.

Based on experience from the past two years I decided not to have a booth, but nevertheless submitted two talks. One was accepted: "Replication with PostgreSQL" (slides and script here). On the laptop keyboard&mouse: Andreas Kretschmer. On the microphone: me. It was the first talk in the morning, but the room was full with visitors. We got nice feedback about the talk as well and had to continue discussions outside of the room, when the next talk started.

Continue reading "Chemnitz Linux Days 2013"

Replikation mit PostgreSQL - Vortrag auf den Chemnitzer Linuxtagen 2013

Die Folien für den Vortrag "Replikation mit PostgreSQL", den Andreas Kretschmer und ich auf den Chemnitzer Linuxtagen 2013 gehalten haben, sind jetzt online:

Replikation mit PostgreSQL

Ein Link auf das Build Skript zum Nachvollziehen der Demo ist hier:

Demo Skript

Viel Spaß damit.

You need two elephants for replication

FOSDEM 2008 in Brussels is a smashing success. As you remember we have a shared devroom together with the BSD projects. So far it seems we are one of the few devrooms who have a full schedule for both days - some other projects (who particulary got a bigger devroom) only had talks for one day or worse.

Anyway, we had many visitors in our devroom, for some talks the audience even had to use standing places. The talks are scheduled on a rotating basis so most of the time we have one PostgreSQL talk followed by a BSD talk. Some talks even overlap thematically a bit, BSD folks is using PostgreSQL in some tests or projects and vice versa. With the rotating scheme we have many visitors from both groups who not just attend one specific talk but instead stay for one or two extra talks.

We also have a booth which is attracting a lot visitors too. Many people come around, ask questions or tell us how they are using PostgreSQL. Oh, we also have some interesting stuff to give away or to sell. Gabriele brought flyers and pens from italy, Gevik sponsored a carton with anti-stress balls with PG logo on it, Magnus brought live-cds, supplied by Robert and Koen made suitable labels. David had nice new pins in his luggage and one should not forget the blue plush elefants - this time we also have a pair of bigger parent elephants. Always remember, you need two elephants for replication ;-)

Later today we try to auctioneer one of the big elephants, there was some interest in the last days. Actually we don't have any small elephants anymore, most of them (23 out of 25) are already bought by visitors yesterday. Instead of the last talk, which usually does not get many attention by visitors (most people are already heading home at this time), we want to hold our election for the EU group board of directors.

We keep you informed.