summaryrefslogtreecommitdiffstats
path: root/extra/postgresql
diff options
context:
space:
mode:
Diffstat (limited to 'extra/postgresql')
-rw-r--r--extra/postgresql/APKBUILD50
-rw-r--r--extra/postgresql/postgresql.confd52
-rw-r--r--extra/postgresql/postgresql.initd113
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 $?
-}
-