| 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: | Whole Thread | Raw Message | 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
| 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 |