You should periodically inspect your database backups. Confirm that backups are being made and retained as you expect. Also, confirm the integrity of the database backup files, for example, by loading...
Database backups on Engine Yard Cloud can be encrypted with the PGP public keys of your choice. This feature uses GNU Privacy Guard, which is an implementation of the OpenPGP standard. GnuPG is a comm...
Overview If you use PostgreSQL databases, you should be aware that they require routine vacuuming. A PostgreSQL database within Engine Yard has autovacuum processes that run in the background, perfor...
This document describes the version upgrade policies for MySQL and PostgreSQL databases. PostgreSQL and MySQL major and minor versioning policies PostgreSQL and MySQL have similar versioning policies ...
This document describes: Database Replica Use Cases Selecting an Environment Type Create a New Environment with a Database Replica Add a Database Replica to an Existing Environment Choose the Instance...
Here are a couple of scenarios for restoring / loading your database: Scenario 1: Your database has become corrupted and you want restore using a recent backup. Scenario 2: You need to move an existin...
Here are a couple of scenarios for restoring / loading your database: Scenario 1: Your database has become corrupted and you want restore using a recent backup. Scenario 2: You need to move an existin...
The database promotion feature allows you to demote a running database master. You can now change the size (volume or instance) of your database master or run a long migration on a replica and make it...
Postgres servers operating on Stable-v4 2.0.123 or Stable-v5 3.0.30 stacks can support SSL based connections to the database. This document describes how to verify the server is SSL ready, as well as ...
Read this page if you want to use a PostgreSQL database with Engine Yard. Getting started with PostgreSQL PostgreSQL 9.3.x is the default database; it includes new materialized views, auto-updatable s...