なんかいやってもpostgresqlが動かない

何度目になるのかわからないぐらい postgresql が動かない。
何度も動かないのに反省していない自分がアホなので、今度こそメモする。
完全に自分で作った罠に自分でひっかかっているとういう話なので、参考にはならないと思います。

いつもどおり brew でインストールする
そして長々とログをベタ貼りする。

$ brew install postgresql
Updating Homebrew...
==> Auto-updated Homebrew!
Updated 1 tap (homebrew/core).
==> New Formulae
fasttext
==> Updated Formulae
pcre2 ✔                                 hugo                                    istioctl                                lz4
gmic                                    ios-webkit-debug-proxy                  libuv                                   zstd

==> Installing dependencies for postgresql: readline
==> Installing postgresql dependency: readline
==> Downloading https://homebrew.bintray.com/bottles/readline-8.0.0.mojave.bottle.tar.gz
Already downloaded: /Users/ninjaninja/Library/Caches/Homebrew/downloads/9857a88bdb1a8ec96b986e99084ea823541d357d451a70a028e7c30410f918e9--readline-8.0.0.mojave.bottle.tar.gz
==> Pouring readline-8.0.0.mojave.bottle.tar.gz
==> Caveats
readline is keg-only, which means it was not symlinked into /usr/local,
because macOS provides the BSD libedit library, which shadows libreadline.
In order to prevent conflicts when programs look for libreadline we are
defaulting this GNU Readline installation to keg-only.

For compilers to find readline you may need to set:
  export LDFLAGS="-L/usr/local/opt/readline/lib"
  export CPPFLAGS="-I/usr/local/opt/readline/include"

For pkg-config to find readline you may need to set:
  export PKG_CONFIG_PATH="/usr/local/opt/readline/lib/pkgconfig"

==> Summary
🍺  /usr/local/Cellar/readline/8.0.0: 48 files, 1.5MB
==> Installing postgresql
==> Downloading https://homebrew.bintray.com/bottles/postgresql-11.2.mojave.bottle.tar.gz
Already downloaded: /Users/ninjaninja/Library/Caches/Homebrew/downloads/991d29978b1e0603895b59851c553e41370fefedbb67797b6078ead33bccdba2--postgresql-11.2.mojave.bottle.tar.gz
==> Pouring postgresql-11.2.mojave.bottle.tar.gz
Error: The `brew link` step did not complete successfully
The formula built, but is not symlinked into /usr/local
Could not symlink include/ecpg_config.h
/usr/local/include is not writable.

You can try again using:
  brew link postgresql
==> Caveats
To migrate existing data from a previous major version of PostgreSQL run:
  brew postgresql-upgrade-database

To have launchd start postgresql now and restart at login:
  brew services start postgresql
Or, if you don't want/need a background service you can just run:
  pg_ctl -D /usr/local/var/postgres start
==> Summary
🍺  /usr/local/Cellar/postgresql/11.2: 3,186 files, 35.4MB
==> Caveats
==> readline
readline is keg-only, which means it was not symlinked into /usr/local,
because macOS provides the BSD libedit library, which shadows libreadline.
In order to prevent conflicts when programs look for libreadline we are
defaulting this GNU Readline installation to keg-only.

For compilers to find readline you may need to set:
  export LDFLAGS="-L/usr/local/opt/readline/lib"
  export CPPFLAGS="-I/usr/local/opt/readline/include"

For pkg-config to find readline you may need to set:
  export PKG_CONFIG_PATH="/usr/local/opt/readline/lib/pkgconfig"

==> postgresql
To migrate existing data from a previous major version of PostgreSQL run:
  brew postgresql-upgrade-database

To have launchd start postgresql now and restart at login:
  brew services start postgresql
Or, if you don't want/need a background service you can just run:
  pg_ctl -D /usr/local/var/postgres start

ログにかかれているとおり、 readline 用の環境変数を設定します。

$ echo -e "export LDFLAGS=\"-L/usr/local/opt/readline/lib\"\nexport CPPFLAGS=\"-I/usr/local/opt/readline/include\"\nexport PKG_CONFIG_PATH=\"/usr/local/opt/readline/lib/pkgconfig\"" >> ~/.bash_profile
$ source ~/.bash_profile

brew services 経由で postgres を起動する。

$ brew services start postgresql
==> Successfully started `postgresql` (label: homebrew.mxcl.postgresql)
$ brew services list
Name       Status  User       Plist
mysql@5.6  stopped
postgresql started ninjaninja /Users/ninjaninja/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
redis      started ninjaninja /Users/ninjaninja/Library/LaunchAgents/homebrew.mxcl.redis.plist

postgresql が started になっている（・｀ω・´）

$ psql
psql: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?

はい。でました。いつものエラー。毎回みるわー。反省してないわー。アホだな自分ー。解決していきましょう。

ふむふむ。

--host が / ではじまると、 Unix-domain socket で接続するからね。

っていうことで解決方法は --host localhost ってオプションつければ、強制的にTCP/IP経由で接続するとのこと。 Stackoverflow で教えてもらいました。

$ psql -hlocalhost
psql: FATAL:  role "ninjaninja" does not exist

ああ、ユーザー指定しないとですな。

$ psql -hlocalhost -Upostgres
dyld: lazy symbol binding failed: Symbol not found: _PQsetErrorContextVisibility
  Referenced from: /usr/local/opt/postgresql/bin/psql
  Expected in: /usr/lib/libpq.5.dylib

dyld: Symbol not found: _PQsetErrorContextVisibility
  Referenced from: /usr/local/opt/postgresql/bin/psql
  Expected in: /usr/lib/libpq.5.dylib

Abort trap: 6

なんだろうこのエラー:(；ﾞﾟ'ωﾟ'）:
世界のお友達に聞いても全然当てはまらない。どういうことだー。そしてもう一度インストール時のログを見返すと。

==> Pouring postgresql-11.2.mojave.bottle.tar.gz
Error: The `brew link` step did not complete successfully
The formula built, but is not symlinked into /usr/local
Could not symlink include/ecpg_config.h
/usr/local/include is not writable.

エラー出てるやんけ。ちゃんと見とけよ。

/usr/local/include is not writable.

んー。うちの環境に /usr/local/inclde がないとな?!
これは、自分の過去の記事のせいで発生した問題ですね:(；ﾞﾟ'ωﾟ'）:

この対応で、 /usr/local/include を /usr/local/include_old に mv してました。

ということで /usr/local/include を戻すんではなく、作り直します。 rbenv 動かなくなっちゃうし。

$ sudo mkdir /usr/local/include
$ sudo chown ninjaninja:admin /usr/local/include

そして postgresql インストールしなおし。

$ brew uninstall postgresql
Uninstalling /usr/local/Cellar/postgresql/11.2... (3,186 files, 35.4MB)

$ brew install postgresql
==> Downloading https://homebrew.bintray.com/bottles/postgresql-11.2.mojave.bottle.tar.gz
Already downloaded: /Users/ninjaninja/Library/Caches/Homebrew/downloads/991d29978b1e0603895b59851c553e41370fefedbb67797b6078ead33bccdba2--postgresql-11.2.mojave.bottle.tar.gz
==> Pouring postgresql-11.2.mojave.bottle.tar.gz
==> Caveats
To migrate existing data from a previous major version of PostgreSQL run:
  brew postgresql-upgrade-database

To have launchd start postgresql now and restart at login:
  brew services start postgresql
Or, if you don't want/need a background service you can just run:
  pg_ctl -D /usr/local/var/postgres start
==> Summary
🍺  /usr/local/Cellar/postgresql/11.2: 3,186 files, 35.4MB

ｼｬｰｵﾗｰ! 今度こそエラーなし。

$ psql -hlocalhost -Upostgres
psql (11.2)
Type "help" for help.

postgres=#

めでたくアクセス成功。本当に自分はアホだなと思いました。