On 8/30/2007 2:38 PM, Benezra, Eric wrote: > I am running Slony version 1.2.10 so I don't have to specify the listen > paths (even though I did anyway). > > The table I am trying to replicate still didn't work this way. However, > as soon as I created a blank table of the same name with the same > columns on the slave database, the data replicated over. Is this how > it's supposed to work (create blank tables and let Slony replicate the > info in those tables?) or should it be replicating the whole table > straight to the slave?
Slony does not do any automagic schema duplication. As a matter of fact, you aren't supposed to perform DDL except through EXECUTE SCRIPT, since it is dangerous to do that while the Postgres system catalog is in a corrupted state. > Sorry if that sounded confusing. Sounds less confusing than alarming, actually. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] # _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
