Topics tagged postgresql

Topic	Replies	Views	Activity
Connecting postgresql database with R General rstudio , postgresql , odbc	2	113	April 18, 2024
no pg_hba.conf entry for host "my-ip", user "postgres", database "db-name", no encryption General postgresql	11	2192	December 26, 2023
RPostgreSQL: Connection error SCRAM authentication requires libpq version 10 or above Using PostgreSQL16 shiny shiny , database , postgresql , connection	4	2076	December 10, 2023
Docker Compose - Shiny - Plumber - Postgresql General shiny , docker , postgresql , plumber	1	403	August 1, 2023
autocomplete problem with odbc dplyr assigned table RStudio IDE dplyr , rstudio , postgresql , odbc	1	521	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	420	March 29, 2023
Unable to debug DBI::dbConnect - connection closed unexpectedly by server General database , postgresql , dbi	4	892	October 16, 2022
Unable to connect PostgreSQL to R Studio Due to "R Session Aborted" Error General postgresql	1	795	August 22, 2022
Determining bottleneck of collect() function for database General dplyr , postgresql , odbc , dbi	2	557	July 7, 2022
Can't connect to postgresql after deploying to shinyapps.io ? shinyapps.io shiny , postgresql	3	1194	February 14, 2022
Convert postGIS function General shiny , postgresql , gis	2	478	December 5, 2021
Trouble sending PostgreSQL query in R Studio General rstudio , postgresql	4	1440	September 7, 2021
How can I update changes in a Table (rhandsontable package) to a PostgreSQL database? General shiny , postgresql , rhandsontable	1	672	May 4, 2021
Create new date (week) columns the dplyr-way so that SQL can translate properly tidyverse dplyr , dbplyr , postgresql	2	982	February 12, 2021
Multiple queries to posgresql database through R shiny UI input selectors shiny postgresql	2	764	February 27, 2021
RPostgres query works interactively, in notebook, but will not knit Publishing Your Results postgres , postgresql	4	1837	June 22, 2020
Can't connect to PostgreSQL in Rstudio, possible permissions issue? General rstudio , postgresql , connection	1	953	April 21, 2020
Rpostgresql package and pg_service.conf path General database , postgresql	1	656	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	2180	October 30, 2019
Error in postgresqlExecStatement for spatial data General postgresql	1	902	October 4, 2019
How to add SSL Certificate to postgresql General postgres , postgresql , dbi , ssl	1	1896	September 16, 2019
change the timezone in a postgres database before filtering on the date and collecting tidyverse dplyr , dbplyr , postgresql , date-time	7	2000	August 13, 2019
dbConnect with odbc does not connect to specified DSN Posit Professional & Hosted Products postgresql , odbc , dbi	5	2373	August 22, 2019
Convert tz in postgres with dbplyr tidyverse dplyr , dbplyr , postgres , postgresql , date-time	5	2609	May 25, 2019
RStudio 1.2 Connections Pane Error (nanodbc) RStudio IDE bug , postgresql , ide-error	4	1603	May 20, 2019
Building CRUD with Shiny shiny shiny , postgresql	13	15021	April 4, 2019
Automatically reconnecting to PostgreSQL database Posit Professional & Hosted Products dbplyr , postgres , postgresql , dbi , pool	3	5843	April 1, 2019
Query using DSN to connect to PostgreSQL from R is failing General postgresql	5	1710	March 6, 2019