Daniel Kahn Gillmor dkg at fifthhorseman.net
Sun Oct 11 12:58:40 PDT 2015
hey slony people--

http://www.slony.info/documentation/2.0/administration.html#AEN697

says:

> 3.1.4. Adding a Replication Node
> 
> To add a node to the replication cluster you should
> 
>     Create a database for the node and install your application schema in it.
> 
>     createdb -h $NEWSLAVE_HOST $SLAVEDB
>     pg_dump -h $MASTER_HOST -s $MASTERDB | psql -h $NEWSLAVE_HOST $SLAVEDB

however, this step seems like it's not quite right.

in particular, this step appears to copy the master's replication
namespace into the new replication database.  This causes the subsequent
STORE NODE command to fail with a complaint that the _$CLUSTER_NAME
schema is already present.

I think if you add -N _$CLUSTERNAME to the pg_dump side of the pipeline,
then the rest of the directions should complete OK.

Is this a bug in the documentation, or have i misunderstood something?

Regards,

   --dkg


More information about the Slony1-general mailing list