Enable Connection to pgvecto.rs Instance via DBI (R)

[henningsway]

Hey there!

I really like to use d(b)plyr and ggplot2 for exploring the content of a database. Typically in R with Postgres, the connection is set up as described here: https://github.com/r-dbi/RPostgres?tab=readme-ov-file#connecting-to-a-specific-postgres-instance

library(DBI)
# Connect to a specific postgres database i.e. Heroku
con <- dbConnect(RPostgres::Postgres(),dbname = 'DATABASE_NAME', 
                 host = 'HOST', # i.e. 'ec2-54-83-201-96.compute-1.amazonaws.com'
                 port = 5432, # or any other port specified by your DBA
                 user = 'USERNAME',
                 password = 'PASSWORD')

When I adjust the credentials for a pgvecto.rs-instance the process times out, but no connection is set up.

One reason, why I'm interested in this connection is this kind of functionality: https://dbplyr.tidyverse.org/articles/dbplyr.html

[henningsway]

Apparently (thanks!) the ssl should be required as explained in https://stackoverflow.com/a/60282693