User Tools

Site Tools


how_to:postgresql_replication

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
how_to:postgresql_replication [2018/11/14 10:45]
127.0.0.1 external edit
how_to:postgresql_replication [2019/02/06 17:10] (current)
paul [PostgreSQL Replication]
Line 9: Line 9:
 Both the Master and Slave PCs should have VPOP3 installed into the same location (eg c:\vpop3 or d:\vpop3, etc), or settings relating to paths will not work if you have to fail over to the Slave PC. Alternatively,​ you could use the [[http://​blog.pscs.co.uk/​command-line-access-to-vpop3-settings/​|Command Line Settings Tool]] to change the paths as part of your fail over procedure. Both the Master and Slave PCs should have VPOP3 installed into the same location (eg c:\vpop3 or d:\vpop3, etc), or settings relating to paths will not work if you have to fail over to the Slave PC. Alternatively,​ you could use the [[http://​blog.pscs.co.uk/​command-line-access-to-vpop3-settings/​|Command Line Settings Tool]] to change the paths as part of your fail over procedure.
  
-(We can help set this up database replication for you if you wish, but this will be chargeable - the current rate is £100 + VAT for a simple setup (ie replicating over a LAN with file sharing available between the two PCs). If you have a more complicated setup (eg replicating over the Internet) this can be more complex as it can involve configuring VPNs etc, so the cost may be greater)+(We can help set this up database replication for you if you wish, but this will be chargeable - the current rate is £150 + VAT for a simple setup (ie replicating over a LAN with file sharing available between the two PCs). If you have a more complicated setup (eg replicating over the Internet) this can be more complex as it can involve configuring VPNs etc, so the cost may be greater)
 =====On the Master PC===== =====On the Master PC=====
   * In the VPOP3\pgsql\data folder, find the file **postgresql.conf** and edit it using Notepad or another text editor. At the bottom of the file add the lines:   * In the VPOP3\pgsql\data folder, find the file **postgresql.conf** and edit it using Notepad or another text editor. At the bottom of the file add the lines:
how_to/postgresql_replication.txt · Last modified: 2019/02/06 17:10 by paul