##
##  postgresql.spec -- OpenPKG RPM Package Specification
##  Copyright (c) 2000-2006 OpenPKG Foundation e.V. <http://openpkg.net/>
##  Copyright (c) 2000-2006 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.
##

#   package versions
%define       V_postgresql      8.1.2
%define       V_libpqpp         4.0
%define       V_libpqxx         2.5.5
%define       V_pgperl          2.0.2
%define       V_psqlodbc        08.01.0200
%define       V_slony1          1.1.5
%define       V_pgcluster       1.5.0rc5
%define       V_mysqlcompat     1.0b3

#   package information
Name:         postgresql
Summary:      PostgreSQL Database
URL:          http://www.postgresql.org/
Vendor:       PostgreSQL Group
Packager:     OpenPKG
Distribution: OpenPKG
Class:        BASE
Group:        Database
License:      GPL
Version:      %{V_postgresql}
Release:      20060131

#   package options
%option       with_server       yes
%option       with_cxx          no
%option       with_perl         no
%option       with_odbc         no
%option       with_compat       no
%option       with_tcl          no
%option       with_slony1       no
%option       with_pgcluster    no
%option       with_kerberos     no
%option       with_mysqlcompat  no

#   list of sources
Source0:      ftp://ftp.postgresql.org/pub/source/v%{V_postgresql}/postgresql-%{V_postgresql}.tar.gz
Source1:      ftp://gborg.postgresql.org/pub/libpqpp/stable/libpq++-%{V_libpqpp}.tar.gz
Source2:      ftp://gborg.postgresql.org/pub/libpqxx/stable/libpqxx-%{V_libpqxx}.tar.gz
Source3:      ftp://gborg.postgresql.org/pub/pgperl/stable/pgperl-%{V_pgperl}.tar.gz
Source4:      ftp://ftp.postgresql.org/pub/odbc/versions/src/psqlodbc-%{V_psqlodbc}.tar.gz
Source5:      http://developer.postgresql.org/~wieck/slony1/download/slony1-%{V_slony1}.tar.bz2
Source6:      http://pgfoundry.org/frs/download.php/621/pgcluster-%{V_pgcluster}-patch.tar.gz
Source7:      http://pgfoundry.org/frs/download.php/548/mysqlcompat-%{V_pgcluster}.tar.gz
Source8:      rc.postgresql
Source9:      pg_migrate
Patch0:       postgresql.patch

#   build information
Prefix:       %{l_prefix}
BuildRoot:    %{l_buildroot}
BuildPreReq:  OpenPKG, openpkg >= 20040130, make, gcc, flex, bison, gzip
PreReq:       OpenPKG, openpkg >= 20040130
BuildPreReq:  readline, zlib, openssl, getopt
PreReq:       readline, zlib, openssl, getopt
%if "%{with_perl}" == "yes"
BuildPreReq:  perl, perl-openpkg >= 5.8.3-20040126
PreReq:       perl
%endif
%if "%{with_odbc}" == "yes"
BuildPreReq:  unixodbc
PreReq:       unixodbc
%endif
%if "%{with_tcl}" == "yes"
BuildPreReq:  tcl, tcl::with_x11 = yes, X11
PreReq:       tcl, tcl::with_x11 = yes, X11
%endif
%if "%{with_kerberos}" == "yes"
BuildPreReq:  kerberos
PreReq:       kerberos
%endif
AutoReq:      no
AutoReqProv:  no

%description
    PostgreSQL is a sophisticated Object-Relational DBMS, supporting
    almost all SQL constructs, including subselects, transactions,
    and user-defined types and functions. It is the most advanced
    open-source database available anywhere.

    This PostgreSQL package optionally contains two database replication
    solutions: the Slony-I single-master/multiple-slave replication
    engine, and the PGCluster multi-master replication engine.
    Additionally, there is a third option using the OpenPKG PGPool
    package which offers a connection pooling/replication frontend.

