dbcli / dbcli/pgcli

pgcli couldn't parse password that contained character '#'

Open
#1,512 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
13.4k
Forks
612
Avg merge
6d 14h
Merged PRs (30d)
10

Description

I have a section that contains character '#' in ~/.pg_service.conf, like
```
[staging_instance]
host=XXXX
port=5432
dbname=postgres
user=root
password=abc#123
```

using psql could login successfully
```
~# psql service=staging_instance
psql (13.20, server 15.12)
WARNING: psql major version 13, server major version 15.
Some psql features might not work.
Type "help" for help.

postgres=>
```

but using pgcli still prompt input password
```
~# pgcli service=staging_instance
Password for root:
```

How could solve this?

Contributor guide

Open the contributing guide

Research direction

Reproduce the issue with the shown ~/.pg_service.conf entry and the `pgcli service=staging_instance` command, then compare its password parsing with the successful `psql service=staging_instance` path. Done means a password containing `#` is read from the service file and pgcli connects without prompting.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
cli, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.