Re: [ADMIN] replication solution

2010-10-18 Thread Silvio Brandani
Simon Riggs ha scritto: 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

Re: [ADMIN] replication solution

2010-10-14 Thread Dinesh Bhandary
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

Re: [ADMIN] replication solution

2010-10-13 Thread Simon Riggs
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 n

Re: [ADMIN] replication solution

2010-08-24 Thread Rosser Schwarz
On Tue, Aug 24, 2010 at 10:38 AM, Joshua D. Drake wrote: > On Tue, 2010-08-24 at 15:46 +0200, Silvio Brandani wrote: >> The Slony solution could be a possibility but the production database is >> 80 Gb of data with  around 1 transaction each hour. > Slony (or Londiste) can handle that withou

Re: [ADMIN] replication solution

2010-08-24 Thread Joshua D. Drake
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 n

Re: [ADMIN] replication solution

2010-08-24 Thread Devrim GÜNDÜZ
Hi, 24.Ağu.2010 tarihinde 16:46 saatinde, Silvio Brandani t> şunları yazdı: The Slony solution could be a possibility but the production database is 80 Gb of data with around 1 transaction each hour. We do at least 15x more transactions with Slony, w/o any issues. Slony should be goo

Re: [ADMIN] replication solution

2010-08-24 Thread Kevin Grittner
Silvio Brandani wrote: > 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. What's your time frame? The Hot Standby and Streaming Replication features in PostgreSQL 9.0 wi

Re: [ADMIN] Replication solution

2009-12-05 Thread Scott Marlowe
As much of a pain as slony can be to setup and get working on a large data set, it is pretty solid and reliable for us too. Our DB is about 100G or so. On Sun, Nov 29, 2009 at 9:09 PM, Mark Guadalupe wrote: > We are currently using Slony for our client's database that has million of > rows on so

Re: [ADMIN] Replication solution

2009-12-05 Thread Mark Guadalupe
We are currently using Slony for our client's database that has million of rows on some tables and 12GB of raw data. So far so good, we set it up as a service and using a watchdog script to monitor and notify us in case the service fails. On Fri, Nov 27, 2009 at 12:19 AM, Dimitri Fontaine wrote:

Re: [ADMIN] Replication solution

2009-11-26 Thread Dimitri Fontaine
"Joshua D. Drake" writes: > http://pgfoundry.org/projects/skytools/ See also: http://wiki.postgresql.org/wiki/Londiste_Tutorial Regards, -- dim -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admi

Re: [ADMIN] Replication solution

2009-11-19 Thread Palaniappan Thiyagarajan
Thanks for the information. From: Julio Leyva [mailto:jcle...@hotmail.com] Sent: Thursday, November 19, 2009 10:53 AM To: kevin.gritt...@wicourts.gov; Palaniappan Thiyagarajan; pgsql-admin@postgresql.org Subject: RE: [ADMIN] Replication solution check this http://symmetricds.codehaus.org/ I

Re: [ADMIN] Replication solution

2009-11-19 Thread Devrim GÜNDÜZ
On Thu, 2009-11-19 at 18:25 +, Palaniappan Thiyagarajan wrote: > > I am looking for Postgres replication solution for 8.3.x DB. > > Any open source software available for replication? http://wiki.postgresql.org/wiki/Replication%2C_Clustering% 2C_and_Connection_Pooling > Anybody has good st

Re: [ADMIN] Replication solution

2009-11-19 Thread Joshua D. Drake
edge.com; pgsql-admin@postgresql.org > > Subject: Re: [ADMIN] Replication solution > > > > Palaniappan Thiyagarajan wrote: > > > > > I am looking for Postgres replication solution for 8.3.x DB. https://projects.commandprompt.com/public/replicator http://www.slo

Re: [ADMIN] Replication solution

2009-11-19 Thread Julio Leyva
check this http://symmetricds.codehaus.org/ I just began playing with that one > Date: Thu, 19 Nov 2009 12:39:04 -0600 > From: kevin.gritt...@wicourts.gov > To: pthiyagara...@cashedge.com; pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Replication solution > > Palani

Re: [ADMIN] Replication solution

2009-11-19 Thread Kevin Grittner
Palaniappan Thiyagarajan wrote: > I am looking for Postgres replication solution for 8.3.x DB. > > Any open source software available for replication? > > Anybody has good step by step doc for warm standby setup? > > Any other suggestion to achieve replication is appreciated. You might wan