PostgreSQL 8.3 EBS Standalone v0.10
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_EXTENSIONSinput of the server. Currently PostGIS is supported, enterpostgisto enable it. - Specify the device name of the volume (e.g.
/dev/sdj) at theDB_EBS_DEVICEinput 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 nametemplate_giswill 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.