Re: PG replication across DataCenters
От | Andreas Kretschmer |
---|---|
Тема | Re: PG replication across DataCenters |
Дата | |
Msg-id | 20131209163821.GA13253@tux обсуждение исходный текст |
Ответ на | Re: PG replication across DataCenters (Thomas Harold <thomas-lists@nybeta.com>) |
Список | pgsql-general |
Thomas Harold <thomas-lists@nybeta.com> wrote: > On 11/22/2013 5:57 AM, Albe Laurenz wrote: >> Kaushal Shriyan wrote: >>> I have read on the web that Postgresql DB supports replication >>> across data centers. Any real life usecase examples if it has been >>> implemented by anyone. >> >> Well, we replicate a 1 TB database between two locations. It is a >> fairly active OLTP application, but certainly not pushing the limits >> of what PostgreSQL can do in transactions per second. >> > > Something that section 25 in the pgsql documentation is not clear about > for hot-standby with WAL log shipping using the built-in streaming: > > Can you choose which databases / tables on the master server get > streamed to the hot-standby read-only server at the remote site? If > not, I suspect we'll have to go with either Slony or Bucardo. WAL's contains transaction informations for the whole cluster, you can't choose particular databases or tables. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
В списке pgsql-general по дате отправления: