Christopher Browne cbbrowne at ca.afilias.info
Fri Jun 27 12:40:03 PDT 2008
"Alexander Staubo" <alex at bengler.no> writes:
> Am I correct in thinking that there are cases where you don't need to
> set up replication of sequences at all?
>
> For example, if you're setting up Slony slaves for the sole purpose of
> off-loading read-only queries from the master *and* you only ever use
> sequences in conjunction with "serial" columns, then sequences on the
> slaves are irrelevant and could be ignored altogether.

If you never care about failover or moving the "master" role around,
then you're correct, there is no real need to replicate sequences.
-- 
(reverse (concatenate 'string "ofni.secnanifxunil" "@" "enworbbc"))
http://linuxfinances.info/info/x.html
"Absolutely nothing should be concluded from these figures except that
no  conclusion can be  drawn from  them."  
-- By Joseph L. Brothers, Linux/PowerPC Project


More information about the Slony1-general mailing list