OpenPKG Specs: postgresql/pg_migrate@fd611cde817f (annotated)

postgresql/pg_migrate@fd611cde817f (annotated)

postgresql/pg_migrate

Sat, 24 Mar 2012 21:40:49 +0100

author: Michael Schloh von Bennewitz <michael@schloh.com>
date: Sat, 24 Mar 2012 21:40:49 +0100
changeset 414: fd611cde817f
permissions: -rw-r--r--

Introduce many changes to the buildconf and source code including:
(01) clean up, update, and partially update default config files,
(02) seems that Melware is unable to perform release engineering so
update chan_capi to new daily snapshot to solve echo problems,
(03) correct Asterisk inadequate hard coded gmime version check,
(04) force postgresql pthreads linkage to solve build problem,
(05) remove buggy hard coded LibXML configure definitions,
(06) remove local architecture specification to allow GCC
internal logic to determine proper CPU type instead,
(07) remove vendor sound install target causing uncontrolled
downloads and non RPM managed file installation,
(08) solve long outstanding bug in tcptls causing Asterisk
to ignore any intermediate CA certificate signatures,
(09) back out Digium engineering team's bright idea of replacing the
very portable and pervasive POSIX rand(1) with ast_random(), and
then not even implementing it causing all references to fail in
platforms not providing the very new POSIX.1-2008 mkdtemp(3)
function only distributed by BSD and some Linux,
(10) withdraw advanced linker symbol manipulations from SVR5 builds
until either Binutils supports hybrid versioned and anonymous
linker scripts or GCC stops hard coding versioned linker scripts,
(11) correct missing library linkage, some tailored to a specific OS,
(12) remove outdated logic for the no longer distributed gmime-config(1),
(13) remove local gmime buildconf hacks now that Asterisk has corrected
their own build configuration to almost portably support gmime,
(14) solve build problems relating to undetected LibXML paths,
(15) correct erroneous out of tree include definitions,
(16) improve some variable and comment naming,
(17) simplify sound language path hierarchy creation,
and correct australian english installation logic.

 #!/bin/sh
 ##
 ##  pg_migrate -- PostgreSQL Database Migration Utility
 ##  Copyright (c) 2000-2007 OpenPKG Foundation e.V. <http://openpkg.net/>
 ##  Copyright (c) 2000-2007 Ralf S. Engelschall <http://engelschall.com/>
 ##
 ##  Permission to use, copy, modify, and distribute this software for
 ##  any purpose with or without fee is hereby granted, provided that
 ##  the above copyright notice and this permission notice appear in all
 ##  copies.
 ##
 ##  THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
 ##  WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
 ##  MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
 ##  IN NO EVENT SHALL THE AUTHORS AND COPYRIGHT HOLDERS AND THEIR
 ##  CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 ##  SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 ##  LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
 ##  USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
 ##  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
 ##  OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
 ##  OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
 ##  SUCH DAMAGE.
 ##
 #   configuration
 l_prefix="@l_prefix@"
 l_rusr="@l_rusr@"
 l_rgrp="@l_rgrp@"
 #   load superuser information
 l_pgdata=""
 l_pguser=""
 l_pgpass=""
 if [ ! -r $l_prefix/var/postgresql/db/pg_superuser.conf ]; then
     echo "$0:ERROR: unable to read file \"$l_prefix/var/postgresql/db/pg_superuser.conf\" (use pg_passwd(1) to create)" 1>&2
     exit 1
 fi
 eval `. $l_prefix/var/postgresql/db/pg_superuser.conf; \
       echo l_pgdata=\"$superuser_database\"; \
       echo l_pguser=\"$superuser_username\"; \
       echo l_pgpass=\"$superuser_password\"`
 #   establish sane environment
 LC_CTYPE=C
 export LC_CTYPE
 umask 022
 #   check command line
 if [ $# -ne 1 -a $# -ne 2 ]; then
     echo "$0:ERROR: invalid command line" 1>&2
     echo "$0:USAGE: $0 dump|restore [<password>]" 1>&2
     exit 1
 fi
 cmd="$1"; shift
 if [ $# -eq 1 ]; then
     l_pgpass="$1"; shift
 fi
 #   dispatch into commands
 case $cmd in
     dump )
         echo "++ enforcing full-superuser access policy"
         cp -p $l_prefix/var/postgresql/db/pg_hba.conf \
               $l_prefix/var/postgresql/db/pg_hba.conf.orig
         ( echo "local all all trust"
           echo "host all all 127.0.0.1/32 trust"
         ) >$l_prefix/var/postgresql/db/pg_hba.conf
         ( eval `${l_prefix}/bin/openpkg rc postgresql status 2>/dev/null`
           echo "postgresql_active=\"$postgresql_active\""
         ) 2>/dev/null
         if [ ".$postgresql_active" = .yes ]; then
             echo "++ reloading already running database engine"
             $l_prefix/bin/openpkg rc postgresql reload
             sleep 2
             epilog=reload
         else
             echo "++ temporarily starting database engine"
             $l_prefix/bin/openpkg rc postgresql start
             sleep 4
             epilog=stop
         fi
         echo "++ rotating dump files $l_prefix/var/postgresql/db.dump*.sql.bz2"
         i=9
         rm -f $l_prefix/var/postgresql/db.dump.$i.sql.bz2 >/dev/null 2>&1 || true
         while [ $i -gt 0 ]; do
             j=$i
             i=`expr $i - 1`
             if [ $i -eq 0 ]; then
                 prev="$l_prefix/var/postgresql/db.dump.sql.bz2"
                 next="$l_prefix/var/postgresql/db.dump.$j.sql.bz2"
             else
                 prev="$l_prefix/var/postgresql/db.dump.$i.sql.bz2"
                 next="$l_prefix/var/postgresql/db.dump.$j.sql.bz2"
             fi
             if [ -f $prev ]; then
                 mv $prev $next
             fi
         done
         echo "++ dumping all databases into $l_prefix/var/postgresql/db.dump.sql.bz2"
         PGPASSWORD="$l_pgpass" \
         $l_prefix/bin/pg_dumpall \
             -U "$l_pguser" -o |\
             $l_prefix/lib/openpkg/bzip2 -9 \
                 >$l_prefix/var/postgresql/db.dump.sql.bz2
         chown ${l_rusr}:${l_rgrp} $l_prefix/var/postgresql/db.dump.sql.bz2
         chmod 700 $l_prefix/var/postgresql/db.dump.sql.bz2
         echo "++ restoring original access policy"
         cp -p $l_prefix/var/postgresql/db/pg_hba.conf.orig \
               $l_prefix/var/postgresql/db/pg_hba.conf
         rm -f $l_prefix/var/postgresql/db/pg_hba.conf.orig
         if [ ".$epilog" = .reload ]; then
             echo "++ reloading already running database engine (again)"
             $l_prefix/bin/openpkg rc postgresql reload
             sleep 2
         else
             echo "++ stopping temporarily started database engine"
             $l_prefix/bin/openpkg rc postgresql stop
             sleep 4
         fi
         ;;
     restore )
         if [ ".`$l_prefix/bin/openpkg rc postgresql status 2>&1 | grep 'is running'`" != . ]; then
             echo "++ stopping already running database engine"
             $l_prefix/bin/openpkg rc postgresql stop
             sleep 2
             epilog=start
         else
             epilog=none
         fi
         echo "++ rotating database directories $l_prefix/var/postgresql/db.old*/"
         i=9
         rm -rf $l_prefix/var/postgresql/db.old.$i >/dev/null 2>&1 || true
         while [ $i -gt 0 ]; do
             j=$i
             i=`expr $i - 1`
             if [ $i -eq 0 ]; then
                 prev="$l_prefix/var/postgresql/db"
                 next="$l_prefix/var/postgresql/db.old.$j"
             else
                 prev="$l_prefix/var/postgresql/db.old.$i"
                 next="$l_prefix/var/postgresql/db.old.$j"
             fi
             if [ -d $prev ]; then
                 mv $prev $next
             fi
         done
         echo "++ creating new database directory $l_prefix/var/postgresql/db/"
         mkdir $l_prefix/var/postgresql/db
         chown ${l_rusr}:${l_rgrp} $l_prefix/var/postgresql/db
         chmod 700 $l_prefix/var/postgresql/db
         su - ${l_rusr} -c \
             "LC_CTYPE=C; export LC_CTYPE; umask 022; \
             echo $l_pgpass >$l_prefix/var/postgresql/run/pw; \
             $l_prefix/bin/pg_initdb \
                 -U $l_pguser --pwfile=$l_prefix/var/postgresql/run/pw \
                 -D $l_prefix/var/postgresql/db; \
             rm -f $l_prefix/var/postgresql/run/pw" 2>&1 |\
         $l_prefix/lib/openpkg/shtool prop \
             -p "++ creating new database data"
         echo "++ restoring database configurations"
         for conf in pg_hba.conf pg_ident.conf postgresql.conf; do
             cp -p $l_prefix/var/postgresql/db.old.1/$conf \
                   $l_prefix/var/postgresql/db/
         done
         echo "++ enforcing full-superuser access policy"
         cp -p $l_prefix/var/postgresql/db/pg_hba.conf \
               $l_prefix/var/postgresql/db/pg_hba.conf.orig
         ( echo "local all all trust"
           echo "host all all 127.0.0.1/32 trust"
         ) >$l_prefix/var/postgresql/db/pg_hba.conf
         if [ ".$epilog" = .start ]; then
             echo "++ starting database engine"
         else
             echo "++ temporarily starting database engine"
         fi
         $l_prefix/bin/openpkg rc postgresql start
         sleep 4
         echo "++ restoring all databases from $l_prefix/var/postgresql/db.dump.sql.bz2"
         $l_prefix/lib/openpkg/bzip2 -c -d \
             $l_prefix/var/postgresql/db.dump.sql.bz2 |\
                 $l_prefix/bin/psql -U "$l_pguser" -d "$l_pgdata" 2>&1 |\
                     tee $l_prefix/var/postgresql/db.log |\
                         $l_prefix/lib/openpkg/shtool prop \
                             -p "++ restoring data (see $l_prefix/var/postgresql/db.log)"
         echo "++ restoring original access policy"
         cp -p $l_prefix/var/postgresql/db/pg_hba.conf.orig \
               $l_prefix/var/postgresql/db/pg_hba.conf
         rm -f $l_prefix/var/postgresql/db/pg_hba.conf.orig
         if [ ".$epilog" = .start ]; then
             echo "++ reloading already running database engine"
             $l_prefix/bin/openpkg rc postgresql reload
             sleep 2
         else
             echo "++ stopping temporarily started database engine"
             $l_prefix/bin/openpkg rc postgresql stop
             sleep 4
         fi
         ;;
     * )
         echo "$0:ERROR: unknown command \"$cmd\"" 1>&2
         exit 1
         ;;
 esac

OpenPKG Specs / annotate

postgresql/pg_migrate@fd611cde817f (annotated)

postgresql/pg_migrate