| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Adrian Klaver <aklaver(at)comcast(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org, Sanjay Arora <sanjay(dot)k(dot)arora(at)gmail(dot)com>, "Harald Armin Massa[legacy]" <haraldarminmassa(at)gmail(dot)com>, John R Pierce <pierce(at)hogranch(dot)com> |
| Subject: | Re: postgreSQL & amazon ec2 cloud |
| Date: | 2009-03-03 15:25:17 |
| Message-ID: | 11017.1236093917@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Adrian Klaver <aklaver(at)comcast(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roger Chen | 2009-03-03 15:30:56 | Re: how to use pg_dump to dump tables whose owner is me |
| Previous Message | Oleg Bartunov | 2009-03-03 15:21:02 | Re: postgreSQL & amazon ec2 cloud |