r-dbi / r-dbi/RPostgres

pgpass not used?

Open
#527 1 comment 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

The documentation states that if certain arguments are NULL, a .pgpass or pgpass.conf file will be used to get the username and password. However I don't seem to be able to make this work, even when explicitly setting the passfile argument when making the connection.

R can definitely find the file just fine, and I suppose I could resort to manually loading the file. However I am unsure as to why this seems to fail.

I have other clients on the same system that use the pgpass method of authentication with no trouble.

Is this a bug, or am I missing something?

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

Start by reading the connection documentation covering NULL arguments and the passfile argument, then reproduce the issue with a PostgreSQL connection and an explicitly selected .pgpass or pgpass.conf file. Compare the observed behavior with the documented behavior and with other clients on the same system; done means identifying whether this is a bug or a documentation or configuration issue.

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
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.