Jaime Casanova jaime at 2ndquadrant.com
Thu Oct 29 12:58:14 PDT 2015
On 11 October 2015 at 14:58, Daniel Kahn Gillmor <dkg at fifthhorseman.net> wrote:
> 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?
>

looks like a bug in documentation, yes

-- 
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación


More information about the Slony1-general mailing list