[nycbug-talk] postgres incremental backups?
lists at stringsutils.com
Sun Sep 3 23:13:30 EDT 2006
Charles Sprickman writes:
>>  http://slony.info/
> Just out of curiousity, is Slony the de-facto replication solution for
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
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
More information about the talk