Viewing entries tagged with replication. Return to full view.

Another couple of steps on my backup crusade

For a while now, I've been annoyed with how difficult it is to set up good backups in PostgreSQL. The difficulty of doing this "right" has pushed people to use things like pg_dump for backups, which is not really a great option once your database reaches any non-toy size. And when visiting customers over the years I've seen a large number of home-written scripts to do PITR backups, most of them broken, and most of that breakage because the APIs provided were too difficult to use.

Over some time, I've worked on a number of ways to improve this situation, alone or with others. The bigger steps are:

  • 9.1 introduced pg_basebackup, making it easier to take base backups using the replication protocol
  • 9.2 introduced transaction log streaming to pg_basebackup
  • 9.6 introduced a new version of the pg_start_backup/pg_stop_backup APIs that are needed to do more advanced base backups, in particular using third party backup tools.

For 10.0, there are a couple of new things that have been done in the past couple of weeks:

Continue reading

Conferences

I speak at and organize conferences around Open Source in general and PostgreSQL in particular.

Upcoming

Prague PostgreSQL Meetup August
Aug 27, 2018
Prague, Czech Republic
Postgres Open 2018
Sep 5-7, 2018
San Francisco, USA
Day of the Programmer
Sep 13, 2018
Jönköping, Sweden
PGConf.EU 2018
Oct 23-26, 2018
Lisbon, Portugal

Past

PGDay.Amsterdam
Jul 12, 2018
Amsterdam, Netherlands
PGConf.UK
Jul 3, 2018
London, UK
PGCon 2018
May 29-Jun 1, 2018
Ottawa, Canada
PGConf.DE 2018
Apr 13, 2018
Berlin, Germany
PGDay.paris 2018
Mar 15, 2018
Paris, France
More past conferences