Topics tagged postgresql

Topic	Replies	Views	Activity
Connecting postgresql database with R General rstudio , odbc , postresql	2	140	April 18, 2024
Shiny database application: correct approach to handling credentials shiny postresql	2	167	April 24, 2024
Postgresql Connection General odbc , macos , postresql	2	171	March 14, 2024
no pg_hba.conf entry for host "my-ip", user "postgres", database "db-name", no encryption General postresql	11	2571	December 26, 2023
RPostgreSQL: Connection error SCRAM authentication requires libpq version 10 or above Using PostgreSQL16 shiny shiny , database , connection , postresql	4	2277	December 10, 2023
Migration of Database from current environment to new environment Posit Connect database , postresql	0	247	September 12, 2023
Docker Compose - Shiny - Plumber - Postgresql General shiny , docker , plumber , postresql	1	424	August 1, 2023
autocomplete problem with odbc dplyr assigned table RStudio IDE dplyr , rstudio , odbc , postresql	1	541	May 6, 2023
Error Connection PostgreSQL15 General dbi , postresql	1	528	April 21, 2023
using a string object within a SQL query General sql , postresql	2	434	March 29, 2023
Unable to debug DBI::dbConnect - connection closed unexpectedly by server General database , dbi , postresql	4	935	October 16, 2022
Unable to connect PostgreSQL to R Studio Due to "R Session Aborted" Error General postresql	1	826	August 22, 2022
Determining bottleneck of collect() function for database General dplyr , odbc , dbi , postresql	2	602	July 7, 2022
Can't connect to postgresql after deploying to shinyapps.io ? shinyapps.io shiny , postresql	3	1235	February 14, 2022
Convert postGIS function General shiny , gis , postresql	2	490	December 5, 2021
Docker-ShinyApp doesn't allow to communicate with remote postgres database General shiny , docker , postresql	1	986	November 8, 2021
RStudio Connection Tab Error MacOS (Error: nanodbc/nanodbc.cpp:1021: 00000 - file not found) RStudio IDE rstudio , connection , postresql	6	6592	October 18, 2021
Trouble sending PostgreSQL query in R Studio General rstudio , postresql	4	1482	September 7, 2021
How can I update changes in a Table (rhandsontable package) to a PostgreSQL database? General shiny , rhandsontable , postresql	1	726	May 4, 2021
Create new date (week) columns the dplyr-way so that SQL can translate properly tidyverse dplyr , dbplyr , postresql	2	997	February 12, 2021
Multiple queries to posgresql database through R shiny UI input selectors shiny postresql	2	795	February 27, 2021
RPostgres query works interactively, in notebook, but will not knit Publishing Your Results postresql	4	1862	June 22, 2020
Can't connect to PostgreSQL in Rstudio, possible permissions issue? General rstudio , connection , postresql	1	984	April 21, 2020
Rpostgresql package and pg_service.conf path General database , postresql	1	666	February 10, 2020
creation of new db variables from R tidyverse database , dbplyr , postresql	2	1102	December 20, 2019
connect to postgre db through ssh tunnel by r General ssh , postresql	3	2285	October 30, 2019
Error in postgresqlExecStatement for spatial data General postresql	1	933	October 4, 2019
How to add SSL Certificate to postgresql General dbi , ssl , postresql	1	1920	September 16, 2019
change the timezone in a postgres database before filtering on the date and collecting tidyverse dplyr , dbplyr , date-time , postresql	7	2069	August 13, 2019
dbConnect with odbc does not connect to specified DSN Posit Professional & Hosted Products odbc , dbi , postresql	5	2422	August 22, 2019