On Tue, Mar 03, 2009 at 10:25:17AM -0500, Tom Lane wrote: > Adrian Klaver <aklaver@xxxxxxxxxxx> writes: > > Nothing. I have created a Postgres instance on an EC2 virtual machine with > > attached EBS(Elastic Block Storage). I only got as far as creating in it and > > verifying it would run, no benchmarking. EC2 instances have storage as part of > > the instance but it is temporary and goes away when the instance is shut down. > > For a database you want EBS as it is a virtual harddrive that persists. Should > > an EC2 instance go down, you just reattach the EBS drive on reboot. > > ... I wonder whether you have any guarantees about database consistency > in that situation? PG has some pretty strong requirements about fsync > behavior etc, and I'd not want to take it on faith that a cloud > environment will meet those requirements. > > Performance would be an interesting question too. > > regards, tom lane There's a place called Engine Yard offering Ruby on Rails hosting with PostgreSQL on Amazon EC2. - Josh / eggyknap
Attachment:
signature.asc
Description: Digital signature