pg in the sky

pg in the sky

am 28.06.2010 18:47:45 von Kasia Tuszynska

--_000_232B5217AD58584C87019E8933556D11020ED876AEredmx2esric om_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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 r=
eplication 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 o=
ther cluster would be the slave, receiving all of the reads, sync time woul=
d 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 wonderi=
ng however if anybody has actually tried it and/or running it as production=
..
Thank you,
Sincerely,
Kasia

--_000_232B5217AD58584C87019E8933556D11020ED876AEredmx2esric om_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">












Hi Everybody,



I am curious if anyone is running postgres on Amazon c=
loud?



 



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 scena=
rios
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 read=
s,
sync time would be every 15 minutes



 



Active- Active architecture



Both instances would receive reads and writes, the syn=
c time
would be every 5 minutes



 



I am aware of the webcast from EnterpriseDB and variou=
s 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









--_000_232B5217AD58584C87019E8933556D11020ED876AEredmx2esric om_--

Re: pg in the sky

am 28.06.2010 21:39:41 von Emanuel Calvo Franco

> 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/

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin