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 <kapilbhadke at gmail.com
> <mailto:kapilbhadke at gmail.com>> 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
>     Slony1-general at lists.slony.info <mailto:Slony1-general at lists.slony.info>
>     http://lists.slony.info/mailman/listinfo/slony1-general
> 
> 
> 
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
> 


-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin