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

[Mephysto <mep...@gm...>]

Hi Koichi,
this feature could be very helpful for me too. Is there a forecast for
release date of next major release of postgres XC?

Thanks in advance.

Mephysto

On 6 September 2012 12:00, Koichi Suzuki <koi...@gm...> wrote:

> 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
>
>
> ------------------------------------------------------------------------------
> 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
>