ads' corner

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.

So I decided to have a look. Turns out, it’s surprisingly easy to do.