I think what you need to do is connect to your Postgres via OBDC doing something like this:
db_connect <- function(){
DBI::dbConnect(odbc::odbc(),
Driver = "PostgreSQL",
servername = "your_server",
database = "dev",
UID = keyringr::get_kc_account('redshift'),
PWD = keyringr::decrypt_kc_pw('redshift'),
Port = 5439)
}
Youll also want to make sure you have the correct odbc drivers installed on your machine in advance. Which you can get more information about here: https://db.rstudio.com/databases/postgresql ... although this page kind of implies that what you are doing sould work, unless i'm missreading it?