Hannu Krosing hannu
Mon Apr 4 14:27:26 PDT 2005
On P, 2005-04-03 at 22:55 -0400, Christopher Browne wrote:
> "Garry Saddington" <garry at schoolteachers.co.uk> writes:
> > Hello, I am new to this list and to Slony so excuse me if I ask
> > simple questions. I was wondering if there is a way to specify an
> > entire database to replicate rather than having to list each table
> > specifically.
> 
> No, not as such.
...
> What I find is that in systems that warrant replication, there will be
> tables that oughtn't be replicated so that blindly replicating
> everything turns out badly.

The main (only ?) use of blindly replicating whole databasse is for
having a standby database to be used in case of failure on master.

For this, one could use the WAL-shipping replication mode available in
postgresql itself starting from version 8.0.

This should work well together with slony. 

-- 
Hannu Krosing <hannu at skype.net>



More information about the Slony1-general mailing list