> I am trying to develop a proxy for postgresql that
> will distribute the load between multiple postgresql
> database servers and have so far failed to even get a
> connection.
> What I am trying to do is to create a TCP socket
> server and a client and forward all requests coming
> into the server through the client and vice versa.
In the past I wrote a similar thing in C to forward TCP requests.
I think you have to use either fork() or threads in order to keep on
listening on connection while you serve others. I used fork() at the time
but I would use threads nowadays. Anyway, after I saw the rising of all
these replication mechanism I wonder if such utility would be still
necessary.
Ciao,
Federico