One thing that should be also pointed out, that while a
pg_dump/pg_restore might be faster than slony initial copy, both use
basically the same mechanisms (COPY FROM/TO STDIN/STDOUT), so I'd guess
that you wouldn't shave to much of the initial replication time via
pg_dump. (Well, slony does need to get some locks to get going when I
remember right, which means that pg_dump/pg_restore has the potential to
be faster anyway.) OTOH, a filesystem level dump, can be, especially
when using LVM snapshots be produced rather quickly :)

Andreas


Am Dienstag, den 01.04.2008, 11:26 +0200 schrieb Cyril SCETBON:
> As said Christopher Brown new commands are coming : CLONE PREPARE and 
> CLONE FINISH to bypass this mecanism
> 
> see http://lists.slony.info/pipermail/slony1-commit/2008-January/002145.html
> 
> Henry wrote:
> > Good morning all,
> >
> > I seem to recall (I think it was touched on by someone else) that this
> > aspect *might* be addressed in a near-future version of slony:
> >
> > Given that some users of slony have large (your definition of large will
> > vary, but let's say DBs in excess of 100GB) databases, and that the
> > initial replication of a DB can take weeks, would it not be a great idea
> > to have a more efficient initial 'copy' mode?  ie, either allow a user to
> > dump/restore to all slaves, then start replication from that point
> > (without truncating/copying/etc), or, build this functionality into slony
> > so it does the dump/restore, but does not then truncate all tables and
> > start from scratch?
> >
> > For smaller DBs this doesn't present a problem, but for larger DDs coupled
> > with LARGE clusters, this is a major problem.
> >
> > Regards
> > Henry
> >
> > _______________________________________________
> > Slony1-general mailing list
> > Slony1-general at lists.slony.info
> > http://lists.slony.info/mailman/listinfo/slony1-general
> >   
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Dies ist ein digital signierter Nachrichtenteil
Url : http://lists.slony.info/pipermail/slony1-general/attachments/20080401/65680202/attachment.pgp