Child pages
  • Postgresql Replication Workshop
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Not strictly QGIS related, but very much a part of NIWA's QGIS ecosystem, where QGIS is the graphical GIS tool, working with spatial data which is managed in Postgis.

NIWA is taking advantage of Josh Berkus of PG Experts being in New Zealand in January 2015, to have him host a workshop on Postgresql database replication on 20th January.


Postgresql, a popular, powerful and robust Object Relational Database Management System - ORDBMS - (along with Postgis) is a core part of NIWA's strategy for environmental data management. As such, it is very tightly integrated with NIWA's internal and external data discovery and delivery systems, as the foundation upon which many of these services are built.

Robust data management, as the Christchurch earthquakes demonstrated all too well, has to provide for disaster recovery- especially environmental and other data which is needed for informed recovery programmes. One way to do this, is database replication, which, among other things, enables a remote database system to be automatically maintained as a replica datastore, which can take over an operational role in the event of a failure of the primary database. Recent versions of Postgresql have introduced sophisticated replication capabilities as part of the core package. This workshop will provide a hands on session where you can set up your own Postgresql replication cluster.

This is a hands-on, technical workshop intended for those managing databases, not for casual users. It should be about 5 hours, at NIWA Wellington. We will post further details as they come to hand. NIWA will be charging a small fee to non-NIWA attendees to help cover costs.

If you are interested in attending, please contact [email protected] or [email protected].


In Josh's words:

PostgreSQL’s built-in replication is conceptually simple, but the devil
is in the details, and this tutorial is all about the details. We will
cover the core essentials of how to set up and configure binary
replication, using hands-on exercises for some elements, including:

* setup & configuration
* replication security
* cascading replication
* synchronous replication
* failover and failback
* replication management tools
* performance tuning replication

Materials and Docker test environments will be updated at the
pgReplicationTutorial Github project:
( two weeks before the
event. Attendees are strongly encouraged to download it and set up the
learning environment before the tutorial; time will not be given during
the tutorial to do so.

Attendees will leave knowing how to set up a simple replication cluster,
and about the options for more complex configurations.


See you there!

  Brent Wood

  • No labels