On Fri, May 9, 2008 at 5:31 PM, Martin Marques
<martin at marquesminen.com.ar> wrote:
> Doing the steps in http://slony.info/documentation/firstdb.html in the
> section "Using the altperl scripts" I found what I think are doc errors:
>
> $ slonik_create_set 1
>
> This line above should be, AFAICS:
>
> $ slonik_create_set 1 | slonik

Yep, it should.

> And:
>
> $ slonik_subscribe_set  2 | slonik
>
> is missing one parameter for slonik_subscribe_set, so it should be
> something like:
>
> $ slonik_subscribe_set  1 2 | slonik

Yep, that, too. One of the slony devs will hopefully fix that soon. :-)

> The other problems, and which are the things that make me think I may
> have done something wrong is that the nodes, master and slaves, DB have
> quite a good amount of load, mostly rolled-back slony transactions. It
> doesn't bloat the server, but I was interested in knowing if all those
> queries are right.

It kind of sounds like the subscription isn't succeeding and slony is
just copying data to node 2, failing, and retrying. Are you sure that
replication is working? What do the slony logs say?

> Also, but maybe for someone else, the init script /etc/init.d/slony1
> doesn't work right (I have to slon_start the nodes my hand one by one).

Are you running slony repackaged from Debian or built from source? If
the former, you should probably file a bug with Debian.

-Dave