Multi-site Deployment enabling Disaster Recovery for
VMware Data Services Manager Postgres
instances

You can implement disaster recovery scenarios or perform data migration between different sites by using multi-site replication of your
VMware Data Services Manager Postgres
instances.
To perform multi-site replication you need primary and secondary database instances. You must configure remote replication for the primary instance, then create a secondary instance where you want the data to be replicated and establish a connection between both instances. Afterwards, you can promote a secondary database to a primary database at any point in time.
  1. Configure remote replication.
    In the Create VMware Data Services Manager instances procedure, you configure remote replication in Step 5.
  2. Retrieve replication details.
    1. Navigate to the primary instance.
    2. In the
      Availability
      tab, copy the
      Replication User Connection String
      and the
      Replication Slot Name
      separately.
  3. Create the secondary instance.
    1. Click
      Instances
      Create Instance
      .
    2. Select
      DSM Postgres
      Secondary
      .
    3. Enter the necessary details, including the copied
      Replication User Connection String
      and
      Replication Slot Name
      .
      The secondary instance must have the same PostgreSQL major version as the primary instance.
    4. Click
      Create
      .
  4. Promote a secondary instance to primary.
    1. In the Instances menu, select the secondary instance.
    2. Click
      Promote
      .