Jan Wieck JanWieck at Yahoo.com
Thu Jul 5 19:41:09 PDT 2012
On 7/4/2012 3:39 PM, Vick Khera wrote:
> On Mon, Jul 2, 2012 at 3:29 PM, Wolf Schwurack <wolf at uen.org
> <mailto:wolf at uen.org>> wrote:
>
>     You can not run DDL statement using slony, it states that in slony docs
>
>
> Where? That's the only safe way to perform DDL on a replicated table.

In 1.x yes. Since 2.0 DDL can be done directly with psql or by other 
means. If doing so, one needs to be careful which modifications are done 
to which nodes in which order so that inserts/updates aren't coming into 
a node with columns or things like that. But Slony by itself won't stand 
in the way any more.


Jan

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




More information about the Slony1-general mailing list