pgcli icon indicating copy to clipboard operation
pgcli copied to clipboard

Error connecting to postgres

Open pratio opened this issue 4 years ago • 0 comments

Description

Trying to connect postgres on the localhost. I face this issue

~> pgcli -h localhost -p 5001 -d postgres
Traceback (most recent call last):
  File "/usr/local/bin/pgcli", line 8, in <module>
    sys.exit(cli())
  File "/usr/local/Cellar/pgcli/3.2.0/libexec/lib/python3.9/site-packages/click/core.py", line 1137, in __call__
    return self.main(*args, **kwargs)
  File "/usr/local/Cellar/pgcli/3.2.0/libexec/lib/python3.9/site-packages/click/core.py", line 1062, in main
    rv = self.invoke(ctx)
  File "/usr/local/Cellar/pgcli/3.2.0/libexec/lib/python3.9/site-packages/click/core.py", line 1404, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/usr/local/Cellar/pgcli/3.2.0/libexec/lib/python3.9/site-packages/click/core.py", line 763, in invoke
    return __callback(*args, **kwargs)
  File "/usr/local/Cellar/pgcli/3.2.0/libexec/lib/python3.9/site-packages/pgcli/main.py", line 1266, in cli
    pgcli = PGCli(
  File "/usr/local/Cellar/pgcli/3.2.0/libexec/lib/python3.9/site-packages/pgcli/main.py", line 178, in __init__
    c = self.config = get_config(pgclirc_file)
  File "/usr/local/Cellar/pgcli/3.2.0/libexec/lib/python3.9/site-packages/pgcli/config.py", line 67, in get_config
    return load_config(pgclirc_file, default_config)
  File "/usr/local/Cellar/pgcli/3.2.0/libexec/lib/python3.9/site-packages/pgcli/config.py", line 26, in load_config
    cfg.merge(ConfigObj(expanduser(usr_cfg), interpolation=False, encoding="utf-8"))
  File "/usr/local/Cellar/pgcli/3.2.0/libexec/lib/python3.9/site-packages/configobj.py", line 1229, in __init__
    self._load(infile, configspec)
  File "/usr/local/Cellar/pgcli/3.2.0/libexec/lib/python3.9/site-packages/configobj.py", line 1318, in _load
    raise error
configobj.DuplicateError: Duplicate section name at line 203.

Your environment

pgcli --version
Version: 3.2.0

pip freeze
cli-helpers==2.2.0
click==8.0.3
configobj==5.0.6
humanize==3.12.0
pgcli==1.9.0
pgspecial==1.11.5
prompt-toolkit==1.0.18
psycopg2-binary==2.9.1
Pygments==2.10.0
setproctitle==1.2.2
six==1.16.0
sqlparse==0.2.4
tabulate==0.8.9
wcwidth==0.2.5

  • [x] Please provide your OS and version information.: Mac OS 11.6
  • [x] Please provide your CLI version.: 3.2.0
  • [x] What is the output of pip freeze command.

pratio avatar Oct 13 '21 09:10 pratio