postgresql and load balancing

Hi everybody,

I've installed OpenSSI on a Debian 5 system together with postgresql. 
I'm able to migrate the postgresql server to a second node, but only all 
processes together. Running the postgresql benchmark pgbench all created 
postgresql processes also run on that node. If I try to migrate one of 
these worker processes to another node using

echo 2 > /proc/68240/goto

the process is migrated but the benchmark crashes with different 
messages, e.g.:

Client 3 aborted in state 11: FATAL:  semop(id=491526) failed: 
Bezeichner wurde entfernt

or

Client 2 aborted in state 8: FEHLER:  lock RowExclusiveLock on object 
16384/16391/0 is already held

Did anybody have success load balancing postgresql?

Best regards,
Oliver

-- 

Dipl.-Inf. Oliver Urbann
Robotics Research Institute
Section Information Technology
TU Dortmund University
44221 Dortmund, Germany
mailto:[email protected]
http://www.it.irf.tu-dortmund.de
Phone: +49 231 755 6165
Fax: +49 231 755 3251


------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb