supilog

すぴろぐ

$ brew search postgresql

postgresql@10               postgresql@12               postgresql@14               postgresql@9.4              qt-postgresql
postgresql@11               postgresql@13               postgresql@15   

$ brew install postgresql@14

...略...
==> Caveats
This formula has created a default database cluster with:
  initdb --locale=C -E UTF-8 /opt/homebrew/var/postgresql@14
For more details, read:
  https://www.postgresql.org/docs/14/app-initdb.html

To start postgresql@14 now and restart at login:
  brew services start postgresql@14
==> Summary
🍺  /opt/homebrew/Cellar/postgresql@14/14.7: 3,314 files, 45.2MB
==> Running `brew cleanup postgresql@14`...
Disable this behaviour by setting HOMEBREW_NO_INSTALL_CLEANUP.
Hide these hints with HOMEBREW_NO_ENV_HINTS (see `man brew`).

$ psql --version

psql (PostgreSQL) 14.7 (Homebrew)

$ brew services start postgresql@14

==> Successfully started `postgresql@14` (label: homebrew.mxcl.postgresql@14)

$ brew services stop postgresql@14

==> Successfully stopped `postgresql@14` (label: homebrew.mxcl.postgresql@14)

# ログイン
$ psql postgres

# パスワード設定
postgres=# \password

# ログアウト
postgres=# \q

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     md5
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5

$ brew services restart postgresql@14

# ログイン
$ psql postgres

# ROLE作成(ユーザー作成)
postgres=# CREATE ROLE sampleuser WITH LOGIN PASSWORD 'hogehoge';

# DATABASE作成
postgres=# CREATE DATABASE sample OWNER sampleuser;

# ログアウト
postgres=# \q