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@gmail.com> 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@postgresql.org)
> 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