PgSQL Replication

From IMSMA Wiki
Revision as of 09:03, 6 August 2014 by Evinek (talk | contribs)
Jump to navigation Jump to search

This page describes how to set up direct replication with pgSQL. Generally, replication allows having two database servers (typically one for data entry and one for reporting) that stay synchronised. Concretely, when data is added, deleted or updated on the master server, the changes get immediately replicated on the slave or standby server. The standby database is read-only, i.e. no changes can be made directly there - only changes on the master are being replicated. Currently (August 2014) this mechanism is only in place at MACCA in Kabul.

Steps for stetting up the replication with pgSQL

Template:NavBox Hub