%track
    prog postgresql = {
        version   = %{V_postgresql}
        url       = ftp://ftp.postgresql.org/pub/source/
        regex     = v(\d+\.\d+(\.\d+)*)(?!beta)
        url       = ftp://ftp.postgresql.org/pub/source/v__NEWVER__/
        regex     = postgresql-(\d+\.\d+(\.\d+)*)\.tar\.(?:gz|bz2)
    }
    prog postgresql:libpq++ = {
        version   = %{V_libpqpp}
        url       = ftp://gborg.postgresql.org/pub/libpqpp/stable/
        regex     = libpq\+\+-(__VER__)\.tar\.gz
    }
    prog postgresql:libpqxx = {
        version   = %{V_libpqxx}
        url       = ftp://gborg.postgresql.org/pub/libpqxx/stable/
        regex     = libpqxx-(__VER__)\.tar\.gz
    }
    prog postgresql:pgperl = {
        version   = %{V_pgperl}
        url       = ftp://gborg.postgresql.org/pub/pgperl/stable/
        regex     = pgperl-(__VER__)\.tar\.gz
    }
    prog postgresql:psqlodbc = {
        version   = %{V_psqlodbc}
        url       = ftp://ftp.postgresql.org/pub/odbc/versions/src/
        regex     = psqlodbc-(\d{2}\.\d{2}\.\d{4})\.tar\.gz
    }
    prog postgresql:slony1 = {
        version   = %{V_slony1}
        url       = http://developer.postgresql.org/~wieck/slony1/download/
        regex     = slony1-(\d+\.\d+\.\d+)\.tar\.bz2
    }
    prog postgresql:pgcluster = {
        comment   = "rse: beside the filename also the path changes for new versions"
        version   = %{V_pgcluster}
        url       = http://pgfoundry.org/frs/?group_id=1000072&release_id=168
        regex     = pgcluster-(__VER__)-patch\.tar\.gz
    }
    prog postgresql:mysqlcompat = {
        comment   = "rse: beside the filename also the path changes for new versions"
        version   = %{V_mysqlcompat}
        url       = http://pgfoundry.org/frs/?group_id=1000154&release_id=379
        regex     = mysqlcompat-(__VER__)\.tar\.gz
    }

%prep
    %setup -q
    %patch -p0
%if "%{with_cxx}" == "yes"
    %setup -q -T -D -a 1
    %setup -q -T -D -a 2
    case "%{l_platform -t}" in
        *-sunos* )
            %{l_shtool} subst \
                -e 's;strerror_r(0,0,0);strerror((int)0);g' \
                -e 's;strerror_r((int)0, (char \*)0, (size_t)0);strerror((int)0);g' \
                libpqxx-%{V_libpqxx}/configure
            %{l_shtool} subst \
                -e 's;strerror_r(err, buf, sizeof(buf));strerror(err);g' \
                libpqxx-%{V_libpqxx}/src/largeobject.cxx \
                libpqxx-%{V_libpqxx}/configure
            ;;
    esac
%endif
%if "%{with_perl}" == "yes"
    %setup -q -T -D -a 3
%endif
%if "%{with_odbc}" == "yes"
    %setup -q -T -D -a 4
%endif
%if "%{with_slony1}" == "yes"
    %setup -q -T -D -a 5
%endif
%if "%{with_pgcluster}" == "yes"
    %setup -q -T -D -a 6
    cat pgcluster-*-patch |\
    sed -e 's;(char .)\(ptr .= readlen\);\1;' |\
    %{l_patch} -p1
%endif
%if "%{with_mysqlcompat}" == "yes"
    %setup -q -T -D -a 7
%endif
%if "%{with_kerberos}" == "yes"
    %{l_shtool} subst \
        -e 's;krb5 -ldes -lasn1 -lroken;krb5 -lk5crypto -lkrb5support -lcom_err;g' \
        configure
%endif

    #   adjust source tree
    %{l_shtool} subst \
        -e 's;\(#define.*DEFAULT_PGSOCKET_DIR[^"]*"\)/tmp\("\);\1%{l_prefix}/var/postgresql/run\2;' \
        src/include/pg_config_manual.h
    %{l_shtool} subst \
        -e 's;^\(sqlmansect *=\).*$;\1 7;' \
        src/makefiles/Makefile.solaris
    %{l_shtool} subst \
        -e 's;$(INSTALL_SHLIB);#$(INSTALL_SHLIB);g' \
        src/backend/utils/mb/conversion_procs/proc.mk
    %{l_shtool} subst \
        -e 's;# Shared library stuff;enable_shared = yes;g' \
        src/pl/plpgsql/src/Makefile

%build
    rm -rf $RPM_BUILD_ROOT

    #   configure package
    ( echo "ac_cv_func_isinf=no"
    ) >config.cache
    export CC="%{l_cc}"
    export CFLAGS="%{l_cflags -O}"
    export CPPFLAGS="%{l_cppflags readline} -DOPENSSL_DISABLE_OLD_DES_SUPPORT"
    export LDFLAGS="%{l_ldflags}"
%if "%{with_slony1}" == "yes"
    CFLAGS="$CFLAGS -pthread"
%endif
%if "%{with_tcl}" == "yes"
    CPPFLAGS="$CPPFLAGS %{l_cppflags tcl}"
    LDFLAGS="$LDFLAGS -L`%{l_rc} --query x11_libdir`"
%endif
%if "%{with_kerberos}" == "yes"
    CPPFLAGS="$CPPFLAGS %{l_cppflags kerberos}"
    LDFLAGS="$LDFLAGS %{l_ldflags kerberos}"
%endif
    export TAR="%{l_tar}"
    export YACC="bison -y"
    ./configure \
        --cache-file=./config.cache \
        --prefix=%{l_prefix} \
        --sysconfdir=%{l_prefix}/etc/postgresql \
        --includedir=%{l_prefix}/include/postgresql \
        --with-openssl \
        --with-readline \
        --with-zlib \
%if "%{with_tcl}" == "yes"
        --with-tcl \
        --with-tclconfig="%{l_prefix}/lib" \
        --with-tkconfig="%{l_prefix}/lib" \
%endif
%if "%{with_slony1}" == "yes"
        --enable-thread-safety \
%endif
%if "%{with_kerberos}" == "yes"
        --with-krb5 \
        --with-krb-srvnam=postgresql \
%endif
        --disable-syslog \
        --disable-shared

    #   build package
    %{l_make} %{l_mflags}

    #   build C++ bindings (both old and new one)
%if "%{with_cxx}" == "yes"
    ( cd libpq++-%{V_libpqpp}
      CXX="%{l_cxx}"
      CFLAGS="%{l_cflags -O}"
      CPPFLAGS="-DHAVE_NAMESPACE_STD -DHAVE_CXX_STRING_HEADER -DDLLIMPORT= "
      CPPFLAGS="$CPPFLAGS -I. -I../src/interfaces/libpq -I../src/interfaces"
      CPPFLAGS="$CPPFLAGS -I../src/include %{l_cppflags}"
      LDFLAGS="%{l_ldflags}"
      OBJS="pgconnection.o pgdatabase.o pgtransdb.o pgcursordb.o pglobject.o"
      for o in $OBJS; do
          $CXX $CFLAGS $CPPFLAGS $LDFLAGS -c -o $o `echo $o | sed -e 's;\.o$;.cc;'`
      done
      rm -f libpq++.a
      ar rc libpq++.a $OBJS
    ) || exit $?
    ln -s `pwd`/src/interfaces/libpq/*.h src/include/
    ( cd libpqxx-%{V_libpqxx}
      %{l_shtool} subst \
          -e 's;\(cut\)\( .*/configitems\)\( -f [0-9]\);\1\3\2;g' \
          configure
      ( echo "#!/bin/sh"
        echo "case \"\$1\" in"
        echo "   --includedir ) echo \"`pwd`/../src/include\" ;;"
        echo "   --libdir     ) echo \"`pwd`/../src/interfaces/libpq\" ;;"
        echo "esac"
      ) >pg_config
      chmod a+x pg_config
      export PG_CONFIG=`pwd`/pg_config
      export CC="%{l_cc}"
      export CXX="%{l_cxx}"
      export CFLAGS="%{l_cflags -O}"
      export CXXFLAGS="%{l_cxxflags -O}"
      export CPPFLAGS="-I`pwd`/../src/include %{l_cppflags}"
      export LDFLAGS="%{l_ldflags}"
      export LIBS="-lssl -lcrypto -lcrypt"
      case "%{l_platform -t}" in
          *-sunos* ) LIBS="$LIBS -lsocket -lnsl" ;;
      esac
      ./configure \
          --disable-shared
      %{l_make} %{l_mflags -O}
    ) || exit $?
%endif

    #   build Perl bindings
%if "%{with_perl}" == "yes"
    %{l_prefix}/bin/perl-openpkg prepare
    ( cd Pg-%{V_pgperl}
      export POSTGRES_INCLUDE=dummy
      export POSTGRES_LIB=dummy
      %{l_shtool} subst \
          -e 's;-I$POSTGRES_INCLUDE;-I../src/interfaces/libpq -I../src/include;' \
          -e 's;-L$POSTGRES_LIB;-L../src/interfaces/libpq;' \
          -e 's;-lpq;-lpq %{l_ldflags} -lssl -lcrypto -lcrypt;' \
          Makefile.PL
    ) || exit $?
    ( export POSTGRES_INCLUDE=dummy
      export POSTGRES_LIB=dummy
      %{l_prefix}/bin/perl-openpkg -d Pg-%{V_pgperl} configure build
    ) || exit $?
