pg

#!/bin/bash

########################################################
# TERMUX - https://wiki.termux.com/wiki/Postgresql
#
# - https://thenewstack.io/a-cheat-sheet-to-database-access-control-postgresql/

# PostgreSQL 16.x - https://postgresql.org/about/news/postgresql-16-released-2715/
declare -xr PGVERSION=15

########################################################

declare -xr FIXPRE=${PREFIX:-/usr}

# declare -xr PGBIN=/usr/local/Cellar/postgresql@${PGVERSION}/${PGVERSION}.0_1/bin
declare -xr PGBIN=${FIXPRE}/bin
declare -xr EXEC=${PGBIN}/pg

declare -xr PGDATA=${PGDATA:-/usr/local/var/postgres@15}
declare -xr COMMAND=$1
declare -xr OPERATION=$2
declare -xr AUTH=--auth-local # --auth-host
declare -xr USERNAME=devpunks
declare -xr HOST=localhost
declare -xr PORT=${PORT:-5432}
# declare -xr PID=${PGDATA}/postmaster.pid

function status {
  ${EXEC}_ctl status --pgdata=$PGDATA
}

echo FIXPRE 👉 $FIXPRE
echo PGVERSION 👉 $PGVERSION
echo PGDATA 👉 $PGDATA
echo EXEC 👉 $EXEC
echo LOGDIR 👉 $LOGDIR
echo PORT 👉 $PORT
echo AUTH 👉 $AUTH
echo COMMAND 👉 $COMMAND

status

exit 0

# REMOVE ME!
# pg_ctl stop -D $PGDATA -l $LOGDIR -s -m fast
# ls $PGDATA
# rm -rf $PGDATA
# pg_ctl init -D $PGDATA -l $LOGDIR


# Run ls -al /usr/local/bin | grep pg_ for Postgres commands
# pg_dump[all]
# pg_verifybackup
# pg_upgrade
# pg_restore
# pg_isready


status

${EXEC}_${COMMAND} ${OPERATION} --pgdata=$PGDATA --log=$LOGDIR -s -m fast
#pg_ctl -l $LOGDIR -D $PGDATA $COMMAND -s -m fast

status