Message-ID: <BANLkTi=jehjJWA0SETaYHDuvncLsey8gUg@mail.gmail.com>
Date: 2011-06-06T16:40:46Z
From: Florian Endel
Subject: RPostgreSQL && snowfall
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