PG Deployment - WarehousePG

Service Overview

The EDB WarehousePG Deployment ensures that customers have a production-ready and benchmarked analytics environment. 

The engagement includes the deployment of a WarehousePG cluster. The offering comes in Small, Medium and Large tiers.  These tiers are defined based on the answers to the questions outlined in the Sizing section.

Scope of Service

Our Consultant will validate the prerequisites, configure and deploy the WarehousePG cluster, and validate Standard Operating Procedures (SOPs) for the agreed architecture:

• Onboard: Engagement preparation, review of prerequisites, and scope alignment
• Configuration: Prepare configuration for deployment of WarehousePG (based on agreed configuration and extensions), Backup and Monitoring.
• Deployment: Deployment of WarehousePG nodes, cluster, agreed extensions, and tooling for Backup and Monitoring.
• Validation: Quality checks, demonstration of the architecture, and review of Standard Operating Procedures (SOPs)
• Project Closure: Formal review of completion status and hand-off

Deliverables

• One (1) installed and operational WarehousePG Cluster
• Installation runbook
• Performance baseline report 
• Operational handover docs

Roles and Responsibilities

EDB Project Manager:  Responsible for initial planning, task alignment, and project closeout.

EDB Senior Consultant: Technical Lead, responsible for prerequisite validation, config and deployment, SOP Validation and documentation.

Customer Team: Responsible for providing the main point of contact for design requirements. Resources and Roles (or similar Technical Stakeholders) where input may be needed for the engagement include:

• Database Administrator
• System Architect
• Infrastructure Manager 
• Network Administrator
• Security Officer

Assumptions

• A project kickoff will be conducted to review the service scope and confirm the schedule
• This service is delivered remotely unless otherwise agreed
• EDB will deploy the architecture with the EDB-supported version of WarehousePG.
• Deployment is for a non-production environment (no live traffic)
• Customer environment is not air-gapped (unless "Air Gapped Repo Setup" is purchased separately)
• Performance testing, outside of initial benchmark, and application readiness are not in scope.
• EDB will measure baseline performance (based on gpcheckperf and TPC-DS)
• Customer will provide the names, title, email, phone number, and area of responsibility of those participating. One person will be designated as the main contact, and will be able to provide access to the people most knowledgeable about the topics to be discussed or examined. 
• Customer will make appropriate personnel available to assist EDB in the performance of the services as needed and requested by EDB in a timely manner so as not to disrupt the project schedule. 
• Customer will not provide Personal Data (as defined in applicable law). Customer agrees that it will work with EnterpriseDB to ensure that all such data is not provided.  
• Customer will ensure timely access to all systems through screen sharing and experts including third parties as required. 
• Customer will assign the appropriate resources with the appropriate privileges for the task being planned for any screen sharing sessions as needed throughout the engagement.
• Customer will provide timely feedback on all deliverables. Deliverables without commentary within 5 business days will be deemed as delivered.
• The Customer is responsible for configuring application-side connection strings, Virtual IPs (VIPs), or external Load Balancers to route traffic to the active Primary node or, when "Connection Pooling" is explicitly included in the tier, to the active connection pooler instance.

Prerequisites

• Customer will provide resource availability for workshop planning and a point of contact for coordination. 
• Server prerequisites will be prepared by the customer team before the kickoff of the project.
• Customer is responsible for providing all necessary internal design and project related documentation and requirements where EDB is required to analyze, operate, or modify customer implemented systems.
• Customer security team has approved all required software packages.

Standard Operating Procedures

EDB will validate the below test cases as part of the validation process:

Sizing

EDB offers the deployment of WarehousePG in Small, Medium, and Large tiers, to fit a variety of requirements. Please answer the following questions and provide to your designated Account contact for appropriate pricing.