EDB Postgres Ark™

EDB Postgres Ark™

EDB Ark automatically provisions PostgreSQL or EDB Postgres Advanced Server databases in single instances, high-availability clusters, or application development sandboxes. EDB Ark frees DBAs and application developers from the rigors of setting up and administering robust database environments. In minutes, EDB Ark configures a cluster of database machines with:

• Streaming replication
• Connection pooling
• Load balancing
• Automatic failover (transaction or recovery time preferred)
• Secure data encryption
• Rotating user-scheduled backups
• Point-in-time recovery
• Elastic storage
• Elastic scale out

EDB Ark’s automatic scaling of storage resources and scale out of read replicas when a database cluster reaches user-defined thresholds provides unattended, around-the-clock responsiveness to unpredictable load demands on your database infrastructure.

This document will demonstrate how to use the EDB Ark console successfully in your cloud-based database management activities.

• What’s New
  • Limitations
• EDB Ark - Overview
  • Architecture Overview
  • Using Ark as a Template Only User
  • Using a Federated Console
• Accessing the Ark Console
  • Using Self-Registration on an Amazon Hosted Console
• Using the Ark Console
  • The Dashboard Tab
    • Using the Console Switcher Feature
  • The Clusters Tab
    • The Details Panel
    • The Events Panel
  • The Backups Tab
  • The User Tab
    • Updating a Password on Amazon AWS
• Creating a Server Cluster
  • Manually Creating a Cluster
    • Using a Template to Create a Cluster
  • Cloning a Server Cluster
    • Using a Template to Clone a Cluster
  • Modifying a Cluster’s Administrative Settings
• Connecting to an EDB Ark Cluster
  • Using ssh to Access a Server
  • Connecting to EDB Ark with the psql Client
  • Using iptables Rules
• Managing Backups and Recovery
  • Performing a Base Backup for Point-In-Time Recovery
  • Reviewing Stored Backups
  • Restoring a Cluster from Backup
    • Using a Template to Restore from Backup
• Automatic Failover
  • Manually Promoting a Standby Node
• Manual Scaling
  • Manually Adding Replicas and Storage
  • Manually Removing a Replica
  • Manually Changing the Server Class
• Automatic Scaling
  • Adjusting the Automatic Scaling Thresholds
• Load Balancing
• Customizing Your Cluster
  • Adding an Extension to a New Cluster
• Database Management
  • Moving an Existing Database into a New Cluster
  • Manually Modifying Configuration Files
    • Best Practices for Modifying Configuration Files
  • Controlling the Database Server
  • Updating the Server Version on the EDB Ark Cluster
    • Performing a Minor Version Upgrade
    • Performing a Major Version Upgrade
• Troubleshooting
  • Frequently Asked Questions
  • The EDB Ark Email Notification System
• AWS Policies
• Conclusion