Topics tagged postgresql

Topic	Replies	Views	Activity
Connecting postgresql database with R General rstudio , postgresql , odbc	2	115	April 18, 2024
no pg_hba.conf entry for host "my-ip", user "postgres", database "db-name", no encryption General postgresql	11	2242	December 26, 2023
RPostgreSQL: Connection error SCRAM authentication requires libpq version 10 or above Using PostgreSQL16 shiny shiny , database , postgresql , connection	4	2105	December 10, 2023
Docker Compose - Shiny - Plumber - Postgresql General shiny , docker , postgresql , plumber	1	404	August 1, 2023
autocomplete problem with odbc dplyr assigned table RStudio IDE dplyr , rstudio , postgresql , odbc	1	524	May 6, 2023
Error Connection PostgreSQL15 General postgresql , dbi	1	509	April 21, 2023
using a string object within a SQL query General postgresql , sql	2	423	March 29, 2023
Unable to debug DBI::dbConnect - connection closed unexpectedly by server General database , postgresql , dbi	4	900	October 16, 2022
Unable to connect PostgreSQL to R Studio Due to "R Session Aborted" Error General postgresql	1	798	August 22, 2022
Determining bottleneck of collect() function for database General dplyr , postgresql , odbc , dbi	2	558	July 7, 2022
Can't connect to postgresql after deploying to shinyapps.io ? shinyapps.io shiny , postgresql	3	1195	February 14, 2022
Convert postGIS function General shiny , postgresql , gis	2	479	December 5, 2021
Trouble sending PostgreSQL query in R Studio General rstudio , postgresql	4	1447	September 7, 2021
How can I update changes in a Table (rhandsontable package) to a PostgreSQL database? General shiny , postgresql , rhandsontable	1	677	May 4, 2021
Create new date (week) columns the dplyr-way so that SQL can translate properly tidyverse dplyr , dbplyr , postgresql	2	983	February 12, 2021
Multiple queries to posgresql database through R shiny UI input selectors shiny postgresql	2	765	February 27, 2021
RPostgres query works interactively, in notebook, but will not knit Publishing Your Results postgres , postgresql	4	1839	June 22, 2020
Can't connect to PostgreSQL in Rstudio, possible permissions issue? General rstudio , postgresql , connection	1	957	April 21, 2020
Rpostgresql package and pg_service.conf path General database , postgresql	1	657	February 10, 2020
creation of new db variables from R tidyverse database , dbplyr , postgresql	2	1079	December 20, 2019
connect to postgre db through ssh tunnel by r General postgresql , ssh	3	2189	October 30, 2019
Error in postgresqlExecStatement for spatial data General postgresql	1	904	October 4, 2019
How to add SSL Certificate to postgresql General postgres , postgresql , dbi , ssl	1	1898	September 16, 2019
change the timezone in a postgres database before filtering on the date and collecting tidyverse dplyr , dbplyr , postgresql , date-time	7	2003	August 13, 2019
dbConnect with odbc does not connect to specified DSN Posit Professional & Hosted Products postgresql , odbc , dbi	5	2382	August 22, 2019
Convert tz in postgres with dbplyr tidyverse dplyr , dbplyr , postgres , postgresql , date-time	5	2621	May 25, 2019
RStudio 1.2 Connections Pane Error (nanodbc) RStudio IDE bug , postgresql , ide-error	4	1608	May 20, 2019
Building CRUD with Shiny shiny shiny , postgresql	13	15037	April 4, 2019
Automatically reconnecting to PostgreSQL database Posit Professional & Hosted Products dbplyr , postgres , postgresql , dbi , pool	3	5854	April 1, 2019
Query using DSN to connect to PostgreSQL from R is failing General postgresql	5	1718	March 6, 2019