MultiCloud Marketplace


Database Manager for PostgreSQL 9.1 (v13.5.4-LTS)

Open in Dashboard

Published by RightScale on Aug 30, 2013Revision: 2 This component has been deprecated by the publisher.

This version is deprecated due to an issue with backing up multiple volumes. The updated version addresses this issue.


This ServerTemplate is on the LTS Lineage. For the latest Infinity version, see the Infinity Lineage
For a description of the Infinity and LTS lineages, see ServerTemplate Release Methodology

Configures a PostgreSQL 9.1 database server. This ServerTemplate provides a high-availability master/slave database configuration that can be used as the backbone for a variety of applications and workloads.

The ServerTemplate supports multiple clouds, using either instance-based storage or attachable volumes. Instance-based snapshot backups are automatically uploaded to your choice of remote object storage (Amazon S3 or Rackspace Cloud Files). It also includes iptables management for clouds that do not have firewall services.

Key Features:

  • Master or slave roles.
  • Uses attachable volumes or instance-based LVM volumes for primary backup.
  • Supports a secondary, disaster-recovery backup to S3 or Cloud Files remote object stores.
  • Support for striping of external volumes for faster database performance.
  • Continuous snapshot backups using a grandfather-father-son paradigm (on clouds with volume support).
  • Assisted database restoration, including stripe re-creation.
  • Provides scripts for master to slave fail-over, restoration of master, and more.
  • Choice of DNS providers (DNS Made Easy, DynDNS, AWS Route53, CloudDNS).
  • iptables management within a three-tier scalable web architecture for clouds that do not have firewall services.
  • Pre-configured monitoring and alerts.

Related ServerTemplates:
Load Balancer
PHP App Server
Apache-Rails-Passenger App Server
Passenger-Rails with Ruby 1.9 App Server
Tomcat6 App Server
Tomcat7 App Server
Django App Server

Release Notes

Application versions:

  • PostgreSQL 9.1

Supported public compute clouds:

  • Amazon Web Services EC2
  • Datapipe
  • Google Compute Engine
  • HP Cloud
  • Rackspace Open Cloud
  • SoftLayer
  • Windows Azure

Supported private compute clouds:

  • Citrix CloudStack 3.0.6
  • OpenStack Grizzly
  • OpenStack Havana
  • Rackspace Private Cloud

Supported backup clouds:

  • Amazon Web Services S3
  • Azure Storage
  • Google Cloud Storage
  • Rackspace CloudFiles
  • SoftLayer Object Storage

Supported primary backup methods:

  • Volume snapshots: AWS EC2, Azure Storage, Citrix CloudStack, Google Compute Engine, Rackspace Open Cloud CBS
  • Remote Object Store Upload: AWS S3, Azure Storage, Google Cloud Storage, Rackspace Cloud Files, SoftLayer Object Storage

Supported MultiCloud Images:

  • CentOS 6 - Amazon, CloudStack, Datapipe, Google, HP, OpenStack, Rackspace, Rackspace Open Cloud, SoftLayer, Windows Azure
  • RHEL 6 - Amazon, Google, Rackspace Open Cloud


  • Cookbook: yum v2.2.1

  • Cookbook: db_postgres v13.5.0

  • Cookbook: driveclient v1.0.0

  • Cookbook: iptables v0.9.3

  • Cookbook: logging v13.5.0

  • Cookbook: logging_rsyslog v13.5.0

  • Cookbook: logging_syslog_ng v13.5.0

  • Cookbook: rightscale v13.5.0

  • Cookbook: apt v1.9.3

  • Cookbook: block_device v13.5.0

  • Cookbook: sys_ntp v13.5.0

  • Cookbook: sys_firewall v13.5.0

  • Cookbook: db_mysql v13.5.0

  • Cookbook: db v13.5.0

  • Cookbook: sys_dns v13.5.0

  • Cookbook: sys v13.5.0

  • Cookbook: cloudmonitoring v0.1.5

  • MultiCloudImage: SoftLayerImage_Storage_CentOS_6.4_x64_v13.5_LTS [rev 1]

  • MultiCloudImage: RightImage_RHEL_6.4_x64_v13.5_LTS_EBS [rev 1]

  • MultiCloudImage: RightImage_RHEL_6.4_x64_v13.5_LTS [rev 1]

  • MultiCloudImage: RightImage_CentOS_6.4_x64_v13.5_LTS_XenServer [rev 1]

  • MultiCloudImage: RightImage_CentOS_6.4_x64_v13.5_LTS_KVM [rev 1]

  • MultiCloudImage: RightImage_CentOS_6.4_x64_v13.5_LTS_HVM_EBS [rev 1]

  • MultiCloudImage: RightImage_CentOS_6.4_x64_v13.5_LTS_EBS [rev 1]

  • MultiCloudImage: RightImage_CentOS_6.4_x64_v13.5_LTS [rev 1]

  • Recipe: db::do_primary_restore

  • Recipe: db::do_primary_restore_and_become_master

  • Recipe: db::do_promote_to_master

  • Recipe: db::do_secondary_backup

  • Recipe: db::do_secondary_backup_schedule_disable

  • Recipe: db::do_secondary_backup_schedule_enable

  • Recipe: db::do_secondary_restore

  • Recipe: db::do_secondary_restore_and_become_master

  • Recipe: db::do_set_dns_slave

  • Recipe: db::handle_demote_master

  • Recipe: db::install_server

  • Recipe: db::request_master_allow

  • Recipe: db::request_master_deny

  • Recipe: db::setup_monitoring

  • Recipe: db::setup_privileges_admin

  • Recipe: db::setup_privileges_application

  • Recipe: db::setup_replication_privileges

  • Recipe: db::do_primary_init_slave

  • Recipe: db::do_primary_backup_schedule_enable

  • Recipe: db_postgres::do_set_slave_async_mode

  • Recipe: db_postgres::do_set_slave_sync_mode

  • Recipe: db_postgres::do_show_slave_sync_mode

  • Recipe: db_postgres::setup_server_9_1

  • Recipe: db::do_primary_backup_schedule_disable

  • Recipe: db::do_primary_backup

  • Recipe: db::do_init_slave_at_boot

  • Recipe: logging::default

  • Recipe: db::do_init_and_become_master

  • Recipe: db::do_force_reset

  • Recipe: db::do_dump_import

  • Recipe: db::do_delete_volumes_and_terminate_server

  • Recipe: rightscale::do_security_updates

  • Recipe: rightscale::install_file_stats_collectd_plugin

  • Recipe: rightscale::install_rightimage_extras

  • Recipe: rightscale::install_tools

  • Recipe: rightscale::setup_security_update_monitoring

  • Recipe: rightscale::setup_security_updates

  • Recipe: db::do_appservers_deny

  • Recipe: sys::do_reconverge_list_disable

  • Recipe: sys::do_reconverge_list_enable

  • Recipe: sys::setup_swap

  • Recipe: db::do_appservers_allow

  • Recipe: sys_dns::default

  • Recipe: block_device::setup_ephemeral

  • Recipe: sys_firewall::default

  • Recipe: sys_firewall::do_list_rules

  • Recipe: sys_firewall::setup_rule

  • Recipe: block_device::default

  • Recipe: sys_ntp::default

  • Recipe: rightscale::default

  • See More


Revision 27 | Feb 25, 2014

v13.5.4-LTS Release



No Ratings

Supported Clouds


All Users

Sign-up for RightScale

Support Information