On 9/16/2008 2:05 PM, Dean Liu wrote:
> Hello all,
> 
> I am following this guide to set up a simple master - slave
> relationship between two postgres databases:
> http://www.onlamp.com/pub/a/onlamp/2004/12/16/slony_install.html
> 
> The only main differences is that I'm using two VMs instead of using
> two different postgres instances listening on different ports.
> 
> Everything is working great except that it seems when I attempt to
> issue the subscribe set command I get an error:  "insert or update on
> table "sl_path" violates foreign key constraint "pa_client-no_id-ref".
> DETAIL: Key (pa_client)=(2) is not present on table "s1_node".

This happens if you forget to start the two slon processes after doing 
the STORE PATH slonik commands. The two STORE_PATH events need to 
replicate before you can actually issue the SUBSCRIBE.


Jan

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