> We need following information
>
> 1. Is there any configuration we do that would pool the connection request rather than coming out with connection limit exceed.
Use pgpool or pgbouncer.
Use pgbouncer, which is a light weighted connection pooling tool, if you are not opting for load balancing.
> Basically we wanted to limit the number of processes so that client code doesn't have to retry for unavailability for connection or sub processes , but postgre takes care of queuing?
For controlling unavailability of connections, it may be possible at application level but its not possible at Database level. However, if connections reaches max limit, DB will alert you as it reached max_connection.
--Raghav