On Tue, 2007-01-09 at 16:47 +0100, Largo Stemper wrote: > > Hi everybody and HAPPY NEW YEAR > > > I wanna know why are some of my functions not replicated like the rest of my > database. > > I used to replicate my DB from my Master to my slave using the slonik > commands and SLON. > > I see that everything was replicated except "SOME" of my functions , not > all. I did test lot of scenarios but nothing works. > > So please : > > - What are the conditions that prevents a funcitons from being replicated ?
Slony uses triggers to replicate data. You can't define a trigger on a function. > - The replication is running : Can I see my functions on my slave if I > create them on the master with the psql-Client and (/i myFunction.sql) ? What you want to do is create the functions via psql on all of the databases that you are replicating. > - Even EXECUTE SCRIPT on the slonik script did not help, it creates my > function only on the master, what is if I have a Failover ?? Did you execute the script only on the master? Did you get any errors in your slon log, or in the postgres logs on the subscriber? > - Is it the same for TRIGGERs Sort of. Triggers won't be replicated. When you add them, you need to do it with a slonik EXECUTE script. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
