Slackware 13.37 - Installing PostgreSQL (with epkg)
===================================================

*First install epkg/encap*

Public domain
********************************************************************************
### PostgreSQL Installation

    cd /usr/src
    wget -c "http://pmoghadam.com/homepage/Pages/Deposit/Source-packages/postgresql-8.4.12.tar.bz2"
    su - install
    cd /usr/src
    tar xf postgresql-8.4.12.tar.bz2
    cd postgresql-8.4.12 
    ./configure --prefix=/usr && gmake 
    gmake install DESTDIR=/usr/local/encap/postgresql-8.4.12
    cd /usr/local/encap/postgresql-8.4.12
    mv usr/share/doc/ usr/
    mv usr/share/man/ usr/
    cd /usr/local/encap/
    mkencap postgresql-8.4.12/ 
    logout
    rm -rf /usr/src/postgresql-8.4.12
    cd /usr/local/encap/
    epkg postgresql-8.4.12 

********************************************************************************
### Initialize

    useradd -m postgres
    passwd  -l postgres
    mkdir -p /var/lib/pgsql-data
    chown postgres /var/lib/pgsql-data
    su - postgres -c "initdb -D /var/lib/pgsql-data"
    su - postgres -c "postgres -D /var/lib/pgsql-data &"
    sleep 2
    su - postgres -c "createuser -a -d -P root"
    #su - postgres -c "initdb -U root -W -A md5 -D /var/lib/pgsql-data"

********************************************************************************
### /etc/rc.d/rc.postgresql

    #!/bin/bash

    # Configuration
    PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
    PGDATA="/var/lib/pgsql-data/"
    PGUSER=postgres
    PGLOG="$PGDATA/serverlog"
    DAEMON="postmaster"
    PGCTL="pg_ctl"

    case $1 in
      start)
        echo -n "Starting PostgreSQL: "
        su - $PGUSER -c "$DAEMON -D '$PGDATA' &" >>$PGLOG 2>&1
        echo "ok"
        ;;
      stop)
        echo -n "Stopping PostgreSQL: "
        su - $PGUSER -c "$PGCTL stop -D '$PGDATA' -s -m fast"
        echo "ok"
        ;;
      restart)
        echo -n "Restarting PostgreSQL: "
        su - $PGUSER -c "$PGCTL stop -D '$PGDATA' -s -m fast -w"
        su - $PGUSER -c "$DAEMON -D '$PGDATA' &" >>$PGLOG 2>&1
        echo "ok"
        ;;
      reload)
        echo -n "Reload PostgreSQL: "
        su - $PGUSER -c "$PGCTL reload -D '$PGDATA' -s"
        echo "ok"
        ;;
      status)
        su - $PGUSER -c "$PGCTL status -D '$PGDATA'"
        ;;
      *)
        echo "Usage: $0 {start|stop|restart|reload|status}" 1>&2
        exit 1
        ;;
    esac

********************************************************************************
### /etc/rc.d/rc.local

    # Start postgresql
    if [ -x /etc/rc.d/rc.postgresql ] ; then
      /etc/rc.d/rc.postgresql start
    fi

********************************************************************************
### /etc/rc.d/rc.local_shutdown

    # Stop postgresql
    if [ -x /etc/rc.d/rc.postgresql ] ; then
      /etc/rc.d/rc.postgresql stop
    fi

********************************************************************************
### Launch

    chmod +x /etc/rc.d/rc.postgresql
    /etc/rc.d/rc.postgresql restart
    sleep 2
    ps -A | grep postmaster

********************************************************************************
### Create user

    createuser -P testuser


********************************************************************************
### Create database

    createdb testdb

********************************************************************************
### Connecting to database

    psql testdb

********************************************************************************
### Uninstall

    /etc/rc.d/rc.postgresql stop
    rm -f /etc/rc.d/rc.postgresql
    cd /usr/local/encap
    epkg -r postgresql-8.4.12 
    userdel -r postgres
    rm -rf /var/lib/pgsql-data/
    # Edit /etc/rc.d/rc.local
    # Edit /etc/rc.d/rc.local_shutdown

********************************************************************************
### Bookmarks

[http://www.postgresql.org/docs/8.4/static/datatype-net-types.html](http://www.postgresql.org/docs/8.4/static/datatype-net-types.html)  
[http://www.postgresql.org/docs/8.4/static/functions-net.html](http://www.postgresql.org/docs/8.4/static/functions-net.html)  
[http://www.postgresql.org/docs/8.4/static/datatype-datetime.html](http://www.postgresql.org/docs/8.4/static/datatype-datetime.html)  
[http://www.postgresql.org/docs/8.4/static/functions-datetime.html](http://www.postgresql.org/docs/8.4/static/functions-datetime.html)  

********************************************************************************
_BY: Pejman Moghadam_  
_TAG: epkg, postgresql_  
_DATE: 2012-06-21 12:36:53_