You can replicate a vPostgres database to provide an added degree of fault tolerance and redundancy to your database environment.

vPostgres replication requires that you create a slave database from the master database. The slave database is a full clone of its master database.

Provision a vPostgres master (or primary) database within Data Director from which to replicate slave (or standby) instances.

Verify that the vSphere deployment hosting Data Director has two or more datastores on which to create master and slave databases. The datastores must be on different physical hosts to ensure fault tolerance in the event of physical hardware failure.

1

Log in to Data Director as a system administrator.

2

Click the Organization tab, and click Manage and Monitor.

3

Expand the Organization panel and select the vPostgres database group to which you want to add replication.

4

Right-click the vPostgres master database, and select Create Slave.

5

Complete the following information in the Create Slave wizard.

Wizard page

Action

Creation Type

Click Create new database.

General

Specify the database name, type, base database template, and database group from which to create the database.

Name

Type a name to identify the database within the Data Director user interface.

Description

(Optional) Type a description of this database.

Database Type

Displays the type of database from which you are creating a slave database.

Base DB Template

Displays the name of the base database template from which the master database was created, and which will be used to replicate the slave database.

Database Group

The name of the database group that you want the slave instance to belong to. By default, this is the database group the master instance belongs to.

Storage

Specify the data, log, and backup disk storage allocation for this database.

Specify storage allocation for each disk type. If multiple datastores are available, specify the datastore that the slave database uses for its virtual disks. To ensure redundancy, replicas use different datastores than the master database.

6

Click Finish.

The slave database is replicated from the master database, and appears in the Databases tab within the Organization and Database Group to which you assigned it. You can monitor the replication status of slave databases in the Dashboard tab, and the progress of the replication process in the Tasks panel.

You can verify that all of the data in the master instance has been replicated to the slave instance on the Replication Status panel in the Dashboard tab. The Replay Delta column displays 0 when all the data has been replicated.

If a master database fails, manually promote one of the slave database instances to take the place of the master database. See Failover to a Standby vPostgres Database.