I can install the package RPostgres in the RStudio app on my Macbook Air M1. However, when I tried running the example code below, I got the following message:
library(DBI)
con <- dbConnect(RPostgres::Postgres())
Error: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
I hope someone can help me with this. Thank you a lot.