r-dbi / r-dbi/RPostgres

I'm trying to connect to a Neon DB hosted behind a Replit deployment, result: "Error:"

Open
#476 3 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
R
Stars
343
Forks
82
Avg merge
11h 26m
Merged PRs (30d)
9

Description

I don't know how to produce a reprex without username and password...

I'm running the code below, and it's outputting the word "Error:"
No explanation.

Version 1.4.7

conn <- dbConnect(Postgres()
+                   , host=myhost
+                   , port=5432
+                   , dbname='neondb'
+                   , user='neondb_owner'
+                   , password=pw)
Error:

When I tried using PostgreSQL(), I got the error:
"RPosgreSQL error: could not connect neondb_owner@myhost:5432 on dbname "neondb": ERROR: connection is insecure (try using sslmode=require)"

This kept happening no matter how I attempted to manage the sslmode issue. Which is why I tried Postgres()

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

No source file or test is identified. Start by reproducing the dbConnect(Postgres()) call using the reported version, connection parameters, and SSL behavior, then compare it with the PostgreSQL() attempt; done would require a clear diagnostic or a documented, reproducible connection configuration.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, r
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.