Re: replication solution

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I've heard that rubyrep (http://www.rubyrep.org) is a good tool for replication too. I think it has gained popularity because of its ease of use. On a similar note I am eager to try postgreSQl 9.0 bulit in hot standby solution.I can't really wait till Postgersql rolls out replicated solution which can also be used for a failover.


Dinesh

On 10/13/2010 1:06 PM, Simon Riggs wrote:
On Tue, 2010-08-24 at 15:46 +0200, Silvio Brandani wrote:
Hi all,

we are looking for a solution to create a replicated database to be used
as reporting database with same data of production ( we can accept a lag
of some minutes).

we already have the Point In Time Recovery but we need a solution where
the standby is  always open in  readonly  , but the data is replicated
continuosly from primary.

The Slony solution could be a possibility but the production database is
80 Gb of data with  around 10000 transaction each hour.

DO you have some suggestion for our implementaiont if exists??
PostgreSQL 9.0 is production ready now and supports Hot Standby, which
is exactly what you want.



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux