gistfile1.sh

#!/bin/bash

if [ $# -ne 1 ]
then
    echo "Incorrect number of arguments"
    echo "Usage"
    echo "./script ROOT_DIR_OF_POSTGRES_INSTALL"
    exit 1
fi

bin_dir=$1

if [ ! -d ${bin_dir} ]
then
    echo "PostgreSQL installation directory does not exist!"
    exit 1
fi

proc=`ps -ef | \
      grep postgres: | \
      grep -v -e 'grep postgres:' \
      -e 'postgres: stats' \
      -e 'postgres: wal' \
      -e 'postgres: archiver' \
      -e 'postgres: logger' \
      -e 'postgres: autovacuum' \
      -e 'postgres: writer' | \
      tee /dev/tty | \
      awk '{print $2}'`

if [ `echo "$proc" | wc -w` -eq 1 ]
then
    exec gdb ${bin_dir}/bin/postgres -silent "$proc"
fi

exit 0