Re: postgreSQL & amazon ec2 cloud - Mailing list pgsql-general

From Joshua Tolley
Subject Re: postgreSQL & amazon ec2 cloud
Date
Msg-id 20090303203921.GE25872@eddie
Whole thread Raw
In response to Re: postgreSQL & amazon ec2 cloud  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: postgreSQL & amazon ec2 cloud  (Erik Jones <ejones@engineyard.com>)
List pgsql-general
On Tue, Mar 03, 2009 at 10:25:17AM -0500, Tom Lane wrote:
> Adrian Klaver <aklaver@comcast.net> 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

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: grant everything on everything and then revoke
Next
From: Gregory Stark
Date:
Subject: Re: Strange behavior: row won't delete