search

greenplum-db / PivotalR-archive

An convenient R tool for manipulating tables in PostgreSQL type databases and a wrapper of Apache MADlib.
https://pivotalsoftware.github.io/gp-r/
125 stars 53 forks source link

Increase maximum limit on concurrent connections #42

Closed iyerr3 closed 8 years ago

iyerr3 commented 9 years ago

Currently a single dbdriver of Rpostgresql allows 16 max connections by default. PivotalR uses this default value, leading to the below error.

"Error in postgresqlNewConnection(drv, ...) : RS-DBI driver: (cannot allocate a new connection -- maximum of 16 connections already opened)"

It would be useful to increase this since Rpostgresql has an actual limit of 100 connections.