Mon Apr 4 14:27:26 PDT 2005
- Previous message: [Slony1-general] replicating entire database
- Next message: [Slony1-general] Execution Plan Problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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>
- Previous message: [Slony1-general] replicating entire database
- Next message: [Slony1-general] Execution Plan Problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list