"Dean Liu" <deanliu at gmail.com> writes:
> 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".
>
> Any ideas?  I apologize if this has been answered before - I attempted
> to scour google for answers and apparently a few have come across the
> same problem however have received no answers.
>
> Please let me know if you need any more information.

That adds a new message to loganalysis.sgml...

The problem is that the node isn't aware of the would-be subscriber.

Chances are that a STORE PATH request has not made it through.  Why is
not quite clear...

Take a look at sl_node, on both nodes, and sl_path, on both nodes.  I
think you'll find a difference between them.

Strong suggestion #1: Run test_slony_state.pl (if you prefer to use
the Perl "Pg" module) or run_test_slony_state-dbi.pl (if you prefer
Perl DBI).

   http://www.slony.info/documentation/monitoring.html

When you point the test script at one of the nodes, it'll try to look
up all of the nodes, and looks for problems, and reports findings.
Those findings are quite likely to be useful in diagnosing what is
going on.

Suggestion #2: Take a look at the logs for both slon processes; any
errors that they are reporting should be helpful in figuring out
what's going wrong.
-- 
"cbbrowne","@","cbbrowne.com"
http://www3.sympatico.ca/cbbrowne/wp.html
To err is human, to moo bovine.