%endif

    #   build ODBC driver
%if "%{with_odbc}" == "yes"
    ( cd psqlodbc-%{V_psqlodbc}
      export CC="%{l_cc}"
      export CXX="%{l_cxx}"
      export CFLAGS="%{l_cflags -O}"
      export CXXFLAGS="%{l_cxxflags -O}"
      export CPPFLAGS="-I`pwd`/../src/include"
      CPPFLAGS="$CPPFLAGS -I`pwd`/../src/interfaces -I`pwd`/../src/interfaces/libpq"
      CPPFLAGS="$CPPFLAGS %{l_cppflags}"
      export LDFLAGS="-L`pwd`/../src/interfaces/libpq %{l_ldflags}"
      ./configure \
          --prefix=%{l_prefix} \
          --with-unixodbc \
          --with-odbcinst=%{l_prefix}/etc/unixodbc
      %{l_make} %{l_mflags -O}
    ) || exit $?
%endif

    #   build Slony-1 replication engine
%if "%{with_slony1}" == "yes"
    ( cd slony1-%{V_slony1}
      ln  ../src/pl/plpgsql/src/libplpgsql.so \
          ../src/pl/plpgsql/src/plpgsql.so
      %{l_shtool} subst \
          -e 's;-lpq;-lpq -lssl -lcrypto -lcrypt;' \
          src/slon/Makefile src/slonik/Makefile
      export CC="%{l_cc}"
      export CFLAGS="%{l_cflags -O}"
      export CPPFLAGS="%{l_cppflags}"
      export LDFLAGS="%{l_ldflags}"
      export LIBS="-lssl -lcrypto -lcrypt"
      ./configure \
          --prefix=%{l_prefix} \
          --sysconfdir=%{l_prefix}/etc/postgresql \
          --with-pgconfigdir=../src/bin/pg_config \
          --with-pgincludedir=../src/include \
          --with-pgincludeserverdir=../src/interfaces/libpq \
          --with-pglibdir=../src/interfaces/libpq \
          --with-pgpkglibdir=../src/pl/plpgsql/src \
          --with-pgsharedir=../src/backend/utils/misc
      %{l_make} %{l_mflags -O}
    ) || exit $?
%endif

    #   rebuild pg_config with hard-coded path to avoid that it provides
    #   dynamically resolved paths which circumvent symlinks, etc.
    ( cd src/bin/pg_config
      %{l_shtool} subst \
          -e 's:find_my_exec(argv.0., mypath):0; strcpy(mypath, "%{l_prefix}/bin/pg_config"):' \
          pg_config.c
      %{l_make} %{l_mflags}
    ) || exit $?

