BoxenなPostgreSQLの設定メモ

boxen postgres

MacでBoxenなPostgreSQLの設定メモ。

$ vi ~/.bash_profile
source /opt/boxen/env.sh

$ vi /opt/boxen/etc/env.d/70_postgresql.sh
export BOXEN_POSTGRESQL_HOST=127.0.0.1
export BOXEN_POSTGRESQL_PORT=15432
export BOXEN_POSTGRESQL_URL="postgres://$BOXEN_POSTGRESQL_HOST:$BOXEN_POSTGRESQL_PORT/"
export PGHOST=localhost
export PGPORT=5432
[ -z "$PGDATA" ] && export PGDATA=/opt/boxen/homebrew/var/postgres
[ -z "$PGPORT" ] && export PGPORT=$BOXEN_POSTGRESQL_PORT

実行

$ pg_ctl stop
$ pg_ctl start
$ psql postgres
postgres=# \l
   Name    | Owner  | Encoding |   Collate   |    Ctype    | Access privileges 
-----------+--------+----------+-------------+-------------+-------------------
 postgres  | kappa  | UTF8     | ja_JP.UTF-8 | ja_JP.UTF-8 |