On Wed, 2008-12-10 at 21:39 -0700, Scott Marlowe wrote: > On Wed, Dec 10, 2008 at 8:43 PM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> wrote: > > On Wed, 2008-12-10 at 20:41 -0700, Scott Marlowe wrote: > >> On Wed, Dec 10, 2008 at 7:40 PM, Tim Uckun <timuckun@xxxxxxxxx> wrote: > > > >> Log shipping doesn't really lends itself to switching back and forth > >> between masters and slaves. > > > > Really? It seems to me that you can make a base backup just as fast as > > you can sync from slony (or replicator or whatever). > > sorry if my post wasn't clear. slony's not really any better. I don't > think that there's any replication for pgsql that's easy to do that > in. Is there? No probably not. I mean they are all pretty easy (especially log shipping) but it is definitely true they are slow, depending on the size of the database. Joshua D. Drake > -- PostgreSQL Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general