If you are looking forward to migrating your PostgreSQL database to AWS EC2 cloud servers, you can do so by following the simple steps we have posted below. You can make it more reliable and secure from accidental EC2 instance crashing by allowing the postgresql server to run from an EBS volume. You can also take a snapshot of the EBS volume which will be stored on AWS storage service s3 which will make it highly reliable by making it available on multiple AWS availability zones that spans across datacenters.
[bash]mkfs -t ext3 /dev/sdh ( or mkfs.ext3 /dev/sdh )[/bash]
6 ) Install postgresql server
[bash]yum install postgresql-libs postgresql postgresql-server[/bash]
8 ) Stop Postgresql server if it is already running on your instance
10) Edit the init script for Postgresql and give the correct path for PGDATA and PGLOG
11 ) Edit Postgresql configuration files to give access to database client , database , & database user .
12) Start the Postgresql server
[bash] /etc/init.d/postgresql start[/bash]