POSTGRES :: Setup :: Simple

****** init.sh *****
#!/bin/sh

ENV_PG_BASE_PATH=/usr/local/Cellar/postgresql@9.6/9.6.11/
ENV_PROJECT=SAMPLE
ENV_PROJECT_PG_PATH=$HOME/Projects/${ENV_PROJECT}/apps/db/postgres/

# --- Setup ---
export PATH=${ENV_PG_BASE_PATH}/bin:$PATH
mkdir -p ${ENV_PROJECT_PG_PATH}/data
initdb  -W  ${ENV_PROJECT_PG_PATH}/data --lc-ctype=de_DE.UTF-8 --lc-collate=de_DE.UTF-8

****** start.sh *****
#!/bin/sh

ENV_PG_BASE_PATH=/usr/local/Cellar/postgresql@9.6/9.6.11/
ENV_PROJECT=SAMPLE
ENV_PROJECT_PG_PATH=$HOME/Projects/${ENV_PROJECT}/apps/db/postgres/

# --- Start ---
export PATH=${ENV_PG_BASE_PATH}/bin:$PATH
pg_ctl -D ${ENV_PROJECT_PG_PATH}/data -l logfile start


****** stop.sh *****
#!/bin/sh

ENV_PG_BASE_PATH=/usr/local/Cellar/postgresql@9.6/9.6.11/
ENV_PROJECT=SAMPLE
ENV_PROJECT_PG_PATH=$HOME/Projects/${ENV_PROJECT}/apps/db/postgres/

# --- Stop ---
export PATH=${ENV_PG_BASE_PATH}/bin:$PATH
pg_ctl -D  $HOME/Projects/${ENV_PROJECT}/database/postgres/data -l logfile stop