Re: proxying connections

From: Federico Balbi <fbalbi(at)cs(dot)utsa(dot)edu>
To: Kundham Saare <oxb1001001001(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: proxying connections
Date: 2004-09-27 13:47:22
Message-ID: Pine.GSO.4.44.0409270843300.8096-100000@pandora1.cs.utsa.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-09-27 14:19:34 Re: could not create socket for statistics collector: Protocol not supported
Previous Message Mike Rylander 2004-09-27 12:15:08 Re: checksum