[SSI-users] postgresql and load balancing

[Oliver U. <oli...@tu...>]

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:Oli...@tu...
http://www.it.irf.tu-dortmund.de
Phone: +49 231 755 6165
Fax: +49 231 755 3251