Changes

PgSQL Replication

150 bytes added, 09:52, 6 August 2014
no edit summary
</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.
[[File:Pgsql replication basebackup1.png]]<br />
The following warning message can be ignored:<br />
[[File:Pgsql replication basebackup2.png]]<br />
{{Note|The hot standby replication mechanism can only be applied to the '''entire''' database server, i.e. all the databases from the master will be replication to the standby -- not only the database ''imsma'' but any database that is running on the master.}}
</li>
1,068
edits