On Sun, Apr 10, 2011 at 12:41 PM, Robert Haas <robertmh...@gmail.com> wrote: > It's not integrated and I doubt it's conveniently available on Windows. > > One of the biggest problems with our replication functionality right > now is that it's hard to set up. We've actually done a good job > making the very simplest case (one slave, no archive) reasonably > simple, but how many PostgreSQL users do you think can manage to set > up SR + HS + archiving, with two slaves that can use the archive if > they fall too far behind the master, but with the archive regularly > trimmed to the farthest-back segment that is still needed? > > We have pg_archivecleanup, but AIUI that's only smart enough to handle > the one-standby case. > > Admittedly, the above is a slightly different problem, but I think it > all points in the direction of needing more automation and more ease > of use.
And let me also note that the difficulty of getting this all exactly right is one of the things that causes people to come up with creative solutions like this: http://archives.postgresql.org/pgsql-hackers/2010-12/msg02514.php That's why we need to put it in a box, tie a bow around it, and put up a big sign that says "do not look into laser with remaining eye". -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers