Changes

PgSQL Replication

149 bytes added, 12:43, 6 August 2014
no edit summary
After having set up the replication, it is good practice to perform a few tests. These can typically include the following:
* Add/edit/delete data on the master server and verify that the changes are replicated to the standby.
* Verify that he standby is read-only (this is very important for data consistency) by trying to edit something directly on the standby. There should be an error message such as "Error approving fieldreport" when trying to save/approve a new object or edit an existing object in IMSMA.
* Shut down the standby, make changes on the master, start the standby and verify that all pending changes have been applied.
1,068
edits