no encryption error, but equivalent python code works

[nick-youngblut]

Works:

import psycopg2
from psycopg2.extensions import connection

def db_connect() -> connection:
    db_params = {
        'host': os.environ["DB_HOST"],
        'database': os.environ["DB_NAME"],
        'user': os.environ["DB_USERNAME"],
        'password': os.environ["DB_PASSWORD"]
        'port': '5432'
    }
    return psycopg2.connect(**db_params)

The equivalent R code does not work:

db_connect = function(){
  pool::dbPool(
    RPostgres::Postgres(),
    host = config::get("DB_HOST"),
    dbname = config::get("DB_NAME"),
    user = config::get("DB_USERNAME"),
    password = Sys.getenv("DB_PASSWORD"),
    port = 5432,
    sslmode = "disable"
  )
}

The error:

Error: connection to server at "***", port 5432 failed: FATAL:  pg_hba.conf rejects connection for host "***", user "***", database "***", no encryption

Changing sslmode to any of the other possible settings does not help.

I'm using a GCP Postgresql database.

[nick-youngblut]

Note: providing sslcert and sslkey results in the same error.

I can only connect with RPostgres::Postgres() if I use cloud-sql-proxy.