rocket

Getting Started

Get up and running on PostgreSQL

Services to expedite PostgreSQL deployments on your infrastructure, including migrations to PostgreSQL from other database management systems (DBMS)

Contact us

Getting Started Services

stopwatch

Quick Deploy

Accelerate your implementation with a proven reference architecture that will get you set up with a PostgreSQL database in your environments, including backups and monitoring

design

Solution Design

Customized guidance and solution design from PostgreSQL experts, including a design document that outlines tooling recommendations, sizing, instance policy, and infrastructure considerations

change

Migration Assessment

We will clear a path to PostgreSQL, to escape vendor lock-in and cut database costs, without sacrificing the functionality you need

handshake

Migration Assistance

We ensure that your applications speak the same language as your databases

stopwatch

Quick Deploy

In a workshop, we’ll teach you how to deploy highly available, scalable, and secure environments, in a way that accelerates the implementation of your PostgreSQL solution. We’ll provide reference architecture and use a standards-based approach based on best practices. Includes:

  • Database installation and configuration
  • Streaming replication between up to 3 servers with one primary and up to two standbys
  • Failover (EFM) installation, configuration, and demo
  • Monitoring and alerting (PEM) installation, configuration, and demo
  • Backup and recovery (BART) installation, configuration, and demo
design

Solution Design

We’ll review your database strategy, SLAs, and infrastructure. Then we’ll design a solution that meets your requirements and expectations for a specific project or application. Depending on your needs, we can help you plan your high availability strategy, user management and policies, how you monitor, and how to optimize your database configuration to your needs. Includes:

  • Review EDB and Open Source tooling options
  • Review SLAs and system standards and map requirements to PostgreSQL
  • Develop Strategies and Standard Operating Procedures around the following database activities with PostgreSQL
    • Software Deployments
    • Database Tuning Parameters
    • High Availability
    • Monitoring
    • Auditing
    • Backup and Recovery
    • Minor and Major Upgrades
    • User Account Management
    • Maintenance Jobs
  • Review Existing PostgreSQL strategy
  • Review cloud vs physical hardware options
    • VM vs Bare Metal vs Container platforms
    • Sizing, cost, etc.
    • When to scale
    • Running on Bare Metal
    • Separate server
    • Same server, new Instance
    • Same instance
  • Review efficient sizing and usage of PostgreSQL in VMWare ESX, Amazon EC2, and Kubernetes environments
change

Migration Assessment

We’ll conduct an evaluation of your current databases to determine the level of effort required to migrate to PostgreSQL. The assessment will include the best migration candidates, schema incompatibilities, and workarounds. Includes:

  • Evaluating your existing database structure
    • We understand your current database landscape and classify your Oracle database schemas
  • Analyzing incompatibilities
    • We investigate incompatibilities between your current Oracle database schemas and PostgreSQL and determine approach and workarounds
  • Estimating the level of effort for migration
    • We help you understand how to migrate, and which functions in PostgreSQL can replace your current functionality
  • Identifying migration candidates
    • We recommend which databases to start with, and which databases will be most complex
handshake

Migration Assistance

We’ll help your developers migrate to PostgreSQL, making sure application code transitions to functions and SQL commands that are Oracle database compatible. Includes:

  • Partitioning
    • Number of partitions
    • Global indexes
    • Foreign keys
    • Interval partitioning
    • Subpart templates
  • Query rewriting
    • XML
    • CTE vs CONNECT BY
  • Indexing
    • Multi-column
    • Column order
    • Number of indexes (update impact)
  • Refreshable Materialized views
  • Data type and function casting predicates
  • Date/time function behavior
  • Primary key selection
  • Physical Model Changes
  • NUMERIC vs INT (connector dependencies)
  • Temporary tables act differently
  • GIS
improve

Get Started with EDB's Professional Services

Contact us