Topics tagged postgresql

Topic	Replies	Views	Activity
Connecting postgresql database with R General rstudio , postgresql , odbc	2	118	April 18, 2024
no pg_hba.conf entry for host "my-ip", user "postgres", database "db-name", no encryption General postgresql	11	2350	December 26, 2023
RPostgreSQL: Connection error SCRAM authentication requires libpq version 10 or above Using PostgreSQL16 shiny shiny , database , postgresql , connection	4	2159	December 10, 2023
Docker Compose - Shiny - Plumber - Postgresql General shiny , docker , postgresql , plumber	1	414	August 1, 2023
autocomplete problem with odbc dplyr assigned table RStudio IDE dplyr , rstudio , postgresql , odbc	1	527	May 6, 2023
Error Connection PostgreSQL15 General postgresql , dbi	1	514	April 21, 2023
using a string object within a SQL query General postgresql , sql	2	426	March 29, 2023
Unable to debug DBI::dbConnect - connection closed unexpectedly by server General database , postgresql , dbi	4	908	October 16, 2022
Unable to connect PostgreSQL to R Studio Due to "R Session Aborted" Error General postgresql	1	808	August 22, 2022
Determining bottleneck of collect() function for database General dplyr , postgresql , odbc , dbi	2	570	July 7, 2022
Can't connect to postgresql after deploying to shinyapps.io ? shinyapps.io shiny , postgresql	3	1206	February 14, 2022
Convert postGIS function General shiny , postgresql , gis	2	484	December 5, 2021
Trouble sending PostgreSQL query in R Studio General rstudio , postgresql	4	1461	September 7, 2021
How can I update changes in a Table (rhandsontable package) to a PostgreSQL database? General shiny , postgresql , rhandsontable	1	688	May 4, 2021
Create new date (week) columns the dplyr-way so that SQL can translate properly tidyverse dplyr , dbplyr , postgresql	2	990	February 12, 2021
Multiple queries to posgresql database through R shiny UI input selectors shiny postgresql	2	784	February 27, 2021
RPostgres query works interactively, in notebook, but will not knit Publishing Your Results postgres , postgresql	4	1845	June 22, 2020
Can't connect to PostgreSQL in Rstudio, possible permissions issue? General rstudio , postgresql , connection	1	964	April 21, 2020
Rpostgresql package and pg_service.conf path General database , postgresql	1	661	February 10, 2020
creation of new db variables from R tidyverse database , dbplyr , postgresql	2	1085	December 20, 2019
connect to postgre db through ssh tunnel by r General postgresql , ssh	3	2229	October 30, 2019
Error in postgresqlExecStatement for spatial data General postgresql	1	915	October 4, 2019
How to add SSL Certificate to postgresql General postgres , postgresql , dbi , ssl	1	1906	September 16, 2019
change the timezone in a postgres database before filtering on the date and collecting tidyverse dplyr , dbplyr , postgresql , date-time	7	2023	August 13, 2019
dbConnect with odbc does not connect to specified DSN Posit Professional & Hosted Products postgresql , odbc , dbi	5	2396	August 22, 2019
Convert tz in postgres with dbplyr tidyverse dplyr , dbplyr , postgres , postgresql , date-time	5	2644	May 25, 2019
RStudio 1.2 Connections Pane Error (nanodbc) RStudio IDE bug , postgresql , ide-error	4	1614	May 20, 2019
Building CRUD with Shiny shiny shiny , postgresql	13	15068	April 4, 2019
Automatically reconnecting to PostgreSQL database Posit Professional & Hosted Products dbplyr , postgres , postgresql , dbi , pool	3	5884	April 1, 2019
Query using DSN to connect to PostgreSQL from R is failing General postgresql	5	1729	March 6, 2019