Skip to content

Instantly share code, notes, and snippets.

@ajkovar
Last active June 30, 2020 01:14
Show Gist options
  • Save ajkovar/1b452c1c30b62bf1c6264adfdc846a59 to your computer and use it in GitHub Desktop.
Save ajkovar/1b452c1c30b62bf1c6264adfdc846a59 to your computer and use it in GitHub Desktop.
psql issue
#Received this error recently
psql
dyld: Library not loaded: /usr/local/opt/openssl/lib/libssl.1.0.0.dylib
Referenced from: /usr/local/Cellar/postgresql@10/10.6_1/lib/libpq.5.10.dylib
Reason: image not found
Abort trap: 6
# Based on this post
#https://stackoverflow.com/questions/59006602/dyld-library-not-loaded-usr-local-opt-openssl-lib-libssl-1-0-0-dylib
# I hade to change homebrew's versino of openssl
#first running
ls -al /usr/local/Cellar/openssl
# to determine openssl version
# then
brew switch openssl 1.0.2r
# to switch the version
# Seems something happened to postgres installation?
# had to rerun
brew install postgresql
# then
brew services start postgresql
#after this I recieved:
psql
psql: FATAL: database "alex" does not exist
# and to solve it was necessary to run
createdb
# maybe relevent:
#https://stackoverflow.com/questions/13573204/psql-could-not-connect-to-server-no-such-file-or-directory-mac-os-x
#https://stackoverflow.com/questions/17633422/psql-fatal-database-user-does-not-exist
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment