Re: [Postgres-xc-general] Exclude some tables to get sync while adding new coordinator and datanode

[Juned K. <jkh...@gm...>]

Ohh i see i think i read the same earlier but still i can see data in newly
created node.

myDB=# select count(*) from accounts;
 count
-------
    79
(1 row)

And all datanode has same records, so i wonder from where data comes from
? is it synced automatically ?




On Thu, Apr 17, 2014 at 1:53 PM, 鈴木 幸市 <ko...@in...> wrote:

>  While adding a coordinator or a datanode, only catalogs are copied.   You
> should issue ALTER TABLE to each table to redistribute table rows.
> If you don’t want new datanode to be invoked in some tables, you can skip
> ALTER TABLE.   Table rows will be distributed in the old set of
> datanodes.
>
>  If you do it manually, it’s long process and there could be many
> pitfalls.   Hope pgxc_ctl helps.
>
>  Regards;
> ---
> Koichi Suzuki
>
>  2014/04/17 16:49、Juned Khan <jkh...@gm...> のメール：
>
>    Hi All,
>
>  I want to add few more coordinator and datnode in pgxc. during adding
> process whole database is being copy to new component.
>
>  I have very large database around 8GB, in this database only one table is
> there which holds the large number of records.
>
>  is there anyway to exclude such table while adding new coordinator or
> datanode using pgxc_ctl command ?
>
>  I want to exclude some table just to make adding coordinator and datanode
> process smother and faster.
>
>  Please suggest.
>
> --
> Thanks,
> Juned Khan
>  <http://www.inextrix.com/>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech_______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>
>


-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com