PgSQL Replication: Difference between revisions
Jump to navigation
Jump to search
Created page with "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)..." |
No edit summary |
||
| Line 1: | Line 1: | ||
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. | 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 ==__NOEDITSECTION__ | |||
{{NavBox Hub}} | {{NavBox Hub}} | ||
Revision as of 09:03, 6 August 2014
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.