Fri Apr 22 14:36:08 PDT 2005
- Previous message: [Slony1-general] Possible SLAVE to MASTER copy solution with Slony?
- Next message: [Slony1-general] need node 1?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On N, 2005-04-21 at 16:59 +0300, Andrei Bintintan wrote: > Hi to all, > > I'm digging hard to replicate postgre database with slony. I succeded > do replicate some examples, but I'm facing some questions: in my > scenario I have to replicate some tables (for ex: table1, > table2 ...table10). > > But on the slave machine I have to be able to write some data in the > table1 and table2. The other tables can remain readonly. > If you need only to do inserts in table1 , you could make a subtable for table1: create table table1_writable() inherits(table1); and insert your data there. then doing "select * from table1" will retrieve from both; -- Hannu Krosing <hannu at skype.net>
- Previous message: [Slony1-general] Possible SLAVE to MASTER copy solution with Slony?
- Next message: [Slony1-general] need node 1?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list