[R] RPostgreSQL && snowfall

Florian Endel florian at endel.at
Mon Jun 6 18:40:46 CEST 2011


Dear expeRts,

I'm currently trying to get data from a PostgreSQL database _in parallel_.
I tried two methods:
* passing the DBI Connection object to the cluster nodes
* connecting the the DB on each node

(1)
The execution of the first method looks like this:
> result = sfClusterApplyLB(input, fun, dbiCon)
and produces an "expired PostgreSQLConnection" error.
(Of course the passed Connection Object is usable at that moment and
afterwards!)

(2)
For the creation of DB connections on every node a function handling
the whole connection is sourced into every node.
This function works perfectly without snowfall.
Calling it with
> sfClusterEval(dbConnect())
again only expired connection objects are produced. Even if I create
the connection 'a line above' the code which is connecting to the DB
it doesn't work...


Is there a possibility to connect to PostgreSQL using snowfall?

--
with kind regards
Florian



More information about the R-help mailing list