Packaged Services

Create a rock solid database foundation using a suite of packaged services performed by Postgres experts.

Together, our experts and your staff will establish an architecture that is maintainable, high performing, highly available, and safeguards your data. We can even augment your own DBA staff on a temporary or permanent basis. All packaged services are well defined, affordably priced, and executed in a timely and predictable fashion. And all our engagements end with effective knowledge transfer enabling your staff to own and maintain the work now and as your business grows.

Postgres Plus Replication Setup Service

Database replication is an advanced data management technique that can benefit your database infrastructure in multiple ways. Our experts will show you how to use replication to:

  • Safeguard data with failover/standby capabilities
  • Optimize online transaction processing
  • Offload reporting/BI queries
  • Backup and Recover
  • Migrate Systems

Whether you are offloading production data to reporting servers, synchronizing warehouse information or optimizing your failover/standby capabilities in a High Availability architecture, EnterpriseDB experts will deliver a robust replication solution tailored to your requirements.

The Replication Setup packaged service includes:

  • Identification of candidate databases for replication
  • Identification of the appropriate technology and implementation for replication
  • Analysis of uptime requirements and data latency
  • Implementation of replication
  • Testing of replication
  • End-user education on replication
  • Knowledge Transfer to your staff

Picking a Replication Strategy

There are several different replication strategies including snapshot replication (a onetime copy), asynchronous replication (an ongoing data refresh from a master copy), and transaction log shipping. Within a particular strategy there may be other needs that can be met. For instance, a replication strategy that is primarily aimed at offloading processing stress on the master database can also yield benefits in the areas of failover and backup. Our Postgres experts will steer you to an optimal solution.

A Team Building Exercise

Throughout the engagement EnterpriseDB will work closely with your staff to ensure that the replication strategy meets your organization's needs. Our consultation includes the initial analysis in which you participate, solution design, implementation, and testing. EnterpriseDB staff will also educate your DBAs and developers on maintaining and developing applications in a replication environment.


Our Knowledge Is Your Gain

EnterpriseDB will also teach your DBAs the correct administration and maintenance practices for replication. This includes such practices as:

  • Adding new replication nodes
  • Starting and stopping replication
  • Failing over from Master to Slave
  • Subscribing and Unsubscribing replication datasets
  • Graceful switchover
  • Establishing replication time intervals

EnterpriseDB became part of the Bio-Imaging design team and helped us to make valuable improvements to our replication design.

Emmanuel Olart,
Manager Technical Services, Bio-Imaging S.A.S.

Customized Tools

During the Replication Engagement, EnterpriseDB consultants will develop utilities to manage and maintain your replication set. These utilities automate the manual processes that can be involved and ensure a consistent procedural approach to handling replication that reduces overhead and errors.

Download the Replication Setup data sheet.

Contact us about a Replication Setup today!