[nycbug-talk] postgres incremental backups?

[Francisco Reyes]

Charles Sprickman writes:

>> [1] http://slony.info/
> 
> Just out of curiousity, is Slony the de-facto replication solution for 
> Postgres?

If you consider Free only.. I believe Slony is.
There is also pgcluster, but it's a different beast.. basically it is a 
que/caching system which can also do dual write to 2 DBs (don't know if 
more).

Commercial there is the commandprompt replication, which is what I am going 
to try in the near future. Seems simpler to use, install and maintain, but 
it is not free. It has a licence fee and a maintenance fee. Depending on the 
budget for a project it may be worth looking into. For us, it is the ease 
(or at least I hope it will be) or use and maintenance, coupled with having 
someone to call what made us go with command prompt.

I started my research about 3 months ago for replication. When we decided to 
go with commandprompt they told us they had a new version coming up in 
August and that the recommended we waited for it. I believe this new version 
is out.. so I wrote to them to check if we can proceed.

Anyone interested on hearing our experience send me a note and I will make a 
point to write back.. or there is enough interest will write back to the 
list.  I figure it will be a few weeks before we get it and use it.

One big, potential, issue I did see with command prompt replication though 
was that it needed to store an entire copy of what you are replicating 
somewhere. I don't believe it has to be in the same as the machines 
replicating, but still if you have a very large setup this extra copy can be 
a problem.