Обсуждение: pg in the sky
Hi Everybody,
I am curious if anyone is running postgres on Amazon cloud?
Os: windows
Pg: 8.3.8
We are looking to test running postgres on two Amazon instances and using replication to keep the two clusters in sync. There are two scenarios we are interested in:
Active- Passive architecture
One of the clusters would be the master, receiving all of the writes, the other cluster would be the slave, receiving all of the reads, sync time would be every 15 minutes
Active- Active architecture
Both instances would receive reads and writes, the sync time would be every 5 minutes
I am aware of the webcast from EnterpriseDB and various blog postings about pg replication, I know that at 9 replication is part of core. I am wondering however if anybody has actually tried it and/or running it as production.
Thank you,
Sincerely,
Kasia
> I am aware of the webcast from EnterpriseDB and various blog postings about
> pg replication, I know that at 9 replication is part of core. I am wondering
> however if anybody has actually tried it and/or running it as production.
>
Never run beta versions on Prod servers. My own tests had good
results, but is different if you want to upgrade a final server. In my
opinion the best you can do is: maintain the current version
(upgrading the patchs) and prepare your DDL and apps to run on 9. When
9 is in a final release, you can switch.
--
Emanuel Calvo Franco
www.emanuelcalvofranco.com.ar
Join: http://www.thevenusproject.com/