%install
    rm -rf $RPM_BUILD_ROOT

    #   perform standard installation procedure
    cp /dev/null register.txt
    %{l_make} %{l_mflags} install DESTDIR=$RPM_BUILD_ROOT

    #   strip down installation
    rm -rf $RPM_BUILD_ROOT%{l_prefix}/doc
    strip $RPM_BUILD_ROOT%{l_prefix}/bin/* >/dev/null 2>&1 || true
    rm -f $RPM_BUILD_ROOT%{l_prefix}/man/man1/pgaccess.1
    rm -f $RPM_BUILD_ROOT%{l_prefix}/man/man1/pgtclsh.1
    rm -f $RPM_BUILD_ROOT%{l_prefix}/man/man1/pgtksh.1

    #   namespace adjustments to installation
    for prog in \
        createdb createlang createuser dropdb droplang clusterdb \
        dropuser initdb ipcclean vacuumdb; do
%if "%{with_compat}" == "yes"
        cmd="ln"
%else
        cmd="mv"
%endif
        $cmd $RPM_BUILD_ROOT%{l_prefix}/bin/$prog \
             $RPM_BUILD_ROOT%{l_prefix}/bin/pg_$prog
        $cmd $RPM_BUILD_ROOT%{l_prefix}/man/man1/$prog.1 \
             $RPM_BUILD_ROOT%{l_prefix}/man/man1/pg_$prog.1
    done
    ( cd $RPM_BUILD_ROOT%{l_prefix}/man/man7
      for man in *.7; do
          mv $man pg_$man
      done
    ) || exit $?

    #   create additional directories
    %{l_shtool} mkdir -f -p -m 755 \
%if "%{with_slony1}" == "yes" || "%{with_pgcluster}" == "yes"
        $RPM_BUILD_ROOT%{l_prefix}/etc/postgresql \
%endif
        $RPM_BUILD_ROOT%{l_prefix}/var/postgresql/db \
        $RPM_BUILD_ROOT%{l_prefix}/var/postgresql/run

    #   install migration utility
%if "%{with_compat}" == "yes"
    l_pguser="postgres"
    l_pgpass="postgres"
%else
    l_pguser="postgresql"
    l_pgpass="postgresql"
%endif
    %{l_shtool} install -c -m 755 %{l_value -s -a} \
        -e "s;@l_pguser@;${l_pguser};g" \
        -e "s;@l_pgpass@;${l_pgpass};g" \
        %{SOURCE pg_migrate} \
        $RPM_BUILD_ROOT%{l_prefix}/bin/

    #   install C++ bindings (both old and new one)
%if "%{with_cxx}" == "yes"
    ( cd libpq++-%{V_libpqpp}
      %{l_shtool} mkdir -f -p -m 755 \
          $RPM_BUILD_ROOT%{l_prefix}/include/libpq++
      %{l_shtool} install -c -m 644 \
          libpq++.h pgconnection.h pgdatabase.h pgtransdb.h pgcursordb.h pglobject.h \
          $RPM_BUILD_ROOT%{l_prefix}/include/libpq++/
      %{l_shtool} install -c -m 644 \
          libpq++.a \
          $RPM_BUILD_ROOT%{l_prefix}/lib/
    ) || exit $?
    ( cd libpqxx-%{V_libpqxx}
      %{l_shtool} mkdir -f -p -m 755 \
          $RPM_BUILD_ROOT%{l_prefix}/include/pqxx
      %{l_shtool} install -c -m 644 \
          include/pqxx/* \
          $RPM_BUILD_ROOT%{l_prefix}/include/pqxx/
      rm -f $RPM_BUILD_ROOT%{l_prefix}/include/pqxx/Makefile*
      rm -f $RPM_BUILD_ROOT%{l_prefix}/include/pqxx/config.h*
      %{l_shtool} install -c -m 644 \
          src/.libs/libpqxx.a \
          $RPM_BUILD_ROOT%{l_prefix}/lib/
    ) || exit $?
%endif

    #   install Perl binding
%if "%{with_perl}" == "yes"
    ( export POSTGRES_INCLUDE=dummy
      export POSTGRES_LIB=dummy
      %{l_prefix}/bin/perl-openpkg -d Pg-%{V_pgperl} install
    ) || exit $?
    %{l_prefix}/bin/perl-openpkg -F perl-openpkg-files fixate cleanup
%else
    >perl-openpkg-files
%endif

    #   install ODBC driver
%if "%{with_odbc}" == "yes"
    ( cd psqlodbc-%{V_psqlodbc}
      %{l_make} %{l_mflags} install AM_MAKEFLAGS="DESTDIR=$RPM_BUILD_ROOT"
    ) || exit $?
%endif

    #   install Slony-1 replication engine
%if "%{with_slony1}" == "yes"
    ( cd slony1-%{V_slony1}
      %{l_make} %{l_mflags} install \
          DESTDIR=$RPM_BUILD_ROOT \
          pgconfigdir=%{l_prefix}/bin \
          pgincludedir=%{l_prefix}/include/postgresql \
          pgincludeserverdir=%{l_prefix}/include/postgresql/libpq \
          pglibdir=%{l_prefix}/lib/postgresql \
          pgpkglibdir=%{l_prefix}/lib/postgresql \
          pgsharedir=%{l_prefix}/share/postgresql
      rm -f $RPM_BUILD_ROOT%{l_prefix}/share/postgresql/slony1*v7[34].sql
      rm -f $RPM_BUILD_ROOT%{l_prefix}/share/postgresql/xxid.v73.sql
      mv $RPM_BUILD_ROOT%{l_prefix}/share/postgresql/xxid.v74.sql \
         $RPM_BUILD_ROOT%{l_prefix}/share/postgresql/xxid.sql
      ( echo "#   Slony-1 configuration for replication engine slon(1)"
        echo "SLON_CLUSTER_NAME=\"example\""
        echo "SLON_CONNECT_DBNAME=\"example\""
        echo "SLON_CONNECT_USER=\"postgresql\""
        echo "SLON_CONNECT_PASS=\"postgresql\""
        echo "SLON_CONNECT_HOST=\"localhost\""
        echo "SLON_SYNC_INTERVAL=\"10000\""
        echo "SLON_SYNC_TIMEOUT=\"60000\""
        echo "SLON_SYNC_GROUPSIZE=\"6\""
        echo "SLON_SYNC_LOGLEVEL=\"1\""
      ) >$RPM_BUILD_ROOT%{l_prefix}/etc/postgresql/slony1.conf
    ) || exit $?
%endif

    #   post-adjust pgcluster configuration filenames
%if "%{with_pgcluster}" == "yes"
    cp $RPM_BUILD_ROOT%{l_prefix}/share/postgresql/pglb.conf.sample \
       $RPM_BUILD_ROOT%{l_prefix}/etc/postgresql/pglb.conf
    cp $RPM_BUILD_ROOT%{l_prefix}/share/postgresql/pgreplicate.conf.sample \
       $RPM_BUILD_ROOT%{l_prefix}/etc/postgresql/pgreplicate.conf
%endif

    #   install MySQL compatibility layer
%if "%{with_mysqlcompat}" == "yes"
    %{l_shtool} mkdir -f -p -m 755 \
        $RPM_BUILD_ROOT%{l_prefix}/share/postgresql/mysqlcompat
    %{l_shtool} install -c -m 644 \
        mysqlcompat-%{V_mysqlcompat}/README \
        mysqlcompat-%{V_mysqlcompat}/*.sql \
        $RPM_BUILD_ROOT%{l_prefix}/share/postgresql/mysqlcompat/
%endif

    #   install run-command script
    %{l_shtool} mkdir -f -p -m 755 \
        $RPM_BUILD_ROOT%{l_prefix}/etc/rc.d
    %{l_shtool} install -c -m 755 %{l_value -s -a} \
        %{SOURCE rc.postgresql} \
        $RPM_BUILD_ROOT%{l_prefix}/etc/rc.d/

    #   optionally strip down to client-only installation
%if "%{with_server}" != "yes"
    rm -f  $RPM_BUILD_ROOT%{l_prefix}/bin/pg_[a-bd-z]*
    rm -f  $RPM_BUILD_ROOT%{l_prefix}/bin/pg_c[a-np-z]*
    rm -f  $RPM_BUILD_ROOT%{l_prefix}/bin/pg_controldata
    rm -f  $RPM_BUILD_ROOT%{l_prefix}/bin/post*
    rm -f  $RPM_BUILD_ROOT%{l_prefix}/man/man1/pg_[a-bd-z]*
    rm -f  $RPM_BUILD_ROOT%{l_prefix}/man/man1/pg_c[a-np-z]*
    rm -f  $RPM_BUILD_ROOT%{l_prefix}/man/man1/pg_controldata.1
    rm -f  $RPM_BUILD_ROOT%{l_prefix}/man/man1/post*
    rm -rf $RPM_BUILD_ROOT%{l_prefix}/etc/rc.d
    rm -rf $RPM_BUILD_ROOT%{l_prefix}/include/postgresql/server
    rm -rf $RPM_BUILD_ROOT%{l_prefix}/lib/postgresql
    rm -rf $RPM_BUILD_ROOT%{l_prefix}/share/postgresql
    rm -rf $RPM_BUILD_ROOT%{l_prefix}/var/postgresql
%endif

    #   determine installation files
    %{l_rpmtool} files -v -ofiles -r$RPM_BUILD_ROOT \
%if "%{with_server}" == "yes"
        %{l_files_std} `cat perl-openpkg-files` \
%if "%{with_slony1}" == "yes" || "%{with_pgcluster}" == "yes"
        '%config %{l_prefix}/etc/postgresql/*' \
%endif
        '%attr(700,%{l_rusr},%{l_rgrp}) %dir %{l_prefix}/var/postgresql/db' \
        '%attr(755,%{l_rusr},%{l_rgrp}) %dir %{l_prefix}/var/postgresql/run'
%else
        %{l_files_std} `cat perl-openpkg-files`
%endif

%files -f files

%clean
    rm -rf $RPM_BUILD_ROOT

%pre
%if "%{with_server}" == "yes"
    #   before upgrade, check migration dump, save status and stop service
    [ $1 -eq 2 ] || exit 0
    if [ -f $RPM_INSTALL_PREFIX/var/postgresql/db/PG_VERSION -a \
         -f $RPM_INSTALL_PREFIX/bin/pg_migrate ]; then
        #   database migration dumping hint
        v_old_all=`cat $RPM_INSTALL_PREFIX/var/postgresql/db/PG_VERSION`
        v_old_maj=`echo "$v_old_all" | sed -e 's/^\([0-9]*\.[0-9]*\).*/\1/'`
        v_new_all="%{V_postgresql}"
        v_new_maj=`echo "$v_new_all" | sed -e 's/^\([0-9]*\.[0-9]*\).*/\1/'`
        if [ ".$v_old_maj" != ".$v_new_maj" ]; then
           if [ ! -f $RPM_INSTALL_PREFIX/var/postgresql/db.dump.sql.bz2 -a ".$RPM_POSTGRESQL_MIGRATE" != .ignore ]; then
                ( echo "You are upgrading from PostgreSQL $v_old_all to PostgresSQL $v_new_all,"
                  echo "which is a major version change. We expect a database incompatibility,"
                  echo "so we strongly recommend that you backup your existing database"
                  echo "($RPM_INSTALL_PREFIX/var/postgresql/db/) first by running:"
                  echo "    \$ $RPM_INSTALL_PREFIX/bin/pg_migrate dump"
                  echo "If this fails for some reasons, try to dump your data manually:"
                  echo "    \$ $RPM_INSTALL_PREFIX/bin/pg_dumpall -U postgresql -o | \\ "
                  echo "      $RPM_INSTALL_PREFIX/lib/openpkg/bzip2 -9 \\ "
                  echo "      >$RPM_INSTALL_PREFIX/var/postgresql/db.dump.sql.bz2"
                  echo "Alternatively, if you want to force this package to be installed without"
                  echo "performing a database dump, run the following command before upgrading:"
                  echo "    \$ RPM_POSTGRESQL_MIGRATE=ignore; export RPM_POSTGRESQL_MIGRATE"
                ) | %{l_rpmtool} msg -b -t error
                exit 1
            fi
        fi
    fi
    eval `%{l_rc} postgresql status 2>/dev/null | tee %{l_tmpfile}`
    %{l_rc} postgresql stop 2>/dev/null
    exit 0
%endif

%post
%if "%{with_server}" == "yes"
    if [ $1 -eq 1 ]; then
        #   create initial database
%if "%{with_compat}" == "yes"
        l_pguser="postgres"
        l_pgpass="postgres"
%else
        l_pguser="postgresql"
        l_pgpass="postgresql"
%endif
        su - %{l_rusr} -c \
            "LC_CTYPE=C; export LC_CTYPE; umask 022; \
            rm -rf $RPM_INSTALL_PREFIX/var/postgresql/db/*; \
            echo $l_pgpass >$RPM_INSTALL_PREFIX/var/postgresql/run/pw; \
            $RPM_INSTALL_PREFIX/bin/pg_initdb \
                -U $l_pguser --pwfile=$RPM_INSTALL_PREFIX/var/postgresql/run/pw \
                -D $RPM_INSTALL_PREFIX/var/postgresql/db; \
            rm -f $RPM_INSTALL_PREFIX/var/postgresql/run/pw" 2>&1 |\
        $RPM_INSTALL_PREFIX/lib/openpkg/shtool prop \
            -p "Creating initial PostgreSQL DB in $RPM_INSTALL_PREFIX/var/postgresql/db"

        #   adjust initial authentication configuration
        cp $RPM_INSTALL_PREFIX/var/postgresql/db/pg_hba.conf \
           $RPM_INSTALL_PREFIX/var/postgresql/db/pg_hba.conf.old
        ( cat $RPM_INSTALL_PREFIX/var/postgresql/db/pg_hba.conf.old |\
          sed -e 's;^\([^#]\);# \1;' -e 's;^$;#;'
          echo ""
          echo "#   OpenPKG PostgreSQL default access policy"
          echo "local all all                           md5"
          echo "host  all all 127.0.0.1 255.255.255.255 md5"
          echo ""
        ) >$RPM_INSTALL_PREFIX/var/postgresql/db/pg_hba.conf
        rm -f $RPM_INSTALL_PREFIX/var/postgresql/db/pg_hba.conf.old

        #   display information about next steps
        ( echo "An initial PostgreSQL DB was created with the two standard"
          echo "databases 'template0' and 'template1'. The owner of both"
          echo "is the DB user '$l_pguser'. Its initial password is '$l_pgpass'."
          echo "After starting PostgreSQL with"
          echo "    \$ $RPM_INSTALL_PREFIX/etc/rc postgresql start"
          echo "you should immediately change this with the following command:"
          echo "    \$ $RPM_INSTALL_PREFIX/bin/psql -U $l_pguser -d template1 \\"
          echo "      -c \"ALTER USER $l_pguser WITH PASSWORD '<new-password>'\""
          echo "Then you usually create a database for a user <user> with"
          echo "password <password> under path /u/<user>/rdbms with the commands:"
          echo "    \$ mkdir /u/<user>/rdbms"
          echo "    \$ chmod 700 /u/<user>/rdbms"
          echo "    \$ chown %{l_rusr}:%{l_rgrp} /u/<user>/rdbms"
          echo "    \$ $RPM_INSTALL_PREFIX/bin/psql -U $l_pguser -d template1"
          echo "    template1=> CREATE USER <user>"
          echo "                ENCRYPTED PASSWORD '<password>'"
          echo "                NOCREATEDB NOCREATEUSER;"
          echo "    template1=> CREATE TABLESPACE dss OWNER dss"
          echo "                LOCATION '/u/<user>/rdbms';"
          echo "    template1=> CREATE DATABASE <user>"
          echo "    \$ echo 'localhost:*:<user>:<user>:<password>'"
          echo "       >/home/<user>/.pgpass"
        ) | %{l_rpmtool} msg -b -t notice

        #   optionally link into unixODBC
%if "%{with_odbc}" == "yes"
        ( echo "[PostgreSQL]"
          echo "Description     = PostgreSQL ODBC driver"
          echo "Driver          = $RPM_INSTALL_PREFIX/lib/psqlodbc.so"
          echo "Threading       = 2"
        ) | $RPM_INSTALL_PREFIX/bin/odbcinst -i -d -r
%endif
    fi
    if [ $1 -eq 2 ]; then
        #   after upgrade, restore status
        { eval `cat %{l_tmpfile}`; rm -f %{l_tmpfile}; true; } >/dev/null 2>&1
        [ ".$postgresql_active" = .yes ] && %{l_rc} postgresql start
        if [ -f $RPM_INSTALL_PREFIX/var/postgresql/db/PG_VERSION -a ".$PG_MIGRATE" != .ignore ]; then
            #   database migration restoring hint
            v_old_all=`cat $RPM_INSTALL_PREFIX/var/postgresql/db/PG_VERSION`
            v_old_maj=`echo "$v_old_all" | sed -e 's/^\([0-9]*\.[0-9]*\).*/\1/'`
            v_new_all="%{V_postgresql}"
            v_new_maj=`echo "$v_new_all" | sed -e 's/^\([0-9]*\.[0-9]*\).*/\1/'`
            if [ ".$v_old_maj" != ".$v_new_maj" ]; then
                ( echo "You upgraded from PostgreSQL $v_old_all to PostgresSQL $v_new_all,"
                  echo "which is a major version upgrade. We expect a database incompatibility,"
                  echo "so we strongly recommend you to recreate the existing database under"
                  echo "$RPM_INSTALL_PREFIX/var/postgresql/db/ by running the following command:"
                  echo "    \$ $RPM_INSTALL_PREFIX/bin/pg_migrate restore"
                  echo "If this fails for some reasons, try to restore your data manually:"
                  echo "    \$ $RPM_INSTALL_PREFIX/lib/openpkg/bzip2 -d -c \\ "
                  echo "      $RPM_INSTALL_PREFIX/var/postgresql/db.dump.sql.bz2 | \\ "
                  echo "      $RPM_INSTALL_PREFIX/bin/psql -U postgresql -d template1"
                ) | %{l_rpmtool} msg -b -t warn
            fi
        fi
    fi
    exit 0
%endif

%preun
%if "%{with_server}" == "yes"
    #   before erase, stop service and remove log files
    [ $1 -eq 0 ] || exit 0
    %{l_rc} postgresql stop 2>/dev/null
    rm -f $RPM_INSTALL_PREFIX/var/postgresql/run/* >/dev/null 2>&1 || true
    exit 0
%endif