pgcli couldn't parse password that contained character '#'
- 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
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