Fermer correctement la connexion à PostgreSQL

Gérer correctement la fermeture de la connexion à PostgreSQL de manière à éviter de rencontrer l'erreur suivante dans RStudio :

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

added 1 deleted label

assigned to @ronan.vignard

By Ronan Vignard on 2020-09-07T13:00:16 (imported from GitLab)

added Bug label

changed the description

By Ronan Vignard on 2020-09-07T13:01:35 (imported from GitLab)

changed due date to December 25, 2020

By Ronan Vignard on 2020-09-11T06:38:01 (imported from GitLab)

removed due date

By Ronan Vignard on 2020-09-11T06:38:07 (imported from GitLab)

changed due date to December 18, 2020

By Ronan Vignard on 2020-09-11T06:38:09 (imported from GitLab)

changed due date to January 31, 2021

By Ronan Vignard on 2020-12-03T15:51:48 (imported from GitLab)

removed 1 deleted label

Piste :

library(RPostgreSQL)

close_unused_connections <- function() {
  # Obtient la liste des connexions actives
  connections <- dbListConnections(PostgreSQL())

  # Parcoure les connexions et ferme celles qui sont inutilisées
  for (conn in connections) {
    # Vérifiez ici si la connexion est inutilisée selon vos critères
    # Fermez la connexion si nécessaire
    dbDisconnect(conn)
  }
}