Working with RPostgreSQL package
Error in postgresqlNewConnection(drv, ...) :
RS-DBI driver: (cannot allocate a new connection --
maximum of 16 connections already opened)
close the connection. max 16 connection can able to establish from R to PostgreSQL, if exceeds this limit, will throw error.
## Closes the connection
## Frees all the resources on the driver
dbUnloadDriver(drv) #OR on.exit(dbUnloadDriver(drv), add = TRUE)
In my case I was open up 16 connection using RPostgreSQL unfortunately forget to release them. So I ended up with Max. connection exceed limit.
I have terminating only the connection from R session which made from the (client_addr) IP 10.184.36.181