NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
<li>Uncomment and edit the following lines in the '''postgresql.conf''' file in C:/IMSMAng/pgsql/data:
<pre>
row 153 wal_level = hot_standbyrow 174 checkpoint_segments = 8row 196 max_wal_senders = 3row 199 wal_keep_segments = 8
</pre>
The numbers on the left correspond to the number of the line.
pg_basebackup –h <master-ip> -D c:/IMSMAng/pgsql/data –U replicator –v –P
</pre>
This command makes the initial synchronisation, i.e. copies the entire database from the master to the standby. This can take some time, depending on the size of the database. The progress can be followed on the command window as shown below.<br />
[[File:Pgsql replication basebackup1.png]]<br />
The following warning message can be ignored:<br />