#!/bin/sh 

if [ "$USER" != "postgres" ]; then
  echo "$0 must be run by postgres"
  exit
fi
echo "Initializing default data base by user $USER ..."

cd

PG_ROOT=/opt/pgsql
PATH=$PATH:$PG_ROOT/bin
PGLIB=$PG_ROOT/lib
PGDATA=$PG_ROOT/data
PGSHARE=$PG_ROOT/share
PGCERT=$PG_ROOT/apps/utils/cert
LD_LIBRARY_PATH=$PGLIB
export PATH PGLIB PGDATA LD_LIBRARY_PATH

initdb -L $PGSHARE -D $PGDATA

# create empty password file
touch $PGDATA/pg_pwd
chmod 600 $PGDATA/pg_pwd
## Option for 7.0
##cp $PGSHARE/pg_options.sample $PGDATA/pg_options
# SSL for 7.1 or up
cp $PGCERT/cert.pem $PGDATA/server.key
cp $PGCERT/cert.cert $PGDATA/server.crt
chmod 600 $PGDATA/server.*
