Re: [GENERAL] Amazon EC2 | Any recent developments

2009-06-16 Thread Just Someone
Hi, On Tue, Jun 16, 2009 at 11:05 AM, Greg Smith wrote: > You just have to recognize that the volumes are > statistically pretty fragile compared to a traditional RAID configuration on > dedicated hardware and plan accordingly. I agree completely. I think the advantage is that it FORCES you to p

Re: [GENERAL] Amazon EC2 | Any recent developments

2009-06-16 Thread Greg Smith
On Tue, 16 Jun 2009, Just Someone wrote: In case the volume got corrupted (a very rare situation, as the EBS volumes are very durable), there are snapshots I can recover from and the WAL files I stream to another storage system (Amazon's S3). I wouldn't go so far as to say "very durable", beca

Re: [GENERAL] Amazon EC2 | Any recent developments

2009-06-16 Thread Just Someone
Hi, > So, when a cloud machine fails does it get de-allocated/wiped out? or > does it is it still out there in a bad state? how do you recover your > data? It depends. Sometimes it dies and you can't do anything with it. In others you can restart it. As we store the data on EBS (which is a networ

Re: [GENERAL] Amazon EC2 | Any recent developments

2009-06-16 Thread David Kerr
On Mon, Jun 15, 2009 at 06:53:00PM -0700, Just Someone wrote: - Hi, - - I've seen both - some unknown reason for it to die (mostly related to - the underlying hardware having issues). We also see instance failure - from time to time with advanced notice. Just like a regular machine - dies from tim

Re: [GENERAL] Amazon EC2 | Any recent developments

2009-06-15 Thread Just Someone
Hi, I've seen both - some unknown reason for it to die (mostly related to the underlying hardware having issues). We also see instance failure from time to time with advanced notice. Just like a regular machine dies from time to time, so do cloud instances. I'd say it's bit more common on the clou

Re: [GENERAL] Amazon EC2 | Any recent developments

2009-06-15 Thread David Kerr
On Mon, Jun 15, 2009 at 12:11:54PM -0700, Just Someone wrote: - 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

Re: [GENERAL] Amazon EC2 | Any recent developments

2009-06-15 Thread Just Someone
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

Re: [GENERAL] Amazon EC2 | Any recent developments

2009-06-15 Thread David Kerr
On Mon, Jun 15, 2009 at 11:12:32AM -0700, AJAY A 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

[GENERAL] Amazon EC2 | Any recent developments

2009-06-15 Thread AJAY A
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 exp