Hi, I have more than a few Postgres instances on EC2. For reliability I use EBS, and take regular snapshots while also streaming the WAL files to S3. So far, the few times that my machine died, I had no issue with getting it back from EBS or the EBS volume. I also take tar backups every day, and I keep a few days back of tar, snapshots and WAL log files. If you require high performance you might have to look into the large or XL instances, as their networking is a lot faster, and EBS is accessed through the network. They also have a lot more memory. I actually think that Postgres has a big advantage on the cloud, and that's the ability to easily recover from crashes. Because of the way Postgres commits to disk and work with WALs, there is much higher chance of recovering the DB than most other DB servers out there. Bye, Guy. On Mon, Jun 15, 2009 at 11:12 AM, AJAY A<aagrawalla@xxxxxxxxx> wrote: > Hello All, > > I am investigating the possibility of hosting pgsql 8.3 on Amazon EC2 > & implementing a simple HA solution. My search of postgresql & amazon > cloud has produced little result. Just wondering if there has been > any recent development with EBS etc. and anybody would care to share > their experiences. > > Thank you very much. > > aj > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Family management on rails: http://www.famundo.com My development related blog: http://devblog.famundo.com -- Family management on rails: http://www.famundo.com My development related blog: http://devblog.famundo.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
