Server closes connection unexpectedly when connecting to Azure Postgres
In this case, you could install the PostgreSQL Client for macOS with Homebrew properly then link it as it will symlink all the tools into the /usr/local/bin directory.
To fix this issue, run the following commands:
$ brew services stop postgresql$ brew install postgresql@10$ brew services start postgresql@10$ brew link --overwrite --force postgresql@10Ref: https://www.compose.com/articles/postgresql-tips-installing-the-postgresql-client/