On 05/09/13 20:31, Vick Khera wrote: > I'm pretty sure slonik will just block until it is reachable. Try not to > do that. This may be different in slony 2.0+, but I haven't tested.
Unless there is an implicit or explicit WAIT FOR EVENT done my slonik, nothing should block. EXECUTE SCRIPT in all versions prior to 2.2 creates an event, containing the SQL. In 2.2 the SQL is injected into the data stream processed during SYNC application to make it work reliable with concurrent table access. Jan > > > > On Tue, May 7, 2013 at 6:54 AM, kapil bhadke <[email protected] > <mailto:[email protected]>> wrote: > > I am using slony for replicating my pgsql database. I want to > propagate the database schema changes(DDL) from master to the slave > machine with the help of slonik execute script. I am curious to know > what happens when I run slonik execute script(on master) and slave > machine is not reachable. How will these schema changes get > reflected on slave machine? > > _______________________________________________ > Slony1-general mailing list > [email protected] <mailto:[email protected]> > http://lists.slony.info/mailman/listinfo/slony1-general > > > > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general > -- Anyone who trades liberty for security deserves neither liberty nor security. -- Benjamin Franklin _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
