Re: proxying connections - Mailing list pgsql-general

From Federico Balbi
Subject Re: proxying connections
Date
Msg-id Pine.GSO.4.44.0409270843300.8096-100000@pandora1.cs.utsa.edu
Whole thread Raw
In response to proxying connections  (Kundham Saare <oxb1001001001@yahoo.com>)
List 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


pgsql-general by date:

Previous
From: Mike Rylander
Date:
Subject: Re: checksum
Next
From: Tom Lane
Date:
Subject: Re: could not create socket for statistics collector: Protocol not supported