PostgreSQL monitoring, backups and autoscaling

Do you like RDS but wish it ran a Postgres database? Postgres role provides the same low maintenance that you’d like from Amazon RDS (including automatic backups & recovery), along with added auto-scaling (which RDS lacks).

Pre-configured Image – The Postgres image comes pre-configured with sensible parameters, and Scalr generates a unique password for you to connect your application. Additional control is achieved via ConfigurationTemplates.

Monitoring and Metrics – You can use CloudWatch metrics at no additional charge. Toggle the AWS Management Console (or Scalr’s management console) to view key operational metrics for your deployment.

Automated Backups – Backups can be turned on or off, set to run at regular intervals, and rotated n times before being discarded. You can even run backups manually or via API call. Same goes for snapshots (EBS).

Auto-Scaling – Scalr automatically adds read replicas when your read traffic increases above user-defined thresholds. You can also add these manually.

Automatic Host Replacement – Scalr will automatically replace the instance powering your database in the event of a host failure.

Replication – Scalr provides read replicas for read-heavy applications.

  • postgres setting

    Within Scalr you can change all your PostgreSQL database settings

  • postgres status

    Like all database roles, the PostgreSQL options menu contains a PostgreSQL status page.

  • postgres replication, backup

    The PostgreSQL status page allows you to check on the databases’ replication status, last backup (a dump), and last data bundle (binary snapshot).