MultiCloud Marketplace

Wopata

PostgreSQL 8.3 EBS Standalone v0.10

Open in Dashboard

Published by Wopata on Oct 29, 2010Revision: 2

Description

EBS-backed standalone PostgreSQL 8.3 server. We are currently working on a Pgpool-II + streaming replication server template for added reliability.

Setup:

  • Add an EBS volume to the server and set it to "attach on boot time".
  • List extensions in the DB_EXTENSIONS input of the server. Currently PostGIS is supported, enter postgis to enable it.
  • Specify the device name of the volume (e.g. /dev/sdj) at the DB_EBS_DEVICE input of the server
  • This device shall contain a PostgreSQL data directory - if it does not exist at boot time, the initialization script will run initdb. If you have added PostGIS, a GIS-enabled template database with the name template_gis will be created at this point.

You can back up and restore your database with two operational scripts (make sure to set the BACKUP_S3_PATH input).


Published by Wopata

Contents

  • MultiCloudImage: RightImage CentOS5_0V3_0_0 [rev 1]

  • RightScript: DB Backup PostgreSQL Databases v1.0 [rev 1]

  • RightScript: DB Restore PostgreSQL Databases v1.0 [rev 1]

  • RightScript: MAIL Postfix Local Delivery v1 [rev 2]

  • RightScript: MISC ssh priv key install v2 [rev 1]

  • RightScript: DB Install PostgreSQL 8.3 for EBS v0.9 [rev 3]

  • RightScript: SYS Monitoring install v7 [rev 4]

  • RightScript: SYS Syslog Remote Logging Client v6 [rev 5]

  • RightScript: SYS Timezone set v1 [rev 1]

  • RightScript: SYS lvm on /mnt v8 [rev 1]

  • See More

Revisions

Revision 2 | Oct 29, 2010

PostGIS is now optional through input parameter.

Revision 1 | Oct 27, 2010

Publishable version without Wopata-specific scripts

Discussion

Info

No Ratings

Supported Clouds

Pricing

Available to Paid
RightScale Accounts

Sign-up for RightScale

Support Information

Please email Roland Venesz for support.