CentOS6.5 64位下源码安装PostgreSQL9.5.1

喜欢ヅ旅行 2022-07-14 00:48 189阅读 0赞

# 1、官方下载源码文件 #

[http://www.postgresql.org/ftp/source/v9.5.1/][http_www.postgresql.org_ftp_source_v9.5.1]

# 2、添加用户 #

\[root@test1 ~\]\#  useradd postgres

\[root@test1 ~\]\#  passwd postgres

Changing password for user postgres.

New password:

Retype new password:

passwd: all authentication tokens updated successfully.

\[root@test1 ~\]\#

# 3、解压并安装 #

\[root@test1 ~\]\# tar -jxvf postgresql-9.5.1.tar.bz2

\[root@test1 ~\]\# cd postgresql-9.5.1

\[root@test1 postgresql-9.5.1\]\# ./configure --prefix=/usr/local/pgsql

\[root@test1 postgresql-9.5.1\]\# make

\[root@test1 postgresql-9.5.1\]\# make  install

\[root@test1 postgresql-9.5.1\]\# mkdir /usr/local/pgsql/data

\[root@test1 postgresql-9.5.1\]\# mkdir /usr/local/pgsql/log

\[root@test1 postgresql-9.5.1\]\# chown postgres /usr/local/pgsql/data

# 4、环境变量设置 #

\[root@test1 pgsql\]\# su - postgres

\[postgres@test1 ~\]$ vim .bash\_profile

# .bash_profile
    
    # Get the aliases and functions
    
    if [ -f ~/.bashrc ]; then
    
            . ~/.bashrc
    
    fi
    
    # User specific environment and startup programs
    
    PATH=$PATH:$HOME/bin:/usr/local/pgsql/bin
    
    PGDATA=/usr/local/pgsql/data
    
    export PATH PGDATA

\[postgres@test1 ~\]$ source .bash\_profile

# 5、添加postgresql系统服务 #

\[root@test1 ~\]\#  vim /etc/init.d/postgresql

#!/bin/sh
    #
    # postgresql    This is the init script for starting up the PostgreSQL
    #               server.
    #
    # chkconfig: - 64 36
    # description: PostgreSQL database server.
    # processname: postmaster
    # pidfile: /var/run/postmaster.PORT.pid
    
    # This script is slightly unusual in that the name of the daemon (postmaster)
    # is not the same as the name of the subsystem (postgresql)
    
    # PGVERSION is the full package version, e.g., 8.4.0
    # Note: the specfile inserts the correct value during package build
    PGVERSION=9.5.1
    # PGMAJORVERSION is major version, e.g., 8.4 (this should match PG_VERSION)
    PGMAJORVERSION=`echo "$PGVERSION" | sed 's/^$[0-9]*\.[0-9]*$.*$/\1/'`
    
    # Source function library.
    . /etc/rc.d/init.d/functions
    
    # Get network config.
    . /etc/sysconfig/network
    
    # Find the name of the script
    NAME=`basename $0`
    if [ ${NAME:0:1} = "S" -o ${NAME:0:1} = "K" ]
    then
            NAME=${NAME:3}
    fi
    
    # For SELinux we need to use 'runuser' not 'su'
    if [ -x /sbin/runuser ]
    then
        SU=runuser
    else
        SU=su
    fi
    
    
    # Set defaults for configuration variables
    PGENGINE=/usr/local/pgsql/bin
    PGPORT=5432
    PGDATA=/usr/local/pgsql/data
    PGLOG=/usr/local/pgsql/log/pgstartup.log
    # Value to set as postmaster process's oom_adj
    PG_OOM_ADJ=-17
    
    # Override defaults from /etc/sysconfig/pgsql if file is present
    [ -f /etc/sysconfig/pgsql/${NAME} ] && . /etc/sysconfig/pgsql/${NAME}
    
    export PGDATA
    export PGPORT
    
    lockfile="/var/lock/subsys/${NAME}"
    pidfile="/var/run/postmaster.${PGPORT}.pid"
    
    script_result=0
    
    start(){
            [ -x "$PGENGINE/postmaster" ] || exit 5
    
            PSQL_START=$"Starting ${NAME} service: "
    
            # Make sure startup-time log file is valid
            if [ ! -e "$PGLOG" -a ! -h "$PGLOG" ]
            then
                    touch "$PGLOG" || exit 4
                    chown postgres:postgres "$PGLOG"
                    chmod go-rwx "$PGLOG"
                    [ -x /sbin/restorecon ] && /sbin/restorecon "$PGLOG"
            fi
    
            # Check for the PGDATA structure
            if [ -f "$PGDATA/PG_VERSION" ] && [ -d "$PGDATA/base" ]
            then
                    # Check version of existing PGDATA
                    if [ x`cat "$PGDATA/PG_VERSION"` != x"$PGMAJORVERSION" ]
                    then
                            SYSDOCDIR="(Your System's documentation directory)"
                            if [ -d "/usr/doc/postgresql-$PGVERSION" ]
                            then
                                    SYSDOCDIR=/usr/doc
                            fi
                            if [ -d "/usr/share/doc/postgresql-$PGVERSION" ]
                            then
                                    SYSDOCDIR=/usr/share/doc
                            fi
                            if [ -d "/usr/doc/packages/postgresql-$PGVERSION" ]
                            then
                                    SYSDOCDIR=/usr/doc/packages
                            fi
                            if [ -d "/usr/share/doc/packages/postgresql-$PGVERSION" ]
                            then
                                    SYSDOCDIR=/usr/share/doc/packages
                            fi
                            echo
                            echo $"An old version of the database format was found."
                            echo $"You need to upgrade the data format before using PostgreSQL."
                            echo $"See $SYSDOCDIR/postgresql-$PGVERSION/README.rpm-dist for more information."
                            exit 1
                    fi
            else
                    # No existing PGDATA! Warn the user to initdb it.
                    echo
                    echo "$PGDATA is missing. Use \"service postgresql initdb\" to initialize the cluster first."
                    echo_failure
                    echo
                    exit 1
            fi
    
            echo -n "$PSQL_START"
            test x"$PG_OOM_ADJ" != x && echo "$PG_OOM_ADJ" > /proc/self/oom_adj
            $SU -l postgres -c "$PGENGINE/postmaster -p '$PGPORT' -D '$PGDATA' ${PGOPTS} &" >> "$PGLOG" 2>&1 < /dev/null
            sleep 2
            pid=`head -n 1 "$PGDATA/postmaster.pid" 2>/dev/null`
            if [ "x$pid" != x ]
            then
                    success "$PSQL_START"
                    touch "$lockfile"
                    echo $pid > "$pidfile"
                    echo
            else
                    failure "$PSQL_START"
                    echo
                    script_result=1
            fi
    }
    
    stop(){
            echo -n $"Stopping ${NAME} service: "
            if [ -e "$lockfile" ]
            then
                $SU -l postgres -c "$PGENGINE/pg_ctl stop -D '$PGDATA' -s -m fast" > /dev/null 2>&1 < /dev/null
                ret=$?if [ $ret -eq 0 ]
                then
                    echo_success
                    rm -f "$pidfile"
                    rm -f "$lockfile"
                else
                    echo_failure
                    script_result=1fi
            else
                # not running; per LSB standards this is "ok"
                echo_success
            fi
            echo
    }
    
    restart(){
        stop
        start
    }
    
    condrestart(){
        [ -e "$lockfile" ] && restart || :
    }
    
    reload(){
        $SU -l postgres -c "$PGENGINE/pg_ctl reload -D '$PGDATA' -s" > /dev/null 2>&1 < /dev/null
    }
    
    initdb(){
        if [ -f "$PGDATA/PG_VERSION" ]
        then
            echo -n "Data directory is not empty!"
            echo_failure
            echo
            script_result=1else
            echo -n $"Initializing database: "
            if [ ! -e "$PGDATA" -a ! -h "$PGDATA" ]
            then
                    mkdir -p "$PGDATA" || exit 1
                    chown postgres:postgres "$PGDATA"
                    chmod go-rwx "$PGDATA"
            fi
            # Clean up SELinux tagging for PGDATA
            [ -x /sbin/restorecon ] && /sbin/restorecon "$PGDATA"
    
            # Make sure the startup-time log file is OK, too
            if [ ! -e "$PGLOG" -a ! -h "$PGLOG" ]
            then
                    touch "$PGLOG" || exit 1
                    chown postgres:postgres "$PGLOG"
                    chmod go-rwx "$PGLOG"
                    [ -x /sbin/restorecon ] && /sbin/restorecon "$PGLOG"
            fi
    
            # Initialize the database
            $SU -l postgres -c "$PGENGINE/initdb --pgdata='$PGDATA' --auth='ident'" >> "$PGLOG" 2>&1 < /dev/null
    
            # Create directory for postmaster log
            mkdir "$PGDATA/pg_log"
            chown postgres:postgres "$PGDATA/pg_log"
            chmod go-rwx "$PGDATA/pg_log"
    
            if [ -f "$PGDATA/PG_VERSION" ]
            then
                echo_success
            else
                echo_failure
                script_result=1fi
            echo
        fi
    }
    
    # See how we were called.
    case "$1" in
      start)
            start
            ;;
      stop)
            stop
            ;;
      status)
            status -p "$pidfile" postmaster
            script_result=$?;;
      restart)
            restart
            ;;
      condrestart|try-restart)
            condrestart
            ;;
      reload)
            reload
            ;;
      force-reload)
            restart
            ;;
      initdb)
            initdb
            ;;
      *)
            echo $"Usage: $0 {start|stop|status|restart|condrestart|try-restart|reload|force-reload|initdb}"
            exit 2
    esac
    
    exit $script_result

chkconfig --add postgresql

chkconfig postgresql  on

[http_www.postgresql.org_ftp_source_v9.5.1]: http://www.postgresql.org/ftp/source/v9.5.1/