Styjun

After rebooting, I am getting errors trying to use Postgres, either from rails or via terminal by typing psql

No such file or directory Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

I installed postgres with homebrew.

I have run these diagnostics, but do not understand the outputs:

> brew list|grep postgres 
postgresql
postgresql@10

> brew services restart postgresql
Stopping `postgresql`... (might take a while)
==> Successfully stopped `postgresql` (label: homebrew.mxcl.postgresql)
==> Successfully started `postgresql` (label: homebrew.mxcl.postgresql)

❯ pg_ctl -D /usr/local/var/postgres status
pg_ctl: no server running

❯ brew info postgresql 
postgresql: stable 11.2 (bottled), HEAD
Object-relational database system
https://www.postgresql.org/
Conflicts with:
 postgres-xc (because postgresql and postgres-xc install the same binaries.)
/usr/local/Cellar/postgresql/11.2 (3,186 files, 35.4MB) *
 Poured from bottle on 2019-03-20 at 12:42:32
From: https://github.com/Homebrew/homebrew-core/blob/master/Formula/postgresql.rb
==> Dependencies
Build: pkg-config ✔
Required: icu4c ✔, openssl ✔, readline ✔
==> Options
--HEAD
 Install HEAD version
==> 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
==> Analytics
install: 84,642 (30 days), 236,127 (90 days), 754,771 (365 days)
install_on_request: 75,641 (30 days), 208,395 (90 days), 652,972 (365 days)
build_error: 0 (30 days)

> ps auxwww | grep postgres 
will 19993 0.0 0.0 4284404 804 s001 S+ 1:22pm 0:00.00 grep --color=auto --exclude-dir=.bzr --exclude-dir=CVS --exclude-dir=.git --exclude-dir=.hg --exclude-dir=.svn postgres

 ❯ ps -ef | grep postgres 
 502 20156 4003 0 1:24pm ttys001 0:00.00 grep --color=auto --exclude-dir=.bzr --exclude-dir=CVS --exclude-dir=.git --exclude-dir=.hg --exclude-dir=.svn postgres

> psql --version
psql (PostgreSQL) 11.2
> pg_upgrade --version
pg_upgrade (PostgreSQL) 11.2

Attempted sollutions:

❯ rm /usr/local/var/postgres/postmaster.pid
rm: /usr/local/var/postgres/postmaster.pid: No such file or directory

> initdb /usr/local/var/postgres -E utf8
initdb: directory "/usr/local/var/postgres" exists but is not empty

Some of the debug stuff above references postgres 10, some 11. Have I accidentally installed 2 postgres somehow? How do I resolve that?