pgcli
pgcli copied to clipboard
alias dsn is not detected
Description
I edited pgclirc file and added a new alias_dsn. However, when I run pgcli --list-dsn it doesn't return anything.
this is from my config file:
[alias_dsn]
pg = postgresql://user:pass@localhost:1234
Using pgcli -D <alias> doesn't work either:
Could not find a DSN with alias pg. Please check the "[alias_dsn]" section in pgclirc.
To see if config file is being read, I added a random thing inside it and it threw an error (so it is okay):
[alias_dsn]
pg = postgresql://user:pass@localhost:1234
bbb
Traceback (most recent call last):
...
...
configobj.ParseError: Invalid line ('bbb') (matched as neither section nor keyword) at line 237.
I also tried restarting terminal, using another shell, and restarting system; but none of them worked.
Your environment
- Windows 11 22631.4602
- pgcli 4.1.0
- pipfreeze output:
aioboto3==12.4.0
aiobotocore==2.12.3
aiohttp==3.9.5
aioitertools==0.11.0
aiosignal==1.3.1
ansicon==1.89.0
anyio==4.3.0
appdirs==1.4.4
argon2-cffi==23.1.0
argon2-cffi-bindings==21.2.0
arrow==1.3.0
asttokens==2.4.1
async-lru==2.0.4
attrs==23.2.0
Babel==2.14.0
beautifulsoup4==4.12.3
bleach==6.1.0
blessed==1.20.0
blessings==1.7
boto3==1.34.69
botocore==1.34.69
bottle==0.12.25
bottle-websocket==0.2.9
certifi==2024.2.2
cffi==1.16.0
chardet==5.2.0
charset-normalizer==3.3.2
cli_helpers==2.3.1
click==8.1.7
colorama==0.4.6
comm==0.2.2
configobj==5.0.9
contourpy==1.2.1
cycler==0.12.1
debugpy==1.8.1
decorator==5.1.1
defusedxml==0.7.1
diff_cover==9.2.0
Eel==0.16.0
executing==2.0.1
Faker==30.3.0
faker-commerce==1.0.4
fastjsonschema==2.19.1
fonttools==4.51.0
fqdn==1.5.1
frozenlist==1.4.1
future==1.0.0
gevent==24.2.1
gevent-websocket==0.10.1
greenlet==3.0.3
h11==0.14.0
httpcore==1.0.5
httpx==0.27.0
idna==3.7
iniconfig==2.0.0
ipykernel==6.29.4
ipython==8.24.0
ipywidgets==8.1.5
isoduration==20.11.0
jedi==0.19.1
Jinja2==3.1.3
jinxed==1.2.1
jmespath==1.0.1
json5==0.9.25
jsonpointer==2.4
jsonschema==4.21.1
jsonschema-specifications==2023.12.1
jupyter==1.1.1
jupyter-console==6.6.3
jupyter-events==0.10.0
jupyter-lsp==2.2.5
jupyter_client==8.6.1
jupyter_core==5.7.2
jupyter_server==2.14.0
jupyter_server_terminals==0.5.3
jupyterlab==4.2.5
jupyterlab_pygments==0.3.0
jupyterlab_server==2.27.1
jupyterlab_widgets==3.0.13
keyboard==0.13.5
kiwisolver==1.4.5
llvmlite==0.42.0
MarkupSafe==2.1.5
matplotlib==3.8.4
matplotlib-inline==0.1.7
memory-profiler==0.61.0
mimesis==18.0.0
mistune==3.0.2
multidict==6.0.5
nbclient==0.10.0
nbconvert==7.16.3
nbformat==5.10.4
nest-asyncio==1.6.0
notebook==7.2.2
notebook_shim==0.2.4
numba==0.59.1
numpy==1.26.4
overrides==7.7.0
packaging==24.0
pandas==2.2.2
pandocfilters==1.5.1
parso==0.8.4
pathspec==0.12.1
pgcli==4.1.0
pgspecial==2.1.3
pillow==10.3.0
platformdirs==4.2.1
pluggy==1.5.0
prettytable==3.10.0
prometheus_client==0.20.0
prompt-toolkit==3.0.43
psutil==5.9.8
psycopg==3.2.3
psycopg-binary==3.2.3
pure-eval==0.2.2
pycparser==2.22
Pygments==2.17.2
pyparsing==3.1.2
pytest==8.3.3
python-dateutil==2.9.0.post0
python-json-logger==2.0.7
pytz==2024.1
pywin32==306
pywinpty==2.0.13
PyYAML==6.0.1
pyzmq==26.0.2
referencing==0.35.0
regex==2024.9.11
requests==2.31.0
rfc3339-validator==0.1.4
rfc3986-validator==0.1.1
rpds-py==0.18.0
s3transfer==0.10.1
seaborn==0.13.2
Send2Trash==1.8.3
setproctitle==1.3.4
setuptools==70.1.1
six==1.16.0
sniffio==1.3.1
soupsieve==2.5
sqlfluff==3.2.4
sqlparse==0.5.3
stack-data==0.6.3
tabulate==0.9.0
tblib==3.0.0
terminado==0.18.1
tinycss2==1.3.0
tornado==6.4
tqdm==4.66.5
traitlets==5.14.3
types-python-dateutil==2.9.0.20240316
typing_extensions==4.12.2
tzdata==2024.1
uri-template==1.3.0
urllib3==2.2.1
wcwidth==0.2.13
webcolors==1.13
webencodings==0.5.1
websocket-client==1.8.0
whichcraft==0.6.1
widgetsnbextension==4.0.13
windows-curses==2.3.3
wrapt==1.16.0
yarl==1.9.4
zope.event==5.0
zope.interface==6.4.post2