diff options
Diffstat (limited to 'extra/postgresql')
| -rw-r--r-- | extra/postgresql/APKBUILD | 50 | ||||
| -rw-r--r-- | extra/postgresql/postgresql.confd | 52 | ||||
| -rw-r--r-- | extra/postgresql/postgresql.initd | 113 |
3 files changed, 0 insertions, 215 deletions
diff --git a/extra/postgresql/APKBUILD b/extra/postgresql/APKBUILD deleted file mode 100644 index a2d921ed1..000000000 --- a/extra/postgresql/APKBUILD +++ /dev/null @@ -1,50 +0,0 @@ -# Maintainer: Natanael Copa <ncopa@alpinelinux.org> -pkgname=postgresql -pkgver=8.3.7 -pkgrel=3 -pkgdesc="A sophisticated object-relational DBMS" -url="http://www.postgresql.org/" -license="BSD" -depends="bbsuid" -makedepends="readline-dev openssl-dev zlib-dev" -subpackages="$pkgname-dev $pkgname-doc libpq $pkgname-client" -source="ftp://ftp.$pkgname.org/pub/source/v$pkgver/$pkgname-$pkgver.tar.bz2 - $pkgname.initd - $pkgname.confd - " - -build() { - cd "$srcdir"/$pkgname-$pkgver || return 1 - ./configure --prefix=/usr \ - --mandir=/usr/share/man \ - --with-docdir=/usr/share/doc \ - --with-openssl \ - || return 1 - - make || return 1 - make DESTDIR="$pkgdir" install || return 1 - - install -D -m755 "$srcdir"/postgresql.initd \ - "$pkgdir"/etc/init.d/postgresql - install -D -m644 "$srcdir"/postgresql.confd \ - "$pkgdir"/etc/conf.d/postgresql || return 1 -} - -libpq() { - depends= - pkgdesc="PostgreSQL libraries" - mkdir -p "$subpkgdir"/usr/lib - mv "$pkgdir"/usr/lib/libpq.so* "$subpkgdir"/usr/lib/ -} - -client() { - depends= - pkgdesc="PostgreSQL client" - mkdir -p "$subpkgdir"/usr/bin - mv "$pkgdir"/usr/bin/psql "$subpkgdir"/usr/bin/ -} - - -md5sums="7b7e91a2221e55fe1b167e663217a96d postgresql-8.3.7.tar.bz2 -6dd7bd7c97252312357a255237115b38 postgresql.initd -ea3320c56a22f5c305199886c2766387 postgresql.confd" diff --git a/extra/postgresql/postgresql.confd b/extra/postgresql/postgresql.confd deleted file mode 100644 index 56561b0c4..000000000 --- a/extra/postgresql/postgresql.confd +++ /dev/null @@ -1,52 +0,0 @@ -# PostgreSQL's Database Directory -PGDATA="/var/lib/postgresql/8.3/data" - -# PostgreSQL User -PGUSER="postgres" - -# PostgreSQL Group -PGGROUP="postgres" - -# Extra options to run postmaster with, e.g.: -# -N is the maximal number of client connections -# -B is the number of shared buffers and has to be at least 2x the value for -N -# Please read the man-page to postmaster for more options. Many of these options -# can be set directly in the configuration-file. -#PGOPTS="-N 512 -B 1024" - - -# SERVER SHUTDOWN: -# The server will receive 3 signals in the worst case: -# 1. SIGTERM -# This signals the server to ignore new connections and to -# wait for all clients to end their transactions before shutting down. -# Use WAIT_FOR_DISCONNECT to control how much time the clients -# should have until the next signal is being sent. -# 2. SIGINT -# Tell the server to forcefully disconnect all clients. -# Terminating a client results in a rollback of the open transactions for this client. -# Use WAIT_FOR_CLEANUP to determine how much time the server has -# for cleanup. -# 3. SIGQUIT -# This will terminate the server immediately and results in a recovery run for the next start. - -# Wait for clients to disconnect -WAIT_FOR_DISCONNECT=30 - -# Time the server has to clean up -WAIT_FOR_CLEANUP=60 - -# Time the server has to quit (with a recover-run on next startup) -# Set to 0 to deactivate it -WAIT_FOR_QUIT=60 - -# Comment this out if you don't want to wait for the server to -# startup before continuing. For example, if this server is a -# PITR log shipping based replication standby -WAIT_FOR_START="-w" - -# If you have to export environment variables for the database process, -# this can be done here. -# -# Example: -# export R_HOME="/usr/lib/R" diff --git a/extra/postgresql/postgresql.initd b/extra/postgresql/postgresql.initd deleted file mode 100644 index 3863a49aa..000000000 --- a/extra/postgresql/postgresql.initd +++ /dev/null @@ -1,113 +0,0 @@ -#!/sbin/runscript -# Copyright 1999-2008 Gentoo Foundation -# Distributed under the terms of the GNU General Public License v2 -# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql-server/files/postgresql.init-8.3,v 1.4 2008/09/28 22:53:02 caleb Exp $ - -opts="${opts} reload setup" - -depend() { - use net -} - -checkconfig() { - if [ ! -d "$PGDATA" ] ; then - eerror "Directory not found: $PGDATA" - eerror "Please make sure that PGDATA points to the right path." - eerror "You can run '/etc/init.d/postgresql setup' to setup a new database cluster." - return 1 - fi -} - -start() { - checkconfig || return 1 - - ebegin "Starting PostgreSQL" - - if [ -f "$PGDATA/postmaster.pid" ] ; then - rm -f "$PGDATA/postmaster.pid" - fi - - local retval - - su -l ${PGUSER} \ - -c "env PGDATA=\"${PGDATA}\" /usr/bin/pg_ctl start ${WAIT_FOR_START} -o '--silent-mode=true ${PGOPTS}'" >/dev/null - retval=$? - [ $retval -ne 0 ] && eend $retval && return $retval - - # The following is to catch the case of an already running server - # in which pg_ctl doesn't know to which server it connected to and false reports the server as 'up' - sleep 2 - if [ ! -f "$PGDATA/postmaster.pid" ] ; then - eerror "The pid-file doesn't exist but pg_ctl reported a running server." - eerror "Please check whether there is another server running on the same port or read the log-file." - eend 1 - return 1 - fi - - local pid=$(grep "^[0-9]\+" "$PGDATA/postmaster.pid") - test -d /proc/"${pid}" - eend $? -} - -stop() { - ebegin "Stopping PostgreSQL (this can take up to $(( ${WAIT_FOR_DISCONNECT} + ${WAIT_FOR_CLEANUP} )) seconds)" - - local retval - - su -l ${PGUSER} \ - -c "env PGDATA=\"${PGDATA}\" /usr/bin/pg_ctl stop -t ${WAIT_FOR_DISCONNECT} -m smart" >/dev/null - - retval=$? - [ $retval -eq 0 ] && eend $retval && return $retval - - ewarn "Some clients did not disconnect within ${WAIT_FOR_DISCONNECT} seconds." - ewarn "Going to shutdown the server anyway." - - su -l ${PGUSER} \ - -c "env PGDATA=\"${PGDATA}\" /usr/bin/pg_ctl stop -m fast" >/dev/null - - retval=$? - [ $retval -eq 0 ] && eend $retval && return $retval - - if [ ${WAIT_FOR_QUIT} -eq 0 ] ; then - eerror "Server did not shut down and sending the SIGQUIT has been disabled." - eend $retval - return $retval - fi - - ewarn "Shutting down the server gracefully failed." - ewarn "Forcing it to shutdown which leads to a recover-run on next startup." - - su -l ${PGUSER} \ - -c "env PGDATA=\"${PGDATA}\" /usr/bin/pg_ctl stop -m immediate" >/dev/null - - retval=$? - [ $retval -eq 0 ] && eend $retval && return $retval - - eerror "Forced shutdown failed!!! Something is wrong with your system, please take care of it manually." - eend $? -} - -reload() { - ebegin "Reloading PostgreSQL configuration" - su -l ${PGUSER} \ - -c "env PGDATA=\"${PGDATA}\" /usr/bin/pg_ctl reload" >/dev/null - eend $? -} - -setup() { - ebegin "Creating a new PostgreSQL database cluster" - if [ -d "${PGDATA}" ] ; then - eend 1 "${PGDATA} already exist" - return - fi - mkdir -p "${PGDATA}" - chown -Rf postgres:postgres "${PGDATA}" - chmod 0700 "${PGDATA}" - cd "${PGDATA}" # to avoid the: could not change directory to "/root" - su -c "/usr/bin/initdb --pgdata ${PGDATA}" postgres - einfo "You can use the '/etc/init.d/postgresql' script to run PostgreSQL instead" - einfo "of 'pg_ctl'." - eend $? -} - |
