Installing RPostgres Library in Jupyter Notebook on Google Cloud Platform
I am trying to install the RPostgres library in R but I am using JupyterLab on Google Cloud Platform. I have found several suggestions on github.com/r-dbi/RPostgres, but none of them include information when working with Google Cloud Notebooks.
I continue to receive the error that RPostgres had "non-zero exit status" even after trying to install the package from the source code after placing it into the correct folder on JupyterLab:
install.packages("MyPath/RPostgres_1.3.3.tar.gz", repos=NULL, type='source')
I receive the same error message RPostgres had "non-zero exit status". Thanks.
To fix this, you first need to install "libpq-dev" as this is a prerequisite as per SO answer. Follow the steps below to apply this in a Google Cloud Notebook.
Open a terminal in your JupyterLab and execute
sudo apt-get install libpq-dev
Open a R notebook, install Rpostgres using
install.packages("RPostgres")
Run
library()and check if it was installed properly
Please take note that the machine I used for testing is created in AI Platform -> Notebooks -> R instance.
- rlanguageserver: Disable specific linter and avoid line-breaking
- Replace truncated word in a string
- Add label to right y axis in R ggplot
- Popup offset without using markers
- Multi marker depending a variable in a data frame
- Drawing numerous polygons
- Select icons or CircleMarkers based on factor variable
- Why is a map not displayed when I call leaflet in a function
- Display SpatialPolygonsDataFrame on leaflet map
- Leaflet in R not showing variable circle colors
- Overlay two population pyramid plots in one ggplot graph
- How to most efficiently filter a dataframe conditionally of values in another one, in the tidyverse framework?
- R group_by multiple conditionnal aggregation functions dplyr
- Conditionally split strings cells in a dataframe R
- How to have Shiny app render multiple plots
- Disable Shiny button conditionally to a rHandsontable format
- Is there a way to render dynamic headings in Quarto using R?
- What is the time complexity of sample?
- Add geom_text with x bar and round values
- Color-fill ggplot2 maps with a single color
- lapply a ggplot function on multiple inputs with consistent groups
- Is there a way to save text in R without it actively implementing \n?
- How to get number of unique observations using tbl_summary
- Using if_else in a mutate command yields an error about false having the wrong size
- Rotate x-axis value in dendogram using fviz_dend
- Export data frames in list to xlsx with named sheets
- Query all primary roads from PostGis Database filled with OSM Data within a boundary
- Write a list in r to an excel file
- Calculating net assets with missing values: discrepancy in results
- Error in curl::curl_fetch_memory(url, handle = handle) : Couldn't connect to server in R: oauth2.0_token())