Re: [Postgres-xc-general] is it possible to connect a (postgresql) data node server directly (not using coordiantor)

[Ashutosh B. <ash...@en...>]

Aris,
Ideally you shouldn't need to execute queries against datanode (except for
say debugging purpose). The distribute execution of the query is
responsibility of the coordinator. The application need not think about it.

Can you please provide an example of the query and why do you need to
connect to the datanode?

On Sat, Jun 30, 2012 at 1:27 PM, Koichi Suzuki <koi...@gm...>wrote:

> Safer way is to use EXECUTE DIRECT.   It is physically possible to
> connect psql to datanode directly but because transactions are not
> controlled by GTM in this case, you cannot guarantee the visibility
> and the data integrity.
>
> Regards;
> ----------
> Koichi Suzuki
>
>
> 2012/6/30 Aris Setyawan <ari...@gm...>:
> > Hi,
> >
> > I have use a case that need to (manually using gearman) split a
> > postgre recursive query to a numbers of replication node, to execute
> > it faster.
> >
> > Since I will use postgre-xc cluster, is it possible to connect a
> > (postgresql) data node server (a relpica in my case above) directly
> > (not using coordiantor)?
> >
> > thank's.
> >
> >
> ------------------------------------------------------------------------------
> > 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
>



-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Enterprise Postgres Company