Finding the socket on Ubuntu 19.04

[godfrey-cw]

Description

After installing via conda on Ubuntu 19.04, psql was working but pgcli wasn't:

I was able to make things work, by adding '/tmp' to the unix_socket_directories variable in the postgresql.conf:

and restarting the server with

sudo /etc/init.d/postgresql restart

as seen below:

Your environment

• [ x] Please provide your OS and version information. Ubuntu 19.04
• [ x] Please provide your CLI version. pgcli 2.1.1
• [x ] What is the output of pip freeze command.

anaconda-client==1.7.2
anaconda-navigator==1.9.7
argcomplete==1.10.0
asn1crypto==0.24.0
astroid==2.2.5
attrs==19.1.0
aws-shell==0.2.1
awscli==1.16.179
backcall==0.1.0
backports.csv==1.0.5
bleach==3.1.0
boto3==1.9.169
botocore==1.12.169
certifi==2019.6.16
cffi==1.12.3
chardet==3.0.4
cli-helpers==1.2.1
Click==7.0
clyent==1.2.2
colorama==0.3.9
conda==4.7.5
conda-package-handling==1.3.10
configobj==5.0.6
cryptography==2.7
cycler==0.10.0
decorator==4.4.0
defusedxml==0.6.0
docutils==0.14
entrypoints==0.3
humanize==0.5.1
idna==2.8
ipykernel==5.1.1
ipython==7.5.0
ipython-genutils==0.2.0
isort==4.3.20
jedi==0.13.3
Jinja2==2.10.1
jmespath==0.9.4
jsonschema==3.0.1
jupyter-client==5.2.4
jupyter-core==4.4.0
jupyterlab==0.35.3
jupyterlab-server==0.2.0
kiwisolver==1.1.0
lazy-object-proxy==1.4.1
libarchive-c==2.8
litecli==1.0.0
MarkupSafe==1.1.1
matplotlib==3.0.2
mccabe==0.6.1
mistune==0.8.4
mkl-fft==1.0.12
mkl-random==1.0.2
nbconvert==5.5.0
nbformat==4.4.0
notebook==5.7.8
numpy==1.15.4
olefile==0.46
pandas==0.24.2
pandocfilters==1.4.2
parso==0.4.0
patsy==0.5.1
pexpect==4.7.0
pgcli==2.1.1
pgspecial==1.11.3
pickleshare==0.7.5
Pillow==6.0.0
powerline-status==2.7
prometheus-client==0.6.0
prompt-toolkit==2.0.9
psutil==5.6.2
psycopg2==2.7.6.1
ptyprocess==0.6.0
pyasn1==0.4.5
pycodestyle==2.5.0
pycosat==0.6.3
pycparser==2.19
pydocstyle==3.0.0
pyflakes==2.1.1
Pygments==2.3.1
pylama==7.6.6
pylint==2.3.1
pyOpenSSL==19.0.0
pyparsing==2.4.0
pyrsistent==0.14.11
PySocks==1.7.0
python-dateutil==2.8.0
pytz==2019.1
PyYAML==5.1
pyzmq==18.0.0
QtPy==1.7.1
requests==2.22.0
rsa==3.4.2
ruamel-yaml==0.15.46
s3transfer==0.2.0
scipy==1.1.0
seaborn==0.9.0
Send2Trash==1.5.0
setproctitle==1.1.10
six==1.12.0
snowballstemmer==1.2.1
sqlparse==0.2.4
statsmodels==0.9.0
tabulate==0.8.3
termcolor==1.1.0
terminado==0.8.2
terminaltables==3.1.0
testpath==0.4.2
tornado==6.0.2
tqdm==4.32.1
traitlets==4.3.2
urllib3==1.24.2
wcwidth==0.1.7
webencodings==0.5.1
wrapt==1.11.1