Re: [Postgres-xc-general] PG-XC node addition

[Koichi S. <koi...@gm...>]

Thanks for the question.

With XC-1.0.x, we cannot add a node at runtime.   This feature is
included in the current development and will be available with the
next major release.

The safest way is to backup the whole database with pg_dump,
reinitialize all the nodes including the additional ones, configure
the cluster (CREATE NODE and ALTER NODE) and then restore the data
with pg_restore.   You may need to create each table in advance so
that it can be distributed/replicated among all the nodes.

New feature of node addition will include:
1) Create new coordinators and datanodes on new servers at runtime,
which copies all the necessary catalog such as role, database, etc.,
from existing components,
2) Add them to the cluster,
3) Reballance tables with new components.

It's very helpful if you submit your requirement for this feature.

Regards;
----------
Koichi Suzuki


2012/9/6 "Marco Güttler" <mar...@gm...>:
> Hey all,
>
> I have a question concerning node addition (coordinator and datanode) at runtime. Is it possible to add a node at runtime? If so, how to do node addition?
> If not so, what is an alternative way to add a coordinator and datanode?
>
> Thanks and regards
> Marco
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general