-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ow Mun Heng a écrit :
> Hi,
> 
> My Slony Master daemon died and for some reason, the slave died along
> with it and that was over 4 days ago.
> 
> I read back the archives and found that it really _isn't_ a problem (if
> my hardware can handle it) [which I know it can't really]
> 
> select * from _hmxmms_my_cluster.sl_event order by ev_timestamp asc
> limit 2;
> -[ RECORD
> 1 ]+------------------------------------------------------------------------------------------------------------------------------------
> ev_origin    | 1
> ev_seqno     | 2463502
> ev_timestamp | 2008-10-06 00:23:59.276714
> ev_minxid    | 73888983
> ev_maxxid    | 73906072
> ev_xip       |
> '73891993','73891292','73888983','73897065','73892567','73895703','73893260','73895669','73891049','73891575','73891928','73892147'
> ev_type      | SYNC
> -[ RECORD
> 2 ]+------------------------------------------------------------------------------------------------------------------------------------
> ev_origin    | 1
> ev_seqno     | 2463503
> ev_timestamp | 2008-10-10 10:32:21.038801
> ev_minxid    | 74959838
> ev_maxxid    | 74959839
> ev_xip       |
> ev_type      | SYNC
> 
> 
> So, the question now is, is there anything I can do to break up the sync
> into a few more, more manageable qty? I'm not sure if it can sync up
> 9million rows in 1 BIG SYNC.
> 
> Is there any way I can eg: sync it manually? meaning, remove the
> triggers from the slave and then copy the data over and then restart
> slony?
> 

33 sync events late is not really a big deal. As both replication daemons were
stopped, there may not be any Sync produced since then.

What's more annoying is that you may have add/updated 9 millions rows in one
single transaction. That could lead in a real long time synchronisation. But,
Slony can really well handle it. All you have to do is restart both daemons and
wait...

Regards,
- --
Stéphane Schildknecht
PostgreSQLFr : http://www.postgresql.fr

Venez nous rencontrer le 4 octobre lors du plus important événement
PostgreSQL francophone : http://www.pgday.fr

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFI7xkZA+REPKWGI0ERAhr8AKCn2ZSD/a6WK8Cl09LU7/TRuLRO8gCeLnRA
AZQZR/XK4muQFXggF+27Its=
=KH+2
-----END PGP SIGNATURE-----