This will become an empty wrapper package
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/postgresql?expand=0&rev=69
This commit is contained in:
parent
e95eb5a09d
commit
2c7873676f
baselibs.confpostgresql-9.1.3.tar.bz2postgresql-README.SuSE.depostgresql-README.SuSE.enpostgresql-atomic-builtins.patchpostgresql-bashprofilepostgresql-conf.patchpostgresql-firewallpostgresql-initpostgresql-libs.changespostgresql-libs.specpostgresql-mkspecfilespostgresql-plperl.patchpostgresql-regress.patchpostgresql-rpmlintrcpostgresql-sle10-timestamptz.patchpostgresql-sysconfigpostgresql.changespostgresql.specpostgresql.spec.in
@ -1,4 +0,0 @@
|
|||||||
libpq5
|
|
||||||
postgresql-devel
|
|
||||||
requires -postgresql-<targettype>
|
|
||||||
requires "libpq5-<targettype> = <version>"
|
|
@ -1,3 +0,0 @@
|
|||||||
version https://git-lfs.github.com/spec/v1
|
|
||||||
oid sha256:7a79800a624031c1d9bc9cdce73cb40050100ac50a82050cbf7bbbd16ac4d5d5
|
|
||||||
size 15582454
|
|
@ -1,43 +0,0 @@
|
|||||||
Die Konfigurationsvariablen für den PostgreSQL Server sind jetzt in
|
|
||||||
der Datei /etc/sysconfig/postgresql zu finden. Viele der
|
|
||||||
Kommandozeilenparameter können inzwischen auch in
|
|
||||||
/var/lib/pgsql/data/postgresql.conf gesetzt werden.
|
|
||||||
|
|
||||||
|
|
||||||
Vor einem Update der PostgreSQL Pakete, bei dem sich die Version
|
|
||||||
zumindest an der zweiten Stelle ändert (z.B. 7.3 auf 7.4) müssen Ihre
|
|
||||||
PostgreSQL Datenbanken mit dem Programm pg_dumpall gesichert
|
|
||||||
werden. Der übliche Aufruf hierfür sieht so aus:
|
|
||||||
|
|
||||||
pg_dumpall > SAVE
|
|
||||||
|
|
||||||
Die Sicherung sollte als Benutzer "postgres" durchgeführt werden.
|
|
||||||
Wenn die Sicherung erfolgreich war, kann der PostgreSQL-Server
|
|
||||||
angehalten werden (als root: "rcpostgresql stop"). Eventuell müssen
|
|
||||||
zusätzlich noch einige Konfigurationsdateien aus /var/lib/pgsql/data
|
|
||||||
gesichert werden, z.B. pg_hba.conf und postgresql.conf .
|
|
||||||
Achtung: seit Version 8.4 muss in pg_hba.conf "ident sameuser" durch
|
|
||||||
"ident" ersetzt werden.
|
|
||||||
|
|
||||||
Danach können Sie die bisherigen Datenbankdateien löschen
|
|
||||||
|
|
||||||
rm -r /var/lib/pgsql/data/*
|
|
||||||
|
|
||||||
oder falls der Platz ausreicht verschieben,
|
|
||||||
|
|
||||||
mv /var/lib/pgsql/data /var/lib/pgsql/data.old
|
|
||||||
|
|
||||||
damit unter /var/lib/pgsql/data die neue Datenbankstruktur angelegt
|
|
||||||
werden kann. Diese wird beim ersten Start des neuen Datenbankservers
|
|
||||||
(als root:"rcpostgresql start") automatisch erstellt.
|
|
||||||
|
|
||||||
Das Zurückspielen der gesicherten Datenbankinhalte und
|
|
||||||
Konfigurationsdateien muß wieder als Benutzer postgres durchgeführt
|
|
||||||
werden:
|
|
||||||
|
|
||||||
psql template1 -f SAVE
|
|
||||||
|
|
||||||
Wenn Sie nach eingehenden Tests sicher sind, daß nach der Migration
|
|
||||||
noch alles vorhanden ist und funktioniert, können Sie die
|
|
||||||
Sicherungsdatei und gegebenenfalls die bei Seite geschobenen alten
|
|
||||||
Datenbankdateien löschen.
|
|
@ -1,40 +0,0 @@
|
|||||||
The configuration variables for the PostgreSQL server are now stored
|
|
||||||
in the /etc/sysconfig/postgresql file. Now, you can set many commando
|
|
||||||
line parameters in /var/lib/pgsql/data/postgresql.conf.
|
|
||||||
|
|
||||||
|
|
||||||
Before updating PostgreSQL packages whose version numbers are to
|
|
||||||
increase by at least the second decimal place or higher (for example,
|
|
||||||
6.4.x to 7.0.x or 7.1.x to 7.2.x), use the pg_dumpall program to back
|
|
||||||
up your PostgreSQL databases. A typical command for doing this is:
|
|
||||||
|
|
||||||
pg_dumpall > SAVE
|
|
||||||
|
|
||||||
Backups should be performed as user "postgres". Once the backup is
|
|
||||||
completed successfully, shut down the PostgreSQL server (as root:
|
|
||||||
"rcpostgresql stop"). Further configuration files in
|
|
||||||
/var/lib/pgsql/data, including pg_hba.conf and postgresql.conf,
|
|
||||||
may need to be backed up as well.
|
|
||||||
Note: since version 8.4, "ident sameuser" needs to be replaced with
|
|
||||||
"ident" in pg_hba.conf.
|
|
||||||
|
|
||||||
Afterwards, delete the previous database files
|
|
||||||
|
|
||||||
rm -r /var/lib/pgsql/data/*
|
|
||||||
|
|
||||||
or, if you have enough space, move it to
|
|
||||||
|
|
||||||
mv /var/lib/pgsql/data /var/lib/pgsql/data.old
|
|
||||||
|
|
||||||
so that the new database structure can be created under
|
|
||||||
/var/lib/pgsql/data when you start the new database server for the
|
|
||||||
first time (as root:"rcpostgresql start").
|
|
||||||
|
|
||||||
The saved contents of the database and the configuration files will
|
|
||||||
then have to be played back as user postgres:
|
|
||||||
|
|
||||||
psql template1 -f SAVE
|
|
||||||
|
|
||||||
If, following exhaustive testing, you are certain that everything is
|
|
||||||
still available and functioning properly after the migration, delete
|
|
||||||
the backup file and the old database files.
|
|
@ -1,173 +0,0 @@
|
|||||||
Description: Use gcc/intel cc builtin atomic operations for test-and-set, if available (http://gcc.gnu.org/onlinedocs/gcc-4.1.2/gcc/Atomic-Builtins.html). Remove the custom implementation for arm as it does not work with recent hardware (like -mthumb2).
|
|
||||||
Author: Martin Pitt <mpitt@debian.org>
|
|
||||||
|
|
||||||
Index: postgresql-9.1-9.1.2/configure.in
|
|
||||||
===================================================================
|
|
||||||
--- postgresql-9.1-9.1.2.orig/configure.in 2011-12-01 22:47:20.000000000 +0100
|
|
||||||
+++ postgresql-9.1-9.1.2/configure.in 2011-12-19 16:54:00.619535943 +0100
|
|
||||||
@@ -1522,6 +1522,18 @@
|
|
||||||
AC_SUBST(LDAP_LIBS_FE)
|
|
||||||
AC_SUBST(LDAP_LIBS_BE)
|
|
||||||
|
|
||||||
+# gcc and intel compiler provide builtin functions for atomic test-and-set
|
|
||||||
+AC_MSG_CHECKING([whether the C compiler provides atomic builtins])
|
|
||||||
+AC_TRY_LINK([], [int lock = 0; __sync_lock_test_and_set(&lock, 1); __sync_lock_release(&lock);],
|
|
||||||
+ [have_cc_atomics="yes"],
|
|
||||||
+ [have_cc_atomics="no"]
|
|
||||||
+)
|
|
||||||
+if test "$have_cc_atomics" = yes; then
|
|
||||||
+ AC_MSG_RESULT(yes)
|
|
||||||
+ AC_DEFINE(HAVE_CC_ATOMICS, 1, [Define to 1 if compiler provides atomic builtins])
|
|
||||||
+else
|
|
||||||
+ AC_MSG_RESULT(no)
|
|
||||||
+fi
|
|
||||||
|
|
||||||
# This test makes sure that run tests work at all. Sometimes a shared
|
|
||||||
# library is found by the linker, but the runtime linker can't find it.
|
|
||||||
Index: postgresql-9.1-9.1.2/configure
|
|
||||||
===================================================================
|
|
||||||
--- postgresql-9.1-9.1.2.orig/configure 2011-12-01 22:47:20.000000000 +0100
|
|
||||||
+++ postgresql-9.1-9.1.2/configure 2011-12-19 16:54:00.635535943 +0100
|
|
||||||
@@ -23602,6 +23602,69 @@
|
|
||||||
|
|
||||||
|
|
||||||
|
|
||||||
+# gcc and intel compiler provide builtin functions for atomic test-and-set
|
|
||||||
+{ $as_echo "$as_me:$LINENO: checking whether the C compiler provides atomic builtins" >&5
|
|
||||||
+$as_echo_n "checking whether the C compiler provides atomic builtins... " >&6; }
|
|
||||||
+cat >conftest.$ac_ext <<_ACEOF
|
|
||||||
+/* confdefs.h. */
|
|
||||||
+_ACEOF
|
|
||||||
+cat confdefs.h >>conftest.$ac_ext
|
|
||||||
+cat >>conftest.$ac_ext <<_ACEOF
|
|
||||||
+/* end confdefs.h. */
|
|
||||||
+
|
|
||||||
+int
|
|
||||||
+main ()
|
|
||||||
+{
|
|
||||||
+int lock = 0; __sync_lock_test_and_set(&lock, 1); __sync_lock_release(&lock);
|
|
||||||
+ ;
|
|
||||||
+ return 0;
|
|
||||||
+}
|
|
||||||
+_ACEOF
|
|
||||||
+rm -f conftest.$ac_objext conftest$ac_exeext
|
|
||||||
+if { (ac_try="$ac_link"
|
|
||||||
+case "(($ac_try" in
|
|
||||||
+ *\"* | *\`* | *\\*) ac_try_echo=\$ac_try;;
|
|
||||||
+ *) ac_try_echo=$ac_try;;
|
|
||||||
+esac
|
|
||||||
+eval ac_try_echo="\"\$as_me:$LINENO: $ac_try_echo\""
|
|
||||||
+$as_echo "$ac_try_echo") >&5
|
|
||||||
+ (eval "$ac_link") 2>conftest.er1
|
|
||||||
+ ac_status=$?
|
|
||||||
+ grep -v '^ *+' conftest.er1 >conftest.err
|
|
||||||
+ rm -f conftest.er1
|
|
||||||
+ cat conftest.err >&5
|
|
||||||
+ $as_echo "$as_me:$LINENO: \$? = $ac_status" >&5
|
|
||||||
+ (exit $ac_status); } && {
|
|
||||||
+ test -z "$ac_c_werror_flag" ||
|
|
||||||
+ test ! -s conftest.err
|
|
||||||
+ } && test -s conftest$ac_exeext && {
|
|
||||||
+ test "$cross_compiling" = yes ||
|
|
||||||
+ $as_test_x conftest$ac_exeext
|
|
||||||
+ }; then
|
|
||||||
+ have_cc_atomics="yes"
|
|
||||||
+else
|
|
||||||
+ $as_echo "$as_me: failed program was:" >&5
|
|
||||||
+sed 's/^/| /' conftest.$ac_ext >&5
|
|
||||||
+
|
|
||||||
+ have_cc_atomics="no"
|
|
||||||
+
|
|
||||||
+fi
|
|
||||||
+
|
|
||||||
+rm -rf conftest.dSYM
|
|
||||||
+rm -f core conftest.err conftest.$ac_objext conftest_ipa8_conftest.oo \
|
|
||||||
+ conftest$ac_exeext conftest.$ac_ext
|
|
||||||
+if test "$have_cc_atomics" = yes; then
|
|
||||||
+ { $as_echo "$as_me:$LINENO: result: yes" >&5
|
|
||||||
+$as_echo "yes" >&6; }
|
|
||||||
+
|
|
||||||
+cat >>confdefs.h <<\_ACEOF
|
|
||||||
+#define HAVE_CC_ATOMICS 1
|
|
||||||
+_ACEOF
|
|
||||||
+
|
|
||||||
+else
|
|
||||||
+ { $as_echo "$as_me:$LINENO: result: no" >&5
|
|
||||||
+$as_echo "no" >&6; }
|
|
||||||
+fi
|
|
||||||
|
|
||||||
# This test makes sure that run tests work at all. Sometimes a shared
|
|
||||||
# library is found by the linker, but the runtime linker can't find it.
|
|
||||||
Index: postgresql-9.1-9.1.2/src/include/pg_config.h.in
|
|
||||||
===================================================================
|
|
||||||
--- postgresql-9.1-9.1.2.orig/src/include/pg_config.h.in 2011-12-01 22:47:20.000000000 +0100
|
|
||||||
+++ postgresql-9.1-9.1.2/src/include/pg_config.h.in 2011-12-19 16:54:00.639535943 +0100
|
|
||||||
@@ -87,6 +87,9 @@
|
|
||||||
/* Define to 1 if you have the `cbrt' function. */
|
|
||||||
#undef HAVE_CBRT
|
|
||||||
|
|
||||||
+/* Define to 1 if compiler provides atomic builtins */
|
|
||||||
+#undef HAVE_CC_ATOMICS
|
|
||||||
+
|
|
||||||
/* Define to 1 if you have the `class' function. */
|
|
||||||
#undef HAVE_CLASS
|
|
||||||
|
|
||||||
Index: postgresql-9.1-9.1.2/src/include/storage/s_lock.h
|
|
||||||
===================================================================
|
|
||||||
--- postgresql-9.1-9.1.2.orig/src/include/storage/s_lock.h 2011-12-01 22:47:20.000000000 +0100
|
|
||||||
+++ postgresql-9.1-9.1.2/src/include/storage/s_lock.h 2011-12-19 16:56:31.135541667 +0100
|
|
||||||
@@ -252,29 +252,6 @@
|
|
||||||
#endif /* __ia64__ || __ia64 */
|
|
||||||
|
|
||||||
|
|
||||||
-#if defined(__arm__) || defined(__arm)
|
|
||||||
-#define HAS_TEST_AND_SET
|
|
||||||
-
|
|
||||||
-typedef unsigned char slock_t;
|
|
||||||
-
|
|
||||||
-#define TAS(lock) tas(lock)
|
|
||||||
-
|
|
||||||
-static __inline__ int
|
|
||||||
-tas(volatile slock_t *lock)
|
|
||||||
-{
|
|
||||||
- register slock_t _res = 1;
|
|
||||||
-
|
|
||||||
- __asm__ __volatile__(
|
|
||||||
- " swpb %0, %0, [%2] \n"
|
|
||||||
-: "+r"(_res), "+m"(*lock)
|
|
||||||
-: "r"(lock)
|
|
||||||
-: "memory");
|
|
||||||
- return (int) _res;
|
|
||||||
-}
|
|
||||||
-
|
|
||||||
-#endif /* __arm__ */
|
|
||||||
-
|
|
||||||
-
|
|
||||||
/* S/390 and S/390x Linux (32- and 64-bit zSeries) */
|
|
||||||
#if defined(__s390__) || defined(__s390x__)
|
|
||||||
#define HAS_TEST_AND_SET
|
|
||||||
@@ -859,6 +836,24 @@
|
|
||||||
|
|
||||||
#endif /* !defined(HAS_TEST_AND_SET) */
|
|
||||||
|
|
||||||
+/*************************************************************************
|
|
||||||
+ * Use compiler provided atomic builtins if available (in particular, gcc and
|
|
||||||
+ * Intel provide them for many platforms).
|
|
||||||
+ */
|
|
||||||
+#if !defined(HAS_TEST_AND_SET) && HAVE_CC_ATOMICS
|
|
||||||
+#define HAS_TEST_AND_SET
|
|
||||||
+typedef int slock_t;
|
|
||||||
+
|
|
||||||
+#define TAS(lock) tas(lock)
|
|
||||||
+#define S_UNLOCK(lock) __sync_lock_release(lock)
|
|
||||||
+
|
|
||||||
+static __inline__ int
|
|
||||||
+tas(volatile slock_t *lock)
|
|
||||||
+{
|
|
||||||
+ return __sync_lock_test_and_set (lock, 1);
|
|
||||||
+}
|
|
||||||
+#endif
|
|
||||||
+
|
|
||||||
|
|
||||||
/* Blow up if we didn't have any way to do spinlocks */
|
|
||||||
#ifndef HAS_TEST_AND_SET
|
|
@ -1,6 +0,0 @@
|
|||||||
|
|
||||||
# Get PGDATA from /etc/sysconfig/postgresql
|
|
||||||
if test -f /etc/sysconfig/postgresql; then
|
|
||||||
eval eval $(sed -n '/^POSTGRES_DATADIR=/s//PGDATA=/p' /etc/sysconfig/postgresql)
|
|
||||||
export PGDATA
|
|
||||||
fi
|
|
@ -1,30 +0,0 @@
|
|||||||
Index: src/backend/utils/misc/postgresql.conf.sample
|
|
||||||
===================================================================
|
|
||||||
--- src/backend/utils/misc/postgresql.conf.sample.orig
|
|
||||||
+++ src/backend/utils/misc/postgresql.conf.sample
|
|
||||||
@@ -273,13 +273,13 @@
|
|
||||||
|
|
||||||
# - Where to Log -
|
|
||||||
|
|
||||||
-#log_destination = 'stderr' # Valid values are combinations of
|
|
||||||
+log_destination = 'stderr' # Valid values are combinations of
|
|
||||||
# stderr, csvlog, syslog, and eventlog,
|
|
||||||
# depending on platform. csvlog
|
|
||||||
# requires logging_collector to be on.
|
|
||||||
|
|
||||||
# This is used when logging to stderr:
|
|
||||||
-#logging_collector = off # Enable capturing of stderr and csvlog
|
|
||||||
+logging_collector = on # Enable capturing of stderr and csvlog
|
|
||||||
# into log files. Required to be on for
|
|
||||||
# csvlogs.
|
|
||||||
# (change requires restart)
|
|
||||||
@@ -374,7 +374,8 @@
|
|
||||||
#log_duration = off
|
|
||||||
#log_error_verbosity = default # terse, default, or verbose messages
|
|
||||||
#log_hostname = off
|
|
||||||
-#log_line_prefix = '' # special values:
|
|
||||||
+log_line_prefix = '%t %d %u '
|
|
||||||
+ # special values:
|
|
||||||
# %a = application name
|
|
||||||
# %u = user name
|
|
||||||
# %d = database name
|
|
@ -1,4 +0,0 @@
|
|||||||
## Name: PostgreSQL Server
|
|
||||||
## Description: Opens TCP port 5432 to allow remote connections to the PostgreSQL server.
|
|
||||||
|
|
||||||
TCP="5432"
|
|
177
postgresql-init
177
postgresql-init
@ -1,177 +0,0 @@
|
|||||||
#!/bin/sh
|
|
||||||
# Copyright (c) 1995-2004 SUSE Linux AG, Nuernberg, Germany.
|
|
||||||
# All rights reserved.
|
|
||||||
#
|
|
||||||
# Author: Kurt Garloff
|
|
||||||
# Please send feedback to http://www.suse.de/feedback/
|
|
||||||
#
|
|
||||||
# /etc/init.d/postgresql
|
|
||||||
# and its symbolic link
|
|
||||||
# /(usr/)sbin/rcpostgresql
|
|
||||||
#
|
|
||||||
# This program is free software; you can redistribute it and/or modify
|
|
||||||
# it under the terms of the GNU General Public License as published by
|
|
||||||
# the Free Software Foundation; either version 2 of the License, or
|
|
||||||
# (at your option) any later version.
|
|
||||||
#
|
|
||||||
# This program is distributed in the hope that it will be useful,
|
|
||||||
# but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
||||||
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
||||||
# GNU General Public License for more details.
|
|
||||||
#
|
|
||||||
# You should have received a copy of the GNU General Public License
|
|
||||||
# along with this program; if not, write to the Free Software
|
|
||||||
# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
|
|
||||||
#
|
|
||||||
# System startup script for PostgreSQL
|
|
||||||
#
|
|
||||||
# LSB compatible service control script; see http://www.linuxbase.org/spec/
|
|
||||||
#
|
|
||||||
### BEGIN INIT INFO
|
|
||||||
# Provides: postgresql
|
|
||||||
# Required-Start: $network $remote_fs
|
|
||||||
# Required-Stop: $network $remote_fs
|
|
||||||
# Default-Start: 3 5
|
|
||||||
# Default-Stop:
|
|
||||||
# Description: Start the PostgreSQL master daemon
|
|
||||||
### END INIT INFO
|
|
||||||
|
|
||||||
# Source SuSE config
|
|
||||||
PG_SYSCONFIG=/etc/sysconfig/postgresql
|
|
||||||
test -f $PG_SYSCONFIG && . $PG_SYSCONFIG
|
|
||||||
|
|
||||||
# Shell functions sourced from /etc/rc.status:
|
|
||||||
# rc_check check and set local and overall rc status
|
|
||||||
# rc_status check and set local and overall rc status
|
|
||||||
# rc_status -v ditto but be verbose in local rc status
|
|
||||||
# rc_status -v -r ditto and clear the local rc status
|
|
||||||
# rc_failed set local and overall rc status to failed
|
|
||||||
# rc_reset clear local rc status (overall remains)
|
|
||||||
# rc_exit exit appropriate to overall rc status
|
|
||||||
. /etc/rc.status
|
|
||||||
|
|
||||||
eval DATADIR=${POSTGRES_DATADIR:-~postgres/data}
|
|
||||||
OPTIONS=${POSTGRES_OPTIONS}
|
|
||||||
H=/usr/bin/postmaster
|
|
||||||
test -x $H || exit 5
|
|
||||||
PIDFILE=$DATADIR/postmaster.pid
|
|
||||||
|
|
||||||
# The echo return value for success (defined in /etc/rc.config).
|
|
||||||
rc_reset
|
|
||||||
|
|
||||||
# Return values acc. to LSB for all commands but status:
|
|
||||||
# 0 - success
|
|
||||||
# 1 - generic or unspecified error
|
|
||||||
# 2 - invalid or excess argument(s)
|
|
||||||
# 3 - unimplemented feature (e.g. "reload")
|
|
||||||
# 4 - insufficient privilege
|
|
||||||
# 5 - program is not installed
|
|
||||||
# 6 - program is not configured
|
|
||||||
# 7 - program is not running
|
|
||||||
#
|
|
||||||
# Note that starting an already running service, stopping
|
|
||||||
# or restarting a not-running service as well as the restart
|
|
||||||
# with force-reload (in case signalling is not supported) are
|
|
||||||
# considered a success.
|
|
||||||
|
|
||||||
pg_ctl () {
|
|
||||||
CMD="/usr/bin/pg_ctl $@"
|
|
||||||
su - postgres -c "LD_LIBRARY_PATH=$LD_LIBRARY_PATH $CMD"
|
|
||||||
}
|
|
||||||
|
|
||||||
case "$1" in
|
|
||||||
start)
|
|
||||||
if [ ! -f $DATADIR/PG_VERSION ]; then
|
|
||||||
echo -n "Initializing the PostgreSQL database at location ${DATADIR}"
|
|
||||||
LANG_SYSCONFIG=/etc/sysconfig/language
|
|
||||||
test -f "$LANG_SYSCONFIG" && . $LANG_SYSCONFIG
|
|
||||||
LANG=${POSTGRES_LANG:-$RC_LANG}
|
|
||||||
INITDB=/usr/bin/initdb
|
|
||||||
install -d -o postgres -g postgres -m 700 ${DATADIR} && su - postgres -c \
|
|
||||||
"$INITDB --locale=$LANG --auth=\"ident\" $DATADIR &> initlog" ||
|
|
||||||
rc_failed
|
|
||||||
rc_status -v
|
|
||||||
rc_status || {
|
|
||||||
echo "You can find a log of the initialisation in ~postgres/initlog ."
|
|
||||||
rc_exit
|
|
||||||
}
|
|
||||||
fi
|
|
||||||
echo -n "Starting PostgreSQL"
|
|
||||||
## remove old socket and pidfile, if they exist
|
|
||||||
## and no daemon is running.
|
|
||||||
checkproc -p $PIDFILE $H || {
|
|
||||||
rm -f /tmp/.s.PGSQL.* $PIDFILE
|
|
||||||
}
|
|
||||||
pg_ctl start -s -w -p $H -D $DATADIR -o "\"$OPTIONS\""
|
|
||||||
rc_status -v
|
|
||||||
;;
|
|
||||||
|
|
||||||
stop)
|
|
||||||
echo -n "Shutting down PostgreSQL"
|
|
||||||
if pg_ctl status -s -D $DATADIR >/dev/null
|
|
||||||
then
|
|
||||||
pg_ctl stop -s -D $DATADIR -m fast
|
|
||||||
else
|
|
||||||
rc_failed 0
|
|
||||||
fi
|
|
||||||
rc_status -v
|
|
||||||
;;
|
|
||||||
|
|
||||||
try-restart)
|
|
||||||
## Stop the service and if this succeeds (i.e. the
|
|
||||||
## service was running before), start it again.
|
|
||||||
## Note: try-restart is not (yet) part of LSB (as of 0.7.5)
|
|
||||||
$0 status && $0 restart
|
|
||||||
;;
|
|
||||||
|
|
||||||
restart)
|
|
||||||
## Stop the service and regardless of whether it was
|
|
||||||
## running or not, start it again.
|
|
||||||
$0 stop
|
|
||||||
$0 start
|
|
||||||
rc_status
|
|
||||||
;;
|
|
||||||
|
|
||||||
force-reload | reload)
|
|
||||||
echo -n "Reloading configuration for PostgreSQL"
|
|
||||||
pg_ctl reload -s -D $DATADIR
|
|
||||||
rc_status -v
|
|
||||||
;;
|
|
||||||
|
|
||||||
status)
|
|
||||||
echo -n "Checking for PostgreSQL: "
|
|
||||||
## Check status with checkproc(8), if process is running
|
|
||||||
## checkproc will return with exit status 0.
|
|
||||||
|
|
||||||
# Status has a slightly different for the status command:
|
|
||||||
# 0 - service running
|
|
||||||
# 1 - service dead, but /var/run/ pid file exists
|
|
||||||
# 2 - service dead, but /var/lock/ lock file exists
|
|
||||||
# 3 - service not running
|
|
||||||
|
|
||||||
# NOTE: checkproc returns LSB compliant status values.
|
|
||||||
pg_ctl status -s -D $DATADIR >/dev/null
|
|
||||||
if ! pg_ctl status -s -D $DATADIR >/dev/null
|
|
||||||
then
|
|
||||||
if test -f $DATADIR/postmaster.pid; then
|
|
||||||
rc_failed 1
|
|
||||||
else
|
|
||||||
rc_failed 3
|
|
||||||
fi
|
|
||||||
fi
|
|
||||||
rc_status -v
|
|
||||||
;;
|
|
||||||
|
|
||||||
probe)
|
|
||||||
rc_failed 3
|
|
||||||
rc_status -v
|
|
||||||
;;
|
|
||||||
|
|
||||||
*)
|
|
||||||
echo "Usage: $0 {start|stop|status|try-restart|restart|force-reload|reload|probe}"
|
|
||||||
exit 1
|
|
||||||
;;
|
|
||||||
esac
|
|
||||||
|
|
||||||
# Inform the caller not only verbosely and set an exit status.
|
|
||||||
rc_exit
|
|
File diff suppressed because it is too large
Load Diff
@ -1,281 +0,0 @@
|
|||||||
#
|
|
||||||
# spec file for package postgresql-libs
|
|
||||||
#
|
|
||||||
# Copyright (c) 2012 SUSE LINUX Products GmbH, Nuernberg, Germany.
|
|
||||||
#
|
|
||||||
# All modifications and additions to the file contributed by third parties
|
|
||||||
# remain the property of their copyright owners, unless otherwise agreed
|
|
||||||
# upon. The license for this file, and modifications and additions to the
|
|
||||||
# file, is the same license as for the pristine package itself (unless the
|
|
||||||
# license for the pristine package is not an Open Source License, in which
|
|
||||||
# case the license is the MIT License). An "Open Source License" is a
|
|
||||||
# license that conforms to the Open Source Definition (Version 1.9)
|
|
||||||
# published by the Open Source Initiative.
|
|
||||||
|
|
||||||
# Please submit bugfixes or comments via http://bugs.opensuse.org/
|
|
||||||
#
|
|
||||||
|
|
||||||
|
|
||||||
%if 0%{?sles_version} && %sles_version <= 11
|
|
||||||
%define libs_package 1
|
|
||||||
%else
|
|
||||||
%define libs_package 0
|
|
||||||
%endif
|
|
||||||
|
|
||||||
Name: postgresql-libs
|
|
||||||
%define _name postgresql
|
|
||||||
%define libpq libpq5
|
|
||||||
%define libecpg libecpg6
|
|
||||||
%define buildall 0
|
|
||||||
%define extensiondir %_datadir/postgresql/extension
|
|
||||||
%if 0%{?suse_version} > 910
|
|
||||||
BuildRequires: krb5-devel libxslt-devel
|
|
||||||
%endif
|
|
||||||
BuildRequires: openldap2-devel openssl-devel
|
|
||||||
Summary: Basic Clients and Utilities for PostgreSQL
|
|
||||||
Version: 9.1.3
|
|
||||||
Release: 2
|
|
||||||
%define pg_minor_version %(echo %version | sed -r 's/^([0-9]+\\.[0-9]+).*/\\1/')
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Group: Productivity/Databases/Tools
|
|
||||||
Source0: postgresql-%version.tar.bz2
|
|
||||||
Source1: baselibs.conf
|
|
||||||
Source2: postgresql-README.SuSE.de
|
|
||||||
Source3: postgresql-README.SuSE.en
|
|
||||||
Source8: postgresql-sysconfig
|
|
||||||
Source9: postgresql-init
|
|
||||||
Source15: postgresql-bashprofile
|
|
||||||
Source16: postgresql-firewall
|
|
||||||
Source17: postgresql-rpmlintrc
|
|
||||||
Source100: postgresql-mkspecfiles
|
|
||||||
Source101: postgresql.spec.in
|
|
||||||
Patch1: postgresql-conf.patch
|
|
||||||
Patch2: postgresql-regress.patch
|
|
||||||
Patch3: postgresql-sle10-timestamptz.patch
|
|
||||||
Patch4: postgresql-plperl.patch
|
|
||||||
Patch5: postgresql-atomic-builtins.patch
|
|
||||||
Url: http://www.postgresql.org/
|
|
||||||
BuildRoot: %{_tmppath}/%{name}-%{version}-build
|
|
||||||
Provides: postgresql = %pg_minor_version
|
|
||||||
|
|
||||||
%description
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package contains the basic utility and client programs necessary
|
|
||||||
to maintain and work with local or remote PostgreSQL databases as well
|
|
||||||
as manual pages for the SQL commands that PostgreSQL supports. Full
|
|
||||||
HTML documentation for PostgreSQL can be found in the postgresql-docs
|
|
||||||
package.
|
|
||||||
|
|
||||||
%if %libs_package
|
|
||||||
|
|
||||||
%package libs
|
|
||||||
License: BSD 3-Clause
|
|
||||||
Summary: Shared Libraries Required for PostgreSQL Clients
|
|
||||||
Group: Productivity/Databases/Clients
|
|
||||||
# bug437293
|
|
||||||
%ifarch ppc64
|
|
||||||
Obsoletes: postgresql-libs-64bit
|
|
||||||
%endif
|
|
||||||
#
|
|
||||||
Provides: postgresql-libs = %pg_minor_version
|
|
||||||
PreReq: sh-utils fileutils
|
|
||||||
|
|
||||||
%description libs
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, user-defined types
|
|
||||||
and functions.
|
|
||||||
|
|
||||||
This package provides the essential shared libraries for (almost) any
|
|
||||||
PostgreSQL client program or interface. You will need to install this
|
|
||||||
package in order to use any other PostgreSQL package or any clients
|
|
||||||
that need to connect to a PostgreSQL server.
|
|
||||||
%else
|
|
||||||
|
|
||||||
%package -n %libpq
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: Shared Libraries Required for PostgreSQL Clients
|
|
||||||
Group: Productivity/Databases/Clients
|
|
||||||
Provides: postgresql-libs = %version
|
|
||||||
Obsoletes: postgresql-libs < %version
|
|
||||||
# bug437293
|
|
||||||
%ifarch ppc64
|
|
||||||
Obsoletes: postgresql-libs-64bit
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%description -n %libpq
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, user-defined types
|
|
||||||
and functions.
|
|
||||||
|
|
||||||
This package provides the client library that most PostgreSQL client
|
|
||||||
program or language bindings are using.
|
|
||||||
|
|
||||||
%package -n %libecpg
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: Shared Libraries Required for PostgreSQL Clients
|
|
||||||
Group: Productivity/Databases/Clients
|
|
||||||
Provides: postgresql-libs:%_libdir/libecpg.so.6
|
|
||||||
|
|
||||||
%description -n %libecpg
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, user-defined types
|
|
||||||
and functions.
|
|
||||||
|
|
||||||
This package provides the runtime library of the embedded SQL C
|
|
||||||
preprocessor for PostgreSQL.
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%package -n %_name-devel
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: PostgreSQL development header files and libraries
|
|
||||||
Group: Productivity/Databases/Tools
|
|
||||||
%if %libs_package
|
|
||||||
Requires: postgresql-libs
|
|
||||||
%else
|
|
||||||
Requires: %libpq %libecpg
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%description -n %_name-devel
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package contains the header files and libraries needed to compile
|
|
||||||
C applications which will directly interact with a PostgreSQL database
|
|
||||||
management server and the ECPG Embedded C Postgres preprocessor. You
|
|
||||||
need to install this package if you want to develop applications in C
|
|
||||||
which will interact with a PostgreSQL server.
|
|
||||||
|
|
||||||
|
|
||||||
%prep
|
|
||||||
%setup -q -n %_name-%version
|
|
||||||
# Keep the timestamp of configure, because patching it would otherwise
|
|
||||||
# confuse PostgreSQL's build system
|
|
||||||
touch -r configure tmp
|
|
||||||
%patch1
|
|
||||||
%patch2
|
|
||||||
# apply the following patch only on SLE10
|
|
||||||
%if 0%{?suse_version} == 1010
|
|
||||||
%patch3 -p1
|
|
||||||
%endif
|
|
||||||
%patch4
|
|
||||||
%ifarch %arm
|
|
||||||
%patch5 -p1
|
|
||||||
%endif
|
|
||||||
touch -r tmp configure
|
|
||||||
rm tmp
|
|
||||||
|
|
||||||
%build
|
|
||||||
export CFLAGS="%optflags $SP"
|
|
||||||
# uncomment the following line to enable the stack protector
|
|
||||||
# CFLAGS="$CFLAGS -fstack-protector"
|
|
||||||
%configure \
|
|
||||||
--includedir=%_includedir/pgsql \
|
|
||||||
--datadir=%_datadir/postgresql \
|
|
||||||
--docdir=%_docdir \
|
|
||||||
--disable-rpath \
|
|
||||||
--enable-nls \
|
|
||||||
--enable-thread-safety \
|
|
||||||
--enable-integer-datetimes \
|
|
||||||
--without-readline \
|
|
||||||
--with-openssl \
|
|
||||||
--with-ldap \
|
|
||||||
%if 0%{?suse_version} > 910
|
|
||||||
--with-gssapi \
|
|
||||||
--with-libxml \
|
|
||||||
--with-libxslt \
|
|
||||||
--with-krb5 \
|
|
||||||
%endif
|
|
||||||
--with-system-tzdata=/usr/share/zoneinfo
|
|
||||||
make -C src/backend %{?jobs:-j%jobs} libpq-recursive
|
|
||||||
make -C src/interfaces %{?jobs:-j%jobs}
|
|
||||||
make -C src/port %{?jobs:-j%jobs} libpgport.a
|
|
||||||
make -C src/bin/pg_config %{?jobs:-j%jobs} pg_config
|
|
||||||
|
|
||||||
%install
|
|
||||||
SUBINSTALL=install
|
|
||||||
install -d %buildroot%_mandir/man1
|
|
||||||
install doc/src/sgml/man1/{ecpg,pg_config}.1 %buildroot%_mandir/man1
|
|
||||||
if test -n "$SUBINSTALL"; then
|
|
||||||
# Install them for postgresql-libs and uninstall them for postgresql
|
|
||||||
make -C src DESTDIR=%buildroot $SUBINSTALL-local
|
|
||||||
for dir in \
|
|
||||||
config \
|
|
||||||
src/bin/pg_config \
|
|
||||||
src/interfaces \
|
|
||||||
src/include \
|
|
||||||
src/makefiles \
|
|
||||||
src/port \
|
|
||||||
src/test/regress
|
|
||||||
do
|
|
||||||
make -C $dir DESTDIR=%buildroot $SUBINSTALL
|
|
||||||
done
|
|
||||||
fi
|
|
||||||
# Don't ship static libraries, libpgport.a is needed, though.
|
|
||||||
rm -f $(ls %buildroot/%_libdir/*.a | grep -F -v libpgport.a)
|
|
||||||
|
|
||||||
%find_lang libpq5-%{pg_minor_version} %libpq.lang
|
|
||||||
%find_lang ecpglib6-%{pg_minor_version} %libecpg.lang
|
|
||||||
cat %libpq.lang %libecpg.lang > postgresql-libs.lang
|
|
||||||
%find_lang ecpg-%{pg_minor_version} %_name-devel.lang
|
|
||||||
%find_lang pg_config-%{pg_minor_version} %_name-devel.lang
|
|
||||||
%if %libs_package
|
|
||||||
|
|
||||||
%post -n postgresql-libs -p /sbin/ldconfig
|
|
||||||
|
|
||||||
%postun -n postgresql-libs -p /sbin/ldconfig
|
|
||||||
%else
|
|
||||||
|
|
||||||
%post -n %libpq -p /sbin/ldconfig
|
|
||||||
|
|
||||||
%postun -n %libpq -p /sbin/ldconfig
|
|
||||||
|
|
||||||
%post -n %libecpg -p /sbin/ldconfig
|
|
||||||
|
|
||||||
%postun -n %libecpg -p /sbin/ldconfig
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%clean
|
|
||||||
rm -rf %buildroot
|
|
||||||
rm -f %my_provides
|
|
||||||
|
|
||||||
%if %libs_package
|
|
||||||
|
|
||||||
%files -n postgresql-libs -f postgresql-libs.lang
|
|
||||||
%else
|
|
||||||
|
|
||||||
%files -n %libpq -f %libpq.lang
|
|
||||||
%endif
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%_libdir/libpq.so.*
|
|
||||||
%if !%libs_package
|
|
||||||
|
|
||||||
%files -n %libecpg -f %libecpg.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%endif
|
|
||||||
%_libdir/libecpg*.so.*
|
|
||||||
%_libdir/libpgtypes.so.*
|
|
||||||
|
|
||||||
%files -n %_name-devel -f %_name-devel.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%doc %_mandir/man1/ecpg.1*
|
|
||||||
%_bindir/pg_config
|
|
||||||
%doc %_mandir/man1/pg_config.1*
|
|
||||||
%_bindir/ecpg
|
|
||||||
%_libdir/libpgport.a
|
|
||||||
%_libdir/lib*.so
|
|
||||||
%dir %_libdir/postgresql
|
|
||||||
%_libdir/postgresql/pgxs
|
|
||||||
%_includedir/pgsql
|
|
||||||
%dir %_datadir/postgresql
|
|
||||||
%_datadir/postgresql/pg_service.conf.sample
|
|
||||||
|
|
||||||
%changelog
|
|
@ -1,12 +0,0 @@
|
|||||||
#!/bin/bash
|
|
||||||
|
|
||||||
sed '/IF_LIBS/,/FI_LIBS/d
|
|
||||||
/IF_POSTGRES/d
|
|
||||||
/FI_POSTGRES/d
|
|
||||||
' postgresql.spec.in > postgresql.spec
|
|
||||||
|
|
||||||
sed '/^Name: /s/$/-libs/
|
|
||||||
/IF_POSTGRES/,/FI_POSTGRES/d
|
|
||||||
/IF_LIBS/d
|
|
||||||
/FI_LIBS/d
|
|
||||||
' postgresql.spec.in > postgresql-libs.spec
|
|
@ -1,30 +0,0 @@
|
|||||||
Index: config/perl.m4
|
|
||||||
===================================================================
|
|
||||||
--- config/perl.m4.orig
|
|
||||||
+++ config/perl.m4
|
|
||||||
@@ -57,9 +57,7 @@ AC_DEFUN([PGAC_CHECK_PERL_CONFIGS],
|
|
||||||
AC_DEFUN([PGAC_CHECK_PERL_EMBED_LDFLAGS],
|
|
||||||
[AC_REQUIRE([PGAC_PATH_PERL])
|
|
||||||
AC_MSG_CHECKING(for flags to link embedded Perl)
|
|
||||||
-pgac_tmp1=`$PERL -MExtUtils::Embed -e ldopts`
|
|
||||||
-pgac_tmp2=`$PERL -MConfig -e 'print $Config{ccdlflags}'`
|
|
||||||
-perl_embed_ldflags=`echo X"$pgac_tmp1" | sed -e "s/^X//" -e "s%$pgac_tmp2%%" -e ["s/ -arch [-a-zA-Z0-9_]*//g"]`
|
|
||||||
+perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts`
|
|
||||||
AC_SUBST(perl_embed_ldflags)dnl
|
|
||||||
if test -z "$perl_embed_ldflags" ; then
|
|
||||||
AC_MSG_RESULT(no)
|
|
||||||
Index: configure
|
|
||||||
===================================================================
|
|
||||||
--- configure.orig
|
|
||||||
+++ configure
|
|
||||||
@@ -7157,9 +7157,7 @@ $as_echo "$perl_useshrplib" >&6; }
|
|
||||||
|
|
||||||
{ $as_echo "$as_me:$LINENO: checking for flags to link embedded Perl" >&5
|
|
||||||
$as_echo_n "checking for flags to link embedded Perl... " >&6; }
|
|
||||||
-pgac_tmp1=`$PERL -MExtUtils::Embed -e ldopts`
|
|
||||||
-pgac_tmp2=`$PERL -MConfig -e 'print $Config{ccdlflags}'`
|
|
||||||
-perl_embed_ldflags=`echo X"$pgac_tmp1" | sed -e "s/^X//" -e "s%$pgac_tmp2%%" -e "s/ -arch [-a-zA-Z0-9_]*//g"`
|
|
||||||
+perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts`
|
|
||||||
if test -z "$perl_embed_ldflags" ; then
|
|
||||||
{ $as_echo "$as_me:$LINENO: result: no" >&5
|
|
||||||
$as_echo "no" >&6; }
|
|
@ -1,70 +0,0 @@
|
|||||||
Index: src/test/regress/expected/horology.out
|
|
||||||
===================================================================
|
|
||||||
--- src/test/regress/expected/horology.out.orig
|
|
||||||
+++ src/test/regress/expected/horology.out
|
|
||||||
@@ -616,26 +616,26 @@ SELECT (timestamp with time zone 'tomorr
|
|
||||||
(1 row)
|
|
||||||
|
|
||||||
-- timestamp with time zone, interval arithmetic around DST change
|
|
||||||
-SET TIME ZONE 'CST7CDT';
|
|
||||||
-SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as "Apr 3, 12:00";
|
|
||||||
+SET TIME ZONE 'CST6CDT';
|
|
||||||
+SELECT timestamp with time zone '2005-04-02 12:00-06' + interval '1 day' as "Apr 3, 12:00";
|
|
||||||
Apr 3, 12:00
|
|
||||||
------------------------------
|
|
||||||
Sun Apr 03 12:00:00 2005 CDT
|
|
||||||
(1 row)
|
|
||||||
|
|
||||||
-SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00";
|
|
||||||
+SELECT timestamp with time zone '2005-04-02 12:00-06' + interval '24 hours' as "Apr 3, 13:00";
|
|
||||||
Apr 3, 13:00
|
|
||||||
------------------------------
|
|
||||||
Sun Apr 03 13:00:00 2005 CDT
|
|
||||||
(1 row)
|
|
||||||
|
|
||||||
-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00";
|
|
||||||
+SELECT timestamp with time zone '2005-04-03 12:00-05' - interval '1 day' as "Apr 2, 12:00";
|
|
||||||
Apr 2, 12:00
|
|
||||||
------------------------------
|
|
||||||
Sat Apr 02 12:00:00 2005 CST
|
|
||||||
(1 row)
|
|
||||||
|
|
||||||
-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as "Apr 2, 11:00";
|
|
||||||
+SELECT timestamp with time zone '2005-04-03 12:00-05' - interval '24 hours' as "Apr 2, 11:00";
|
|
||||||
Apr 2, 11:00
|
|
||||||
------------------------------
|
|
||||||
Sat Apr 02 11:00:00 2005 CST
|
|
||||||
Index: src/test/regress/pg_regress.c
|
|
||||||
===================================================================
|
|
||||||
--- src/test/regress/pg_regress.c.orig
|
|
||||||
+++ src/test/regress/pg_regress.c
|
|
||||||
@@ -72,7 +72,7 @@ static char *shellprog = SHELLPROG;
|
|
||||||
*/
|
|
||||||
#ifndef WIN32
|
|
||||||
const char *basic_diff_opts = "";
|
|
||||||
-const char *pretty_diff_opts = "-C3";
|
|
||||||
+const char *pretty_diff_opts = "-U5";
|
|
||||||
#else
|
|
||||||
const char *basic_diff_opts = "-w";
|
|
||||||
const char *pretty_diff_opts = "-w -C3";
|
|
||||||
Index: src/test/regress/sql/horology.sql
|
|
||||||
===================================================================
|
|
||||||
--- src/test/regress/sql/horology.sql.orig
|
|
||||||
+++ src/test/regress/sql/horology.sql
|
|
||||||
@@ -116,11 +116,11 @@ SELECT (timestamp with time zone 'tomorr
|
|
||||||
SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
|
|
||||||
|
|
||||||
-- timestamp with time zone, interval arithmetic around DST change
|
|
||||||
-SET TIME ZONE 'CST7CDT';
|
|
||||||
-SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as "Apr 3, 12:00";
|
|
||||||
-SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00";
|
|
||||||
-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00";
|
|
||||||
-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as "Apr 2, 11:00";
|
|
||||||
+SET TIME ZONE 'CST6CDT';
|
|
||||||
+SELECT timestamp with time zone '2005-04-02 12:00-06' + interval '1 day' as "Apr 3, 12:00";
|
|
||||||
+SELECT timestamp with time zone '2005-04-02 12:00-06' + interval '24 hours' as "Apr 3, 13:00";
|
|
||||||
+SELECT timestamp with time zone '2005-04-03 12:00-05' - interval '1 day' as "Apr 2, 12:00";
|
|
||||||
+SELECT timestamp with time zone '2005-04-03 12:00-05' - interval '24 hours' as "Apr 2, 11:00";
|
|
||||||
RESET TIME ZONE;
|
|
||||||
|
|
||||||
|
|
@ -1,6 +0,0 @@
|
|||||||
addFilter("useless-explicit-provides")
|
|
||||||
addFilter("unnecessary-buildrequires")
|
|
||||||
addFilter("patch-not-applied")
|
|
||||||
addFilter("non-standard-uid")
|
|
||||||
addFilter("file-not-in-%lang")
|
|
||||||
addFilter("no-dependency-on")
|
|
@ -1,24 +0,0 @@
|
|||||||
Only for SLE10. On other platforms, the test works.
|
|
||||||
poeml, Mon Jul 27 19:12:40 CEST 2009
|
|
||||||
|
|
||||||
diff -uNr postgresql-8.4.0.orig/src/test/regress/expected/timestamptz.out postgresql-8.4.0/src/test/regress/expected/timestamptz.out
|
|
||||||
--- postgresql-8.4.0.orig/src/test/regress/expected/timestamptz.out 2009-03-22 02:12:32.000000000 +0100
|
|
||||||
+++ postgresql-8.4.0/src/test/regress/expected/timestamptz.out 2009-07-27 19:11:39.280087000 +0200
|
|
||||||
@@ -153,7 +153,7 @@
|
|
||||||
SELECT '20500710 173201 Europe/Helsinki'::timestamptz; -- DST
|
|
||||||
timestamptz
|
|
||||||
------------------------------
|
|
||||||
- Sun Jul 10 07:32:01 2050 PDT
|
|
||||||
+ Sun Jul 10 07:32:01 2050 PST
|
|
||||||
(1 row)
|
|
||||||
|
|
||||||
SELECT '20500110 173201 Europe/Helsinki'::timestamptz; -- non-DST
|
|
||||||
@@ -165,7 +165,7 @@
|
|
||||||
SELECT '205000-07-10 17:32:01 Europe/Helsinki'::timestamptz; -- DST
|
|
||||||
timestamptz
|
|
||||||
--------------------------------
|
|
||||||
- Thu Jul 10 07:32:01 205000 PDT
|
|
||||||
+ Thu Jul 10 07:32:01 205000 PST
|
|
||||||
(1 row)
|
|
||||||
|
|
||||||
SELECT '205000-01-10 17:32:01 Europe/Helsinki'::timestamptz; -- non-DST
|
|
@ -1,39 +0,0 @@
|
|||||||
## Path: Applications/PostgreSQL
|
|
||||||
## Description: The PostgreSQL Database System
|
|
||||||
## Type: string()
|
|
||||||
## Default: "~postgres/data"
|
|
||||||
## ServiceRestart: postgresql
|
|
||||||
#
|
|
||||||
# In which directory should the PostgreSQL database reside?
|
|
||||||
#
|
|
||||||
POSTGRES_DATADIR="~postgres/data"
|
|
||||||
|
|
||||||
## Path: Applications/PostgreSQL
|
|
||||||
## Description: The PostgreSQL Database System
|
|
||||||
## Type: string()
|
|
||||||
## Default: ""
|
|
||||||
## ServiceRestart: postgresql
|
|
||||||
#
|
|
||||||
# The options that are given to the PostgreSQL master daemon on startup.
|
|
||||||
# See the manual pages for postmaster and postgres for valid options.
|
|
||||||
#
|
|
||||||
# Don't put "-D datadir" here since it is set by the startup script
|
|
||||||
# based on the variable POSTGRES_DATADIR above.
|
|
||||||
#
|
|
||||||
POSTGRES_OPTIONS=""
|
|
||||||
|
|
||||||
## Path: Applications/PostgreSQL
|
|
||||||
## Description: The PostgreSQL Database System
|
|
||||||
## Type: string()
|
|
||||||
## Default: "C"
|
|
||||||
## ServiceRestart: ""
|
|
||||||
#
|
|
||||||
# Specifies the locale under which the PostgreSQL database location
|
|
||||||
# should be initialized and run. If needed, it has to be changed
|
|
||||||
# before PostgreSQL is started for the first time. To change the
|
|
||||||
# locale of an existsing PostgreSQL database location, it must be
|
|
||||||
# dumped, removed and initialized from scratch using the new locale.
|
|
||||||
#
|
|
||||||
# If unset or empty $RC_LANG from /etc/sysconfig/language is used.
|
|
||||||
#
|
|
||||||
POSTGRES_LANG=""
|
|
1931
postgresql.changes
1931
postgresql.changes
File diff suppressed because it is too large
Load Diff
594
postgresql.spec
594
postgresql.spec
@ -1,594 +0,0 @@
|
|||||||
#
|
|
||||||
# spec file for package postgresql
|
|
||||||
#
|
|
||||||
# Copyright (c) 2012 SUSE LINUX Products GmbH, Nuernberg, Germany.
|
|
||||||
#
|
|
||||||
# All modifications and additions to the file contributed by third parties
|
|
||||||
# remain the property of their copyright owners, unless otherwise agreed
|
|
||||||
# upon. The license for this file, and modifications and additions to the
|
|
||||||
# file, is the same license as for the pristine package itself (unless the
|
|
||||||
# license for the pristine package is not an Open Source License, in which
|
|
||||||
# case the license is the MIT License). An "Open Source License" is a
|
|
||||||
# license that conforms to the Open Source Definition (Version 1.9)
|
|
||||||
# published by the Open Source Initiative.
|
|
||||||
|
|
||||||
# Please submit bugfixes or comments via http://bugs.opensuse.org/
|
|
||||||
#
|
|
||||||
|
|
||||||
|
|
||||||
%if 0%{?sles_version} && %sles_version <= 11
|
|
||||||
%define libs_package 1
|
|
||||||
%else
|
|
||||||
%define libs_package 0
|
|
||||||
%endif
|
|
||||||
|
|
||||||
Name: postgresql
|
|
||||||
BuildRequires: gettext-devel ncurses-devel readline-devel uuid-devel zlib-devel
|
|
||||||
BuildRequires: pam-devel python-devel tcl-devel
|
|
||||||
%if 0%{?suse_version} >= 1110
|
|
||||||
BuildRequires: fdupes
|
|
||||||
%else
|
|
||||||
%define fdupes #
|
|
||||||
%endif
|
|
||||||
%define _name postgresql
|
|
||||||
%define libpq libpq5
|
|
||||||
%define libecpg libecpg6
|
|
||||||
%define buildall 0
|
|
||||||
%define extensiondir %_datadir/postgresql/extension
|
|
||||||
%if 0%{?suse_version} > 910
|
|
||||||
BuildRequires: krb5-devel libxslt-devel
|
|
||||||
%endif
|
|
||||||
BuildRequires: openldap2-devel openssl-devel
|
|
||||||
Summary: Basic Clients and Utilities for PostgreSQL
|
|
||||||
Version: 9.1.3
|
|
||||||
Release: 2
|
|
||||||
%define pg_minor_version %(echo %version | sed -r 's/^([0-9]+\\.[0-9]+).*/\\1/')
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Group: Productivity/Databases/Tools
|
|
||||||
Source0: postgresql-%version.tar.bz2
|
|
||||||
Source1: baselibs.conf
|
|
||||||
Source2: postgresql-README.SuSE.de
|
|
||||||
Source3: postgresql-README.SuSE.en
|
|
||||||
Source8: postgresql-sysconfig
|
|
||||||
Source9: postgresql-init
|
|
||||||
Source15: postgresql-bashprofile
|
|
||||||
Source16: postgresql-firewall
|
|
||||||
Source17: postgresql-rpmlintrc
|
|
||||||
Source100: postgresql-mkspecfiles
|
|
||||||
Source101: postgresql.spec.in
|
|
||||||
Patch1: postgresql-conf.patch
|
|
||||||
Patch2: postgresql-regress.patch
|
|
||||||
Patch3: postgresql-sle10-timestamptz.patch
|
|
||||||
Patch4: postgresql-plperl.patch
|
|
||||||
Patch5: postgresql-atomic-builtins.patch
|
|
||||||
Url: http://www.postgresql.org/
|
|
||||||
BuildRoot: %{_tmppath}/%{name}-%{version}-build
|
|
||||||
Provides: postgresql = %pg_minor_version
|
|
||||||
|
|
||||||
%description
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package contains the basic utility and client programs necessary
|
|
||||||
to maintain and work with local or remote PostgreSQL databases as well
|
|
||||||
as manual pages for the SQL commands that PostgreSQL supports. Full
|
|
||||||
HTML documentation for PostgreSQL can be found in the postgresql-docs
|
|
||||||
package.
|
|
||||||
|
|
||||||
%if %libs_package
|
|
||||||
|
|
||||||
%package libs
|
|
||||||
License: BSD 3-Clause
|
|
||||||
Summary: Shared Libraries Required for PostgreSQL Clients
|
|
||||||
Group: Productivity/Databases/Clients
|
|
||||||
# bug437293
|
|
||||||
%ifarch ppc64
|
|
||||||
Obsoletes: postgresql-libs-64bit
|
|
||||||
%endif
|
|
||||||
#
|
|
||||||
Provides: postgresql-libs = %pg_minor_version
|
|
||||||
PreReq: sh-utils fileutils
|
|
||||||
|
|
||||||
%description libs
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, user-defined types
|
|
||||||
and functions.
|
|
||||||
|
|
||||||
This package provides the essential shared libraries for (almost) any
|
|
||||||
PostgreSQL client program or interface. You will need to install this
|
|
||||||
package in order to use any other PostgreSQL package or any clients
|
|
||||||
that need to connect to a PostgreSQL server.
|
|
||||||
%else
|
|
||||||
|
|
||||||
%package -n %libpq
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: Shared Libraries Required for PostgreSQL Clients
|
|
||||||
Group: Productivity/Databases/Clients
|
|
||||||
Provides: postgresql-libs = %version
|
|
||||||
Obsoletes: postgresql-libs < %version
|
|
||||||
# bug437293
|
|
||||||
%ifarch ppc64
|
|
||||||
Obsoletes: postgresql-libs-64bit
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%description -n %libpq
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, user-defined types
|
|
||||||
and functions.
|
|
||||||
|
|
||||||
This package provides the client library that most PostgreSQL client
|
|
||||||
program or language bindings are using.
|
|
||||||
|
|
||||||
%package -n %libecpg
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: Shared Libraries Required for PostgreSQL Clients
|
|
||||||
Group: Productivity/Databases/Clients
|
|
||||||
Provides: postgresql-libs:%_libdir/libecpg.so.6
|
|
||||||
|
|
||||||
%description -n %libecpg
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, user-defined types
|
|
||||||
and functions.
|
|
||||||
|
|
||||||
This package provides the runtime library of the embedded SQL C
|
|
||||||
preprocessor for PostgreSQL.
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%package server
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: The Programs Needed to Create and Run a PostgreSQL Server
|
|
||||||
Group: Productivity/Databases/Servers
|
|
||||||
PreReq: %insserv_prereq %fillup_prereq
|
|
||||||
PreReq: /usr/sbin/useradd /usr/sbin/groupadd /sbin/chkconfig
|
|
||||||
PreReq: /usr/bin/strings /bin/sed
|
|
||||||
PreReq: postgresql = %pg_minor_version
|
|
||||||
Requires: glibc-locale
|
|
||||||
Provides: postgresql-server = %pg_minor_version
|
|
||||||
|
|
||||||
%package docs
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: HTML Documentation for PostgreSQL
|
|
||||||
Group: Productivity/Databases/Tools
|
|
||||||
%if 0%{?suse_version} >= 1120
|
|
||||||
BuildArch: noarch
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%description docs
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package contains the HTML documentation for PostgreSQL. The start
|
|
||||||
page is: file:///usr/share/doc/packages/postgresql/html/index.html .
|
|
||||||
Manual pages for the PostgreSQL SQL statements can be found in the
|
|
||||||
postgresql package.
|
|
||||||
|
|
||||||
%package contrib
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: Contributed Extensions and Additions to PostgreSQL
|
|
||||||
Group: Productivity/Databases/Tools
|
|
||||||
Requires: postgresql-server = %pg_minor_version
|
|
||||||
|
|
||||||
%description contrib
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
The postgresql-contrib package includes extensions and additions that
|
|
||||||
are distributed along with the PostgreSQL sources, but are not (yet)
|
|
||||||
officially part of the PostgreSQL core.
|
|
||||||
|
|
||||||
Documentation for the modules contained in this package can be found in
|
|
||||||
/usr/share/doc/packages/postgresql/contrib.
|
|
||||||
|
|
||||||
%description server
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, sub-queries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package includes the programs needed to create and run a
|
|
||||||
PostgreSQL server, which will in turn allow you to create and maintain
|
|
||||||
PostgreSQL databases.
|
|
||||||
|
|
||||||
%package -n %_name-devel
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: PostgreSQL development header files and libraries
|
|
||||||
Group: Productivity/Databases/Tools
|
|
||||||
%if %libs_package
|
|
||||||
Requires: postgresql-libs
|
|
||||||
%else
|
|
||||||
Requires: %libpq %libecpg
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%description -n %_name-devel
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package contains the header files and libraries needed to compile
|
|
||||||
C applications which will directly interact with a PostgreSQL database
|
|
||||||
management server and the ECPG Embedded C Postgres preprocessor. You
|
|
||||||
need to install this package if you want to develop applications in C
|
|
||||||
which will interact with a PostgreSQL server.
|
|
||||||
|
|
||||||
%package plperl
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL
|
|
||||||
Group: Productivity/Databases/Servers
|
|
||||||
Requires: perl = %perl_version
|
|
||||||
Obsoletes: postgresql-pl
|
|
||||||
Provides: postgresql-pl:%_libdir/postgresql/plperl.so
|
|
||||||
Requires: postgresql-server = %pg_minor_version
|
|
||||||
|
|
||||||
%description plperl
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package contains the PL/Perl procedural language for PostgreSQL.
|
|
||||||
With this module one can use Perl to write stored procedures,
|
|
||||||
functions, and triggers.
|
|
||||||
|
|
||||||
%package plpython
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: The PL/Python Procedural Languages for PostgreSQL
|
|
||||||
Group: Productivity/Databases/Servers
|
|
||||||
Obsoletes: postgresql-pl
|
|
||||||
Provides: postgresql-pl:%_libdir/postgresql/plpython.so
|
|
||||||
Requires: python
|
|
||||||
Requires: postgresql-server = %pg_minor_version
|
|
||||||
|
|
||||||
%description plpython
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package contains the PL/Python procedural language for PostgreSQL.
|
|
||||||
With this module one can use Python to write stored procedures,
|
|
||||||
functions, and triggers.
|
|
||||||
|
|
||||||
%package pltcl
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: PL/Tcl Procedural Language for PostgreSQL
|
|
||||||
Group: Productivity/Databases/Tools
|
|
||||||
Obsoletes: postgresql-pl
|
|
||||||
Provides: postgresql-pl:%_libdir/postgresql/pltcl.so
|
|
||||||
Requires: tcl
|
|
||||||
Requires: postgresql-server = %pg_minor_version
|
|
||||||
|
|
||||||
%description pltcl
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package contains the PL/Tcl procedural language for PostgreSQL.
|
|
||||||
With thie module one can use Tcl to write stored procedures, functions,
|
|
||||||
and triggers.
|
|
||||||
|
|
||||||
%prep
|
|
||||||
%setup -q -n %_name-%version
|
|
||||||
# Keep the timestamp of configure, because patching it would otherwise
|
|
||||||
# confuse PostgreSQL's build system
|
|
||||||
touch -r configure tmp
|
|
||||||
%patch1
|
|
||||||
%patch2
|
|
||||||
# apply the following patch only on SLE10
|
|
||||||
%if 0%{?suse_version} == 1010
|
|
||||||
%patch3 -p1
|
|
||||||
%endif
|
|
||||||
%patch4
|
|
||||||
%ifarch %arm
|
|
||||||
%patch5 -p1
|
|
||||||
%endif
|
|
||||||
touch -r tmp configure
|
|
||||||
rm tmp
|
|
||||||
|
|
||||||
%build
|
|
||||||
export CFLAGS="%optflags $SP"
|
|
||||||
# uncomment the following line to enable the stack protector
|
|
||||||
# CFLAGS="$CFLAGS -fstack-protector"
|
|
||||||
%configure \
|
|
||||||
--includedir=%_includedir/pgsql \
|
|
||||||
--datadir=%_datadir/postgresql \
|
|
||||||
--docdir=%_docdir \
|
|
||||||
--disable-rpath \
|
|
||||||
--enable-nls \
|
|
||||||
--enable-thread-safety \
|
|
||||||
--enable-integer-datetimes \
|
|
||||||
--with-python \
|
|
||||||
--with-perl \
|
|
||||||
--with-tcl \
|
|
||||||
--with-tclconfig=%_libdir \
|
|
||||||
--with-pam \
|
|
||||||
--with-ossp-uuid \
|
|
||||||
--with-openssl \
|
|
||||||
--with-ldap \
|
|
||||||
%if 0%{?suse_version} > 910
|
|
||||||
--with-gssapi \
|
|
||||||
--with-libxml \
|
|
||||||
--with-libxslt \
|
|
||||||
--with-krb5 \
|
|
||||||
%endif
|
|
||||||
--with-system-tzdata=/usr/share/zoneinfo
|
|
||||||
make %{?_smp_mflags} world
|
|
||||||
%ifnarch %arm
|
|
||||||
%if 0%{?suse_version} > 910
|
|
||||||
|
|
||||||
%check
|
|
||||||
#
|
|
||||||
# Run the regression tests.
|
|
||||||
#
|
|
||||||
make check || {
|
|
||||||
for f in src/test/regress/log/* regression.diffs; do
|
|
||||||
if test -f $f; then
|
|
||||||
cat $f
|
|
||||||
fi
|
|
||||||
done
|
|
||||||
exit 1
|
|
||||||
}
|
|
||||||
%endif
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%install
|
|
||||||
make DESTDIR=%buildroot install install-docs
|
|
||||||
SUBINSTALL=uninstall
|
|
||||||
%if !%buildall
|
|
||||||
rm -f %buildroot%_mandir/*/ecpg*
|
|
||||||
rm -f %buildroot%_mandir/*/pg_config*
|
|
||||||
%endif
|
|
||||||
if test -n "$SUBINSTALL"; then
|
|
||||||
# Install them for postgresql-libs and uninstall them for postgresql
|
|
||||||
make -C src DESTDIR=%buildroot $SUBINSTALL-local
|
|
||||||
for dir in \
|
|
||||||
config \
|
|
||||||
src/bin/pg_config \
|
|
||||||
src/interfaces \
|
|
||||||
src/include \
|
|
||||||
src/makefiles \
|
|
||||||
src/port \
|
|
||||||
src/test/regress
|
|
||||||
do
|
|
||||||
make -C $dir DESTDIR=%buildroot $SUBINSTALL
|
|
||||||
done
|
|
||||||
fi
|
|
||||||
# Don't ship static libraries, libpgport.a is needed, though.
|
|
||||||
rm -f $(ls %buildroot/%_libdir/*.a | grep -F -v libpgport.a)
|
|
||||||
|
|
||||||
#
|
|
||||||
# Install and collect the contrib stuff
|
|
||||||
#
|
|
||||||
touch flag; sleep 1 # otherwise we have installed files that are not newer than flag
|
|
||||||
make DESTDIR=%buildroot -C contrib install
|
|
||||||
find %buildroot -type f -cnewer flag -printf "/%%P\n" |
|
|
||||||
grep -v %_docdir > files.contrib
|
|
||||||
rm flag
|
|
||||||
for f in /etc/init.d /var/adm/fillup-templates /usr/sbin \
|
|
||||||
/etc/sysconfig/SuSEfirewall2.d/services
|
|
||||||
do
|
|
||||||
install -d %buildroot/$f
|
|
||||||
done
|
|
||||||
install -m 755 %{SOURCE9} %buildroot/etc/init.d/postgresql
|
|
||||||
install -m 644 %{SOURCE8} %buildroot/var/adm/fillup-templates/sysconfig.postgresql
|
|
||||||
%if 0%{?suse_version} > 1020
|
|
||||||
install -m 644 %SOURCE16 %buildroot/etc/sysconfig/SuSEfirewall2.d/services/postgresql
|
|
||||||
%endif
|
|
||||||
ln -s ../../etc/init.d/postgresql %buildroot/usr/sbin/rcpostgresql
|
|
||||||
install -d -m 750 %buildroot/var/lib/pgsql
|
|
||||||
install -d -m 700 %buildroot/var/lib/pgsql/data
|
|
||||||
sed 's,@LIBDIR@,%_libdir,g' %{SOURCE15} > \
|
|
||||||
%buildroot/var/lib/pgsql/.bash_profile
|
|
||||||
# Backup directory for old version binaries
|
|
||||||
install -d %buildroot%_libdir/postgresql/backup
|
|
||||||
cp doc/KNOWN_BUGS doc/MISSING_FEATURES COPYRIGHT \
|
|
||||||
README HISTORY doc/bug.template %buildroot%_docdir/postgresql
|
|
||||||
cp -a %SOURCE2 %buildroot%_docdir/postgresql/README.SuSE.de
|
|
||||||
cp -a %SOURCE3 %buildroot%_docdir/postgresql/README.SuSE.en
|
|
||||||
for appname in pg_dump pgscripts psql;do
|
|
||||||
%find_lang $appname-%{pg_minor_version} %{name}.lang
|
|
||||||
done
|
|
||||||
%if %buildall
|
|
||||||
%find_lang libpq5-%{pg_minor_version} %libpq.lang
|
|
||||||
%find_lang ecpglib6-%{pg_minor_version} %libecpg.lang
|
|
||||||
cat %libpq.lang %libecpg.lang > postgresql-libs.lang
|
|
||||||
%find_lang ecpg-%{pg_minor_version} %_name-devel.lang
|
|
||||||
%find_lang pg_config-%{pg_minor_version} %_name-devel.lang
|
|
||||||
%endif
|
|
||||||
for serverapp in initdb postgres pg_controldata pg_ctl pg_resetxlog plpgsql pg_basebackup;do
|
|
||||||
%find_lang $serverapp-%{pg_minor_version} %{name}-server.lang
|
|
||||||
done
|
|
||||||
for pl in plperl plpython pltcl; do
|
|
||||||
%find_lang $pl-%{pg_minor_version} $pl.lang
|
|
||||||
done
|
|
||||||
%fdupes %buildroot
|
|
||||||
|
|
||||||
%post server
|
|
||||||
%fillup_and_insserv
|
|
||||||
|
|
||||||
%postun server
|
|
||||||
%restart_on_update postgresql
|
|
||||||
%insserv_cleanup
|
|
||||||
exit 0
|
|
||||||
|
|
||||||
%preun server
|
|
||||||
%stop_on_removal postgresql
|
|
||||||
exit 0
|
|
||||||
|
|
||||||
%pre server
|
|
||||||
groupadd -g 26 -o -r postgres >/dev/null 2>/dev/null || :
|
|
||||||
useradd -g postgres -o -r -d /var/lib/pgsql -s /bin/bash \
|
|
||||||
-c "PostgreSQL Server" -u 26 postgres 2>/dev/null || :
|
|
||||||
%if %libs_package
|
|
||||||
|
|
||||||
%post -n postgresql-libs -p /sbin/ldconfig
|
|
||||||
|
|
||||||
%postun -n postgresql-libs -p /sbin/ldconfig
|
|
||||||
%else
|
|
||||||
|
|
||||||
%post -n %libpq -p /sbin/ldconfig
|
|
||||||
|
|
||||||
%postun -n %libpq -p /sbin/ldconfig
|
|
||||||
|
|
||||||
%post -n %libecpg -p /sbin/ldconfig
|
|
||||||
|
|
||||||
%postun -n %libecpg -p /sbin/ldconfig
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%clean
|
|
||||||
rm -rf %buildroot
|
|
||||||
rm -f %my_provides
|
|
||||||
|
|
||||||
%files -f %{name}.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%doc %_mandir/man7/*
|
|
||||||
%docdir %_docdir/postgresql
|
|
||||||
%dir %_docdir/postgresql
|
|
||||||
%_docdir/postgresql/[[:upper:]]*
|
|
||||||
%_docdir/postgresql/bug.template
|
|
||||||
# command line tools
|
|
||||||
%_bindir/createdb
|
|
||||||
%doc %_mandir/man1/createdb.1*
|
|
||||||
%_bindir/clusterdb
|
|
||||||
%doc %_mandir/man1/clusterdb.1*
|
|
||||||
%_bindir/createlang
|
|
||||||
%doc %_mandir/man1/createlang.1*
|
|
||||||
%_bindir/createuser
|
|
||||||
%doc %_mandir/man1/createuser.1*
|
|
||||||
%_bindir/dropdb
|
|
||||||
%doc %_mandir/man1/dropdb.1*
|
|
||||||
%_bindir/droplang
|
|
||||||
%doc %_mandir/man1/droplang.1*
|
|
||||||
%_bindir/dropuser
|
|
||||||
%doc %_mandir/man1/dropuser.1*
|
|
||||||
%_bindir/pg_dump
|
|
||||||
%doc %_mandir/man1/pg_dump.1*
|
|
||||||
%_bindir/pg_dumpall
|
|
||||||
%doc %_mandir/man1/pg_dumpall.1*
|
|
||||||
%_bindir/pg_restore
|
|
||||||
%doc %_mandir/man1/pg_restore.1*
|
|
||||||
%_bindir/psql
|
|
||||||
%doc %_mandir/man1/psql.1*
|
|
||||||
%_bindir/vacuumdb
|
|
||||||
%doc %_mandir/man1/vacuumdb.1*
|
|
||||||
%_bindir/reindexdb
|
|
||||||
%doc %_mandir/man1/reindexdb.1.*
|
|
||||||
%_bindir/pg_basebackup
|
|
||||||
%doc %_mandir/man1/pg_basebackup.1.*
|
|
||||||
|
|
||||||
%files docs
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%doc %_mandir/man3/*
|
|
||||||
%docdir %_docdir/postgresql
|
|
||||||
%dir %_docdir/postgresql
|
|
||||||
%_docdir/postgresql/html
|
|
||||||
|
|
||||||
%files contrib -f files.contrib
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%docdir %_docdir/postgresql
|
|
||||||
%dir %_docdir/postgresql
|
|
||||||
%_docdir/postgresql/extension
|
|
||||||
%dir %_datadir/postgresql
|
|
||||||
|
|
||||||
%files server -f %{name}-server.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%dir %extensiondir
|
|
||||||
%config /etc/init.d/postgresql
|
|
||||||
%config /var/adm/fillup-templates/sysconfig.postgresql
|
|
||||||
%if 0%{?suse_version} > 1020
|
|
||||||
%config /etc/sysconfig/SuSEfirewall2.d/services/postgresql
|
|
||||||
%endif
|
|
||||||
%_sbindir/rcpostgresql
|
|
||||||
%dir %_libdir/postgresql
|
|
||||||
%_libdir/postgresql/backup
|
|
||||||
%_libdir/postgresql/plpgsql.so
|
|
||||||
%_libdir/postgresql/dict_snowball.so
|
|
||||||
%_datadir/postgresql/tsearch_data
|
|
||||||
%exclude %_datadir/postgresql/tsearch_data/unaccent.rules
|
|
||||||
%exclude %_datadir/postgresql/tsearch_data/xsyn_sample.rules
|
|
||||||
%_bindir/initdb
|
|
||||||
%doc %_mandir/man1/initdb.1*
|
|
||||||
%_bindir/pg_ctl
|
|
||||||
%doc %_mandir/man1/pg_ctl.1*
|
|
||||||
%_bindir/pg_controldata
|
|
||||||
%doc %_mandir/man1/pg_controldata.1*
|
|
||||||
%_bindir/pg_resetxlog
|
|
||||||
%doc %_mandir/man1/pg_resetxlog.1*
|
|
||||||
%_bindir/postgres
|
|
||||||
%doc %_mandir/man1/postgres.1*
|
|
||||||
%_bindir/postmaster
|
|
||||||
%doc %_mandir/man1/postmaster.1*
|
|
||||||
%dir %_datadir/postgresql
|
|
||||||
%_datadir/postgresql/timezone*
|
|
||||||
%_datadir/postgresql/*.*
|
|
||||||
%exclude %_datadir/postgresql/*.pltcl
|
|
||||||
%_libdir/postgresql/*_and_*.so
|
|
||||||
%_libdir/postgresql/euc2004_sjis2004.so
|
|
||||||
%_libdir/postgresql/libpqwalreceiver.so
|
|
||||||
%extensiondir/plpgsql*
|
|
||||||
%attr(750,postgres,postgres) %dir /var/lib/pgsql
|
|
||||||
%attr(700,postgres,postgres) %dir /var/lib/pgsql/data
|
|
||||||
%attr(640,postgres,postgres) %config(noreplace) /var/lib/pgsql/.bash_profile
|
|
||||||
|
|
||||||
%files pltcl -f pltcl.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%extensiondir/pltcl*
|
|
||||||
%_libdir/postgresql/pltcl.so
|
|
||||||
%_datadir/postgresql/*.pltcl
|
|
||||||
%_bindir/pltcl*
|
|
||||||
|
|
||||||
%files plperl -f plperl.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%extensiondir/plperl*
|
|
||||||
%_libdir/postgresql/plperl.so
|
|
||||||
|
|
||||||
%files plpython -f plpython.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%extensiondir/plpython*
|
|
||||||
%_libdir/postgresql/plpython*.so
|
|
||||||
|
|
||||||
%if %buildall
|
|
||||||
%if %libs_package
|
|
||||||
|
|
||||||
%files -n postgresql-libs -f postgresql-libs.lang
|
|
||||||
%else
|
|
||||||
|
|
||||||
%files -n %libpq -f %libpq.lang
|
|
||||||
%endif
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%_libdir/libpq.so.*
|
|
||||||
%if !%libs_package
|
|
||||||
|
|
||||||
%files -n %libecpg -f %libecpg.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%endif
|
|
||||||
%_libdir/libecpg*.so.*
|
|
||||||
%_libdir/libpgtypes.so.*
|
|
||||||
|
|
||||||
%files -n %_name-devel -f %_name-devel.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%doc %_mandir/man1/ecpg.1*
|
|
||||||
%_bindir/pg_config
|
|
||||||
%doc %_mandir/man1/pg_config.1*
|
|
||||||
%_bindir/ecpg
|
|
||||||
%_libdir/libpgport.a
|
|
||||||
%_libdir/lib*.so
|
|
||||||
%dir %_libdir/postgresql
|
|
||||||
%_libdir/postgresql/pgxs
|
|
||||||
%_includedir/pgsql
|
|
||||||
%dir %_datadir/postgresql
|
|
||||||
%_datadir/postgresql/pg_service.conf.sample
|
|
||||||
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%changelog
|
|
@ -1,615 +0,0 @@
|
|||||||
#
|
|
||||||
# spec file for package postgresql
|
|
||||||
#
|
|
||||||
# Copyright (c) 2011 SUSE LINUX Products GmbH, Nuernberg, Germany.
|
|
||||||
#
|
|
||||||
# All modifications and additions to the file contributed by third parties
|
|
||||||
# remain the property of their copyright owners, unless otherwise agreed
|
|
||||||
# upon. The license for this file, and modifications and additions to the
|
|
||||||
# file, is the same license as for the pristine package itself (unless the
|
|
||||||
# license for the pristine package is not an Open Source License, in which
|
|
||||||
# case the license is the MIT License). An "Open Source License" is a
|
|
||||||
# license that conforms to the Open Source Definition (Version 1.9)
|
|
||||||
# published by the Open Source Initiative.
|
|
||||||
|
|
||||||
# Please submit bugfixes or comments via http://bugs.opensuse.org/
|
|
||||||
#
|
|
||||||
|
|
||||||
%if 0%{?sles_version} && %sles_version <= 11
|
|
||||||
%define libs_package 1
|
|
||||||
%else
|
|
||||||
%define libs_package 0
|
|
||||||
%endif
|
|
||||||
|
|
||||||
Name: postgresql
|
|
||||||
IF_POSTGRES
|
|
||||||
BuildRequires: gettext-devel zlib-devel ncurses-devel readline-devel uuid-devel
|
|
||||||
BuildRequires: pam-devel python-devel tcl-devel
|
|
||||||
%if 0%{?suse_version} >= 1110
|
|
||||||
BuildRequires: fdupes
|
|
||||||
%else
|
|
||||||
%define fdupes #
|
|
||||||
%endif
|
|
||||||
FI_POSTGRES
|
|
||||||
%define _name postgresql
|
|
||||||
%define libpq libpq5
|
|
||||||
%define libecpg libecpg6
|
|
||||||
%define buildall 0
|
|
||||||
%define extensiondir %_datadir/postgresql/extension
|
|
||||||
%if 0%{?suse_version} > 910
|
|
||||||
BuildRequires: krb5-devel libxslt-devel
|
|
||||||
%endif
|
|
||||||
BuildRequires: openldap2-devel openssl-devel
|
|
||||||
Summary: Basic Clients and Utilities for PostgreSQL
|
|
||||||
Version: 9.1.3
|
|
||||||
Release: 2
|
|
||||||
%define pg_minor_version %(echo %version | sed -r 's/^([0-9]+\\.[0-9]+).*/\\1/')
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Group: Productivity/Databases/Tools
|
|
||||||
Source0: postgresql-%version.tar.bz2
|
|
||||||
Source1: baselibs.conf
|
|
||||||
Source2: postgresql-README.SuSE.de
|
|
||||||
Source3: postgresql-README.SuSE.en
|
|
||||||
Source8: postgresql-sysconfig
|
|
||||||
Source9: postgresql-init
|
|
||||||
Source15: postgresql-bashprofile
|
|
||||||
Source16: postgresql-firewall
|
|
||||||
Source17: postgresql-rpmlintrc
|
|
||||||
Source100: postgresql-mkspecfiles
|
|
||||||
Source101: postgresql.spec.in
|
|
||||||
Patch1: postgresql-conf.patch
|
|
||||||
Patch2: postgresql-regress.patch
|
|
||||||
Patch3: postgresql-sle10-timestamptz.patch
|
|
||||||
Patch4: postgresql-plperl.patch
|
|
||||||
Patch5: postgresql-atomic-builtins.patch
|
|
||||||
Url: http://www.postgresql.org/
|
|
||||||
BuildRoot: %{_tmppath}/%{name}-%{version}-build
|
|
||||||
Provides: postgresql = %pg_minor_version
|
|
||||||
%description
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package contains the basic utility and client programs necessary
|
|
||||||
to maintain and work with local or remote PostgreSQL databases as well
|
|
||||||
as manual pages for the SQL commands that PostgreSQL supports. Full
|
|
||||||
HTML documentation for PostgreSQL can be found in the postgresql-docs
|
|
||||||
package.
|
|
||||||
|
|
||||||
%if %libs_package
|
|
||||||
%package libs
|
|
||||||
License: BSD 3-Clause
|
|
||||||
Summary: Shared Libraries Required for PostgreSQL Clients
|
|
||||||
Group: Productivity/Databases/Clients
|
|
||||||
# bug437293
|
|
||||||
%ifarch ppc64
|
|
||||||
Obsoletes: postgresql-libs-64bit
|
|
||||||
%endif
|
|
||||||
#
|
|
||||||
Provides: postgresql-libs = %pg_minor_version
|
|
||||||
PreReq: sh-utils fileutils
|
|
||||||
|
|
||||||
%description libs
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, user-defined types
|
|
||||||
and functions.
|
|
||||||
|
|
||||||
This package provides the essential shared libraries for (almost) any
|
|
||||||
PostgreSQL client program or interface. You will need to install this
|
|
||||||
package in order to use any other PostgreSQL package or any clients
|
|
||||||
that need to connect to a PostgreSQL server.
|
|
||||||
%else
|
|
||||||
%package -n %libpq
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: Shared Libraries Required for PostgreSQL Clients
|
|
||||||
Group: Productivity/Databases/Clients
|
|
||||||
Provides: postgresql-libs = %version
|
|
||||||
Obsoletes: postgresql-libs < %version
|
|
||||||
# bug437293
|
|
||||||
%ifarch ppc64
|
|
||||||
Obsoletes: postgresql-libs-64bit
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%description -n %libpq
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, user-defined types
|
|
||||||
and functions.
|
|
||||||
|
|
||||||
This package provides the client library that most PostgreSQL client
|
|
||||||
program or language bindings are using.
|
|
||||||
|
|
||||||
%package -n %libecpg
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: Shared Libraries Required for PostgreSQL Clients
|
|
||||||
Group: Productivity/Databases/Clients
|
|
||||||
Provides: postgresql-libs:%_libdir/libecpg.so.6
|
|
||||||
|
|
||||||
%description -n %libecpg
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, user-defined types
|
|
||||||
and functions.
|
|
||||||
|
|
||||||
This package provides the runtime library of the embedded SQL C
|
|
||||||
preprocessor for PostgreSQL.
|
|
||||||
%endif
|
|
||||||
|
|
||||||
IF_POSTGRES
|
|
||||||
%package server
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: The Programs Needed to Create and Run a PostgreSQL Server
|
|
||||||
Group: Productivity/Databases/Servers
|
|
||||||
PreReq: %insserv_prereq %fillup_prereq
|
|
||||||
PreReq: /usr/sbin/useradd /usr/sbin/groupadd /sbin/chkconfig
|
|
||||||
PreReq: /usr/bin/strings /bin/sed
|
|
||||||
PreReq: postgresql = %pg_minor_version
|
|
||||||
Requires: glibc-locale
|
|
||||||
Provides: postgresql-server = %pg_minor_version
|
|
||||||
|
|
||||||
%package docs
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: HTML Documentation for PostgreSQL
|
|
||||||
Group: Productivity/Databases/Tools
|
|
||||||
%if 0%{?suse_version} >= 1120
|
|
||||||
BuildArch: noarch
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%description docs
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package contains the HTML documentation for PostgreSQL. The start
|
|
||||||
page is: file:///usr/share/doc/packages/postgresql/html/index.html .
|
|
||||||
Manual pages for the PostgreSQL SQL statements can be found in the
|
|
||||||
postgresql package.
|
|
||||||
|
|
||||||
%package contrib
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: Contributed Extensions and Additions to PostgreSQL
|
|
||||||
Group: Productivity/Databases/Tools
|
|
||||||
Requires: postgresql-server = %pg_minor_version
|
|
||||||
|
|
||||||
%description contrib
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
The postgresql-contrib package includes extensions and additions that
|
|
||||||
are distributed along with the PostgreSQL sources, but are not (yet)
|
|
||||||
officially part of the PostgreSQL core.
|
|
||||||
|
|
||||||
Documentation for the modules contained in this package can be found in
|
|
||||||
/usr/share/doc/packages/postgresql/contrib.
|
|
||||||
|
|
||||||
%description server
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, sub-queries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package includes the programs needed to create and run a
|
|
||||||
PostgreSQL server, which will in turn allow you to create and maintain
|
|
||||||
PostgreSQL databases.
|
|
||||||
|
|
||||||
FI_POSTGRES
|
|
||||||
%package -n %_name-devel
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: PostgreSQL development header files and libraries
|
|
||||||
Group: Productivity/Databases/Tools
|
|
||||||
%if %libs_package
|
|
||||||
Requires: postgresql-libs
|
|
||||||
%else
|
|
||||||
Requires: %libpq %libecpg
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%description -n %_name-devel
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package contains the header files and libraries needed to compile
|
|
||||||
C applications which will directly interact with a PostgreSQL database
|
|
||||||
management server and the ECPG Embedded C Postgres preprocessor. You
|
|
||||||
need to install this package if you want to develop applications in C
|
|
||||||
which will interact with a PostgreSQL server.
|
|
||||||
|
|
||||||
IF_POSTGRES
|
|
||||||
%package plperl
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL
|
|
||||||
Group: Productivity/Databases/Servers
|
|
||||||
Requires: perl = %perl_version
|
|
||||||
Obsoletes: postgresql-pl
|
|
||||||
Provides: postgresql-pl:%_libdir/postgresql/plperl.so
|
|
||||||
Requires: postgresql-server = %pg_minor_version
|
|
||||||
|
|
||||||
%description plperl
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package contains the PL/Perl procedural language for PostgreSQL.
|
|
||||||
With this module one can use Perl to write stored procedures,
|
|
||||||
functions, and triggers.
|
|
||||||
|
|
||||||
%package plpython
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: The PL/Python Procedural Languages for PostgreSQL
|
|
||||||
Group: Productivity/Databases/Servers
|
|
||||||
Obsoletes: postgresql-pl
|
|
||||||
Provides: postgresql-pl:%_libdir/postgresql/plpython.so
|
|
||||||
Requires: python
|
|
||||||
Requires: postgresql-server = %pg_minor_version
|
|
||||||
|
|
||||||
%description plpython
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package contains the PL/Python procedural language for PostgreSQL.
|
|
||||||
With this module one can use Python to write stored procedures,
|
|
||||||
functions, and triggers.
|
|
||||||
|
|
||||||
%package pltcl
|
|
||||||
License: BSD3c(or similar)
|
|
||||||
Summary: PL/Tcl Procedural Language for PostgreSQL
|
|
||||||
Group: Productivity/Databases/Tools
|
|
||||||
Obsoletes: postgresql-pl
|
|
||||||
Provides: postgresql-pl:%_libdir/postgresql/pltcl.so
|
|
||||||
Requires: tcl
|
|
||||||
Requires: postgresql-server = %pg_minor_version
|
|
||||||
|
|
||||||
%description pltcl
|
|
||||||
PostgreSQL is an advanced object-relational database management system
|
|
||||||
that supports an extended subset of the SQL standard, including
|
|
||||||
transactions, foreign keys, subqueries, triggers, and user-defined
|
|
||||||
types and functions.
|
|
||||||
|
|
||||||
This package contains the PL/Tcl procedural language for PostgreSQL.
|
|
||||||
With thie module one can use Tcl to write stored procedures, functions,
|
|
||||||
and triggers.
|
|
||||||
FI_POSTGRES
|
|
||||||
|
|
||||||
%prep
|
|
||||||
%setup -q -n %_name-%version
|
|
||||||
# Keep the timestamp of configure, because patching it would otherwise
|
|
||||||
# confuse PostgreSQL's build system
|
|
||||||
touch -r configure tmp
|
|
||||||
%patch1
|
|
||||||
%patch2
|
|
||||||
# apply the following patch only on SLE10
|
|
||||||
%if 0%{?suse_version} == 1010
|
|
||||||
%patch3 -p1
|
|
||||||
%endif
|
|
||||||
%patch4
|
|
||||||
%ifarch %arm
|
|
||||||
%patch5 -p1
|
|
||||||
%endif
|
|
||||||
touch -r tmp configure
|
|
||||||
rm tmp
|
|
||||||
|
|
||||||
|
|
||||||
%build
|
|
||||||
export CFLAGS="%optflags $SP"
|
|
||||||
# uncomment the following line to enable the stack protector
|
|
||||||
# CFLAGS="$CFLAGS -fstack-protector"
|
|
||||||
%configure \
|
|
||||||
--includedir=%_includedir/pgsql \
|
|
||||||
--datadir=%_datadir/postgresql \
|
|
||||||
--docdir=%_docdir \
|
|
||||||
--disable-rpath \
|
|
||||||
--enable-nls \
|
|
||||||
--enable-thread-safety \
|
|
||||||
--enable-integer-datetimes \
|
|
||||||
IF_POSTGRES
|
|
||||||
--with-python \
|
|
||||||
--with-perl \
|
|
||||||
--with-tcl \
|
|
||||||
--with-tclconfig=%_libdir \
|
|
||||||
--with-pam \
|
|
||||||
--with-ossp-uuid \
|
|
||||||
FI_POSTGRES
|
|
||||||
IF_LIBS
|
|
||||||
--without-readline \
|
|
||||||
FI_LIBS
|
|
||||||
--with-openssl \
|
|
||||||
--with-ldap \
|
|
||||||
%if 0%{?suse_version} > 910
|
|
||||||
--with-gssapi \
|
|
||||||
--with-libxml \
|
|
||||||
--with-libxslt \
|
|
||||||
--with-krb5 \
|
|
||||||
%endif
|
|
||||||
--with-system-tzdata=/usr/share/zoneinfo
|
|
||||||
IF_LIBS
|
|
||||||
make -C src/backend %{?jobs:-j%jobs} libpq-recursive
|
|
||||||
make -C src/interfaces %{?jobs:-j%jobs}
|
|
||||||
make -C src/port %{?jobs:-j%jobs} libpgport.a
|
|
||||||
make -C src/bin/pg_config %{?jobs:-j%jobs} pg_config
|
|
||||||
FI_LIBS
|
|
||||||
IF_POSTGRES
|
|
||||||
make %{?_smp_mflags} world
|
|
||||||
%ifnarch %arm
|
|
||||||
%if 0%{?suse_version} > 910
|
|
||||||
|
|
||||||
%check
|
|
||||||
#
|
|
||||||
# Run the regression tests.
|
|
||||||
#
|
|
||||||
make check || {
|
|
||||||
for f in src/test/regress/log/* regression.diffs; do
|
|
||||||
if test -f $f; then
|
|
||||||
cat $f
|
|
||||||
fi
|
|
||||||
done
|
|
||||||
exit 1
|
|
||||||
}
|
|
||||||
%endif
|
|
||||||
%endif
|
|
||||||
FI_POSTGRES
|
|
||||||
|
|
||||||
%install
|
|
||||||
IF_POSTGRES
|
|
||||||
make DESTDIR=%buildroot install install-docs
|
|
||||||
SUBINSTALL=uninstall
|
|
||||||
%if !%buildall
|
|
||||||
rm -f %buildroot%_mandir/*/ecpg*
|
|
||||||
rm -f %buildroot%_mandir/*/pg_config*
|
|
||||||
%endif
|
|
||||||
FI_POSTGRES
|
|
||||||
IF_LIBS
|
|
||||||
SUBINSTALL=install
|
|
||||||
install -d %buildroot%_mandir/man1
|
|
||||||
install doc/src/sgml/man1/{ecpg,pg_config}.1 %buildroot%_mandir/man1
|
|
||||||
FI_LIBS
|
|
||||||
if test -n "$SUBINSTALL"; then
|
|
||||||
# Install them for postgresql-libs and uninstall them for postgresql
|
|
||||||
make -C src DESTDIR=%buildroot $SUBINSTALL-local
|
|
||||||
for dir in \
|
|
||||||
config \
|
|
||||||
src/bin/pg_config \
|
|
||||||
src/interfaces \
|
|
||||||
src/include \
|
|
||||||
src/makefiles \
|
|
||||||
src/port \
|
|
||||||
src/test/regress
|
|
||||||
do
|
|
||||||
make -C $dir DESTDIR=%buildroot $SUBINSTALL
|
|
||||||
done
|
|
||||||
fi
|
|
||||||
# Don't ship static libraries, libpgport.a is needed, though.
|
|
||||||
rm -f $(ls %buildroot/%_libdir/*.a | grep -F -v libpgport.a)
|
|
||||||
|
|
||||||
IF_POSTGRES
|
|
||||||
#
|
|
||||||
# Install and collect the contrib stuff
|
|
||||||
#
|
|
||||||
touch flag; sleep 1 # otherwise we have installed files that are not newer than flag
|
|
||||||
make DESTDIR=%buildroot -C contrib install
|
|
||||||
find %buildroot -type f -cnewer flag -printf "/%%P\n" |
|
|
||||||
grep -v %_docdir > files.contrib
|
|
||||||
rm flag
|
|
||||||
for f in /etc/init.d /var/adm/fillup-templates /usr/sbin \
|
|
||||||
/etc/sysconfig/SuSEfirewall2.d/services
|
|
||||||
do
|
|
||||||
install -d %buildroot/$f
|
|
||||||
done
|
|
||||||
install -m 755 %{SOURCE9} %buildroot/etc/init.d/postgresql
|
|
||||||
install -m 644 %{SOURCE8} %buildroot/var/adm/fillup-templates/sysconfig.postgresql
|
|
||||||
%if 0%{?suse_version} > 1020
|
|
||||||
install -m 644 %SOURCE16 %buildroot/etc/sysconfig/SuSEfirewall2.d/services/postgresql
|
|
||||||
%endif
|
|
||||||
ln -s ../../etc/init.d/postgresql %buildroot/usr/sbin/rcpostgresql
|
|
||||||
install -d -m 750 %buildroot/var/lib/pgsql
|
|
||||||
install -d -m 700 %buildroot/var/lib/pgsql/data
|
|
||||||
sed 's,@LIBDIR@,%_libdir,g' %{SOURCE15} > \
|
|
||||||
%buildroot/var/lib/pgsql/.bash_profile
|
|
||||||
# Backup directory for old version binaries
|
|
||||||
install -d %buildroot%_libdir/postgresql/backup
|
|
||||||
cp doc/KNOWN_BUGS doc/MISSING_FEATURES COPYRIGHT \
|
|
||||||
README HISTORY doc/bug.template %buildroot%_docdir/postgresql
|
|
||||||
cp -a %SOURCE2 %buildroot%_docdir/postgresql/README.SuSE.de
|
|
||||||
cp -a %SOURCE3 %buildroot%_docdir/postgresql/README.SuSE.en
|
|
||||||
for appname in pg_dump pgscripts psql;do
|
|
||||||
%find_lang $appname-%{pg_minor_version} %{name}.lang
|
|
||||||
done
|
|
||||||
%if %buildall
|
|
||||||
FI_POSTGRES
|
|
||||||
%find_lang libpq5-%{pg_minor_version} %libpq.lang
|
|
||||||
%find_lang ecpglib6-%{pg_minor_version} %libecpg.lang
|
|
||||||
cat %libpq.lang %libecpg.lang > postgresql-libs.lang
|
|
||||||
%find_lang ecpg-%{pg_minor_version} %_name-devel.lang
|
|
||||||
%find_lang pg_config-%{pg_minor_version} %_name-devel.lang
|
|
||||||
IF_POSTGRES
|
|
||||||
%endif
|
|
||||||
for serverapp in initdb postgres pg_controldata pg_ctl pg_resetxlog plpgsql pg_basebackup;do
|
|
||||||
%find_lang $serverapp-%{pg_minor_version} %{name}-server.lang
|
|
||||||
done
|
|
||||||
for pl in plperl plpython pltcl; do
|
|
||||||
%find_lang $pl-%{pg_minor_version} $pl.lang
|
|
||||||
done
|
|
||||||
%fdupes %buildroot
|
|
||||||
|
|
||||||
%post server
|
|
||||||
%fillup_and_insserv
|
|
||||||
|
|
||||||
%postun server
|
|
||||||
%restart_on_update postgresql
|
|
||||||
%insserv_cleanup
|
|
||||||
exit 0
|
|
||||||
|
|
||||||
%preun server
|
|
||||||
%stop_on_removal postgresql
|
|
||||||
exit 0
|
|
||||||
|
|
||||||
%pre server
|
|
||||||
groupadd -g 26 -o -r postgres >/dev/null 2>/dev/null || :
|
|
||||||
useradd -g postgres -o -r -d /var/lib/pgsql -s /bin/bash \
|
|
||||||
-c "PostgreSQL Server" -u 26 postgres 2>/dev/null || :
|
|
||||||
FI_POSTGRES
|
|
||||||
%if %libs_package
|
|
||||||
%post -n postgresql-libs -p /sbin/ldconfig
|
|
||||||
%postun -n postgresql-libs -p /sbin/ldconfig
|
|
||||||
%else
|
|
||||||
%post -n %libpq -p /sbin/ldconfig
|
|
||||||
%postun -n %libpq -p /sbin/ldconfig
|
|
||||||
%post -n %libecpg -p /sbin/ldconfig
|
|
||||||
%postun -n %libecpg -p /sbin/ldconfig
|
|
||||||
%endif
|
|
||||||
|
|
||||||
%clean
|
|
||||||
rm -rf %buildroot
|
|
||||||
rm -f %my_provides
|
|
||||||
|
|
||||||
IF_POSTGRES
|
|
||||||
%files -f %{name}.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%doc %_mandir/man7/*
|
|
||||||
%docdir %_docdir/postgresql
|
|
||||||
%dir %_docdir/postgresql
|
|
||||||
%_docdir/postgresql/[[:upper:]]*
|
|
||||||
%_docdir/postgresql/bug.template
|
|
||||||
# command line tools
|
|
||||||
%_bindir/createdb
|
|
||||||
%doc %_mandir/man1/createdb.1*
|
|
||||||
%_bindir/clusterdb
|
|
||||||
%doc %_mandir/man1/clusterdb.1*
|
|
||||||
%_bindir/createlang
|
|
||||||
%doc %_mandir/man1/createlang.1*
|
|
||||||
%_bindir/createuser
|
|
||||||
%doc %_mandir/man1/createuser.1*
|
|
||||||
%_bindir/dropdb
|
|
||||||
%doc %_mandir/man1/dropdb.1*
|
|
||||||
%_bindir/droplang
|
|
||||||
%doc %_mandir/man1/droplang.1*
|
|
||||||
%_bindir/dropuser
|
|
||||||
%doc %_mandir/man1/dropuser.1*
|
|
||||||
%_bindir/pg_dump
|
|
||||||
%doc %_mandir/man1/pg_dump.1*
|
|
||||||
%_bindir/pg_dumpall
|
|
||||||
%doc %_mandir/man1/pg_dumpall.1*
|
|
||||||
%_bindir/pg_restore
|
|
||||||
%doc %_mandir/man1/pg_restore.1*
|
|
||||||
%_bindir/psql
|
|
||||||
%doc %_mandir/man1/psql.1*
|
|
||||||
%_bindir/vacuumdb
|
|
||||||
%doc %_mandir/man1/vacuumdb.1*
|
|
||||||
%_bindir/reindexdb
|
|
||||||
%doc %_mandir/man1/reindexdb.1.*
|
|
||||||
%_bindir/pg_basebackup
|
|
||||||
%doc %_mandir/man1/pg_basebackup.1.*
|
|
||||||
|
|
||||||
%files docs
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%doc %_mandir/man3/*
|
|
||||||
%docdir %_docdir/postgresql
|
|
||||||
%dir %_docdir/postgresql
|
|
||||||
%_docdir/postgresql/html
|
|
||||||
|
|
||||||
%files contrib -f files.contrib
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%docdir %_docdir/postgresql
|
|
||||||
%dir %_docdir/postgresql
|
|
||||||
%_docdir/postgresql/extension
|
|
||||||
%dir %_datadir/postgresql
|
|
||||||
|
|
||||||
%files server -f %{name}-server.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%dir %extensiondir
|
|
||||||
%config /etc/init.d/postgresql
|
|
||||||
%config /var/adm/fillup-templates/sysconfig.postgresql
|
|
||||||
%if 0%{?suse_version} > 1020
|
|
||||||
%config /etc/sysconfig/SuSEfirewall2.d/services/postgresql
|
|
||||||
%endif
|
|
||||||
%_sbindir/rcpostgresql
|
|
||||||
%dir %_libdir/postgresql
|
|
||||||
%_libdir/postgresql/backup
|
|
||||||
%_libdir/postgresql/plpgsql.so
|
|
||||||
%_libdir/postgresql/dict_snowball.so
|
|
||||||
%_datadir/postgresql/tsearch_data
|
|
||||||
%exclude %_datadir/postgresql/tsearch_data/unaccent.rules
|
|
||||||
%exclude %_datadir/postgresql/tsearch_data/xsyn_sample.rules
|
|
||||||
%_bindir/initdb
|
|
||||||
%doc %_mandir/man1/initdb.1*
|
|
||||||
%_bindir/pg_ctl
|
|
||||||
%doc %_mandir/man1/pg_ctl.1*
|
|
||||||
%_bindir/pg_controldata
|
|
||||||
%doc %_mandir/man1/pg_controldata.1*
|
|
||||||
%_bindir/pg_resetxlog
|
|
||||||
%doc %_mandir/man1/pg_resetxlog.1*
|
|
||||||
%_bindir/postgres
|
|
||||||
%doc %_mandir/man1/postgres.1*
|
|
||||||
%_bindir/postmaster
|
|
||||||
%doc %_mandir/man1/postmaster.1*
|
|
||||||
%dir %_datadir/postgresql
|
|
||||||
%_datadir/postgresql/timezone*
|
|
||||||
%_datadir/postgresql/*.*
|
|
||||||
%exclude %_datadir/postgresql/*.pltcl
|
|
||||||
%_libdir/postgresql/*_and_*.so
|
|
||||||
%_libdir/postgresql/euc2004_sjis2004.so
|
|
||||||
%_libdir/postgresql/libpqwalreceiver.so
|
|
||||||
%extensiondir/plpgsql*
|
|
||||||
%attr(750,postgres,postgres) %dir /var/lib/pgsql
|
|
||||||
%attr(700,postgres,postgres) %dir /var/lib/pgsql/data
|
|
||||||
%attr(640,postgres,postgres) %config(noreplace) /var/lib/pgsql/.bash_profile
|
|
||||||
|
|
||||||
%files pltcl -f pltcl.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%extensiondir/pltcl*
|
|
||||||
%_libdir/postgresql/pltcl.so
|
|
||||||
%_datadir/postgresql/*.pltcl
|
|
||||||
%_bindir/pltcl*
|
|
||||||
|
|
||||||
%files plperl -f plperl.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%extensiondir/plperl*
|
|
||||||
%_libdir/postgresql/plperl.so
|
|
||||||
|
|
||||||
%files plpython -f plpython.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%extensiondir/plpython*
|
|
||||||
%_libdir/postgresql/plpython*.so
|
|
||||||
|
|
||||||
%if %buildall
|
|
||||||
FI_POSTGRES
|
|
||||||
%if %libs_package
|
|
||||||
%files -n postgresql-libs -f postgresql-libs.lang
|
|
||||||
%else
|
|
||||||
%files -n %libpq -f %libpq.lang
|
|
||||||
%endif
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%_libdir/libpq.so.*
|
|
||||||
%if !%libs_package
|
|
||||||
%files -n %libecpg -f %libecpg.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%endif
|
|
||||||
%_libdir/libecpg*.so.*
|
|
||||||
%_libdir/libpgtypes.so.*
|
|
||||||
|
|
||||||
%files -n %_name-devel -f %_name-devel.lang
|
|
||||||
%defattr(-,root,root)
|
|
||||||
%doc %_mandir/man1/ecpg.1*
|
|
||||||
%_bindir/pg_config
|
|
||||||
%doc %_mandir/man1/pg_config.1*
|
|
||||||
%_bindir/ecpg
|
|
||||||
%_libdir/libpgport.a
|
|
||||||
%_libdir/lib*.so
|
|
||||||
%dir %_libdir/postgresql
|
|
||||||
%_libdir/postgresql/pgxs
|
|
||||||
%_includedir/pgsql
|
|
||||||
%dir %_datadir/postgresql
|
|
||||||
%_datadir/postgresql/pg_service.conf.sample
|
|
||||||
|
|
||||||
IF_POSTGRES
|
|
||||||
%endif
|
|
||||||
FI_POSTGRES
|
|
||||||
%changelog
|
|
Loading…
Reference in New Issue
Block a user