OBS User unknown 2008-01-22 11:35:53 +00:00 committed by Git OBS Bridge
commit e88b0ce1a6
16 changed files with 3824 additions and 0 deletions

23
.gitattributes vendored Normal file
View File

@ -0,0 +1,23 @@
## Default LFS
*.7z filter=lfs diff=lfs merge=lfs -text
*.bsp filter=lfs diff=lfs merge=lfs -text
*.bz2 filter=lfs diff=lfs merge=lfs -text
*.gem filter=lfs diff=lfs merge=lfs -text
*.gz filter=lfs diff=lfs merge=lfs -text
*.jar filter=lfs diff=lfs merge=lfs -text
*.lz filter=lfs diff=lfs merge=lfs -text
*.lzma filter=lfs diff=lfs merge=lfs -text
*.obscpio filter=lfs diff=lfs merge=lfs -text
*.oxt filter=lfs diff=lfs merge=lfs -text
*.pdf filter=lfs diff=lfs merge=lfs -text
*.png filter=lfs diff=lfs merge=lfs -text
*.rpm filter=lfs diff=lfs merge=lfs -text
*.tbz filter=lfs diff=lfs merge=lfs -text
*.tbz2 filter=lfs diff=lfs merge=lfs -text
*.tgz filter=lfs diff=lfs merge=lfs -text
*.ttf filter=lfs diff=lfs merge=lfs -text
*.txz filter=lfs diff=lfs merge=lfs -text
*.whl filter=lfs diff=lfs merge=lfs -text
*.xz filter=lfs diff=lfs merge=lfs -text
*.zip filter=lfs diff=lfs merge=lfs -text
*.zst filter=lfs diff=lfs merge=lfs -text

1
.gitignore vendored Normal file
View File

@ -0,0 +1 @@
.osc

3
postgresql-8.2.6.tar.bz2 Normal file
View File

@ -0,0 +1,3 @@
version https://git-lfs.github.com/spec/v1
oid sha256:ee41327e821f933de2894d6e0c319edc4b63e80cb902e673b490b7eaf4ead114
size 12559117

41
postgresql-README.SuSE.de Normal file
View File

@ -0,0 +1,41 @@
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 .
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.

38
postgresql-README.SuSE.en Normal file
View File

@ -0,0 +1,38 @@
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.
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.

6
postgresql-bashprofile Normal file
View File

@ -0,0 +1,6 @@
# 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

35
postgresql-conf.patch Normal file
View File

@ -0,0 +1,35 @@
--- src/backend/utils/misc/postgresql.conf.sample
+++ src/backend/utils/misc/postgresql.conf.sample
@@ -224,12 +224,12 @@
# - Where to Log -
-#log_destination = 'stderr' # Valid values are combinations of
+log_destination = 'stderr' # Valid values are combinations of
# stderr, syslog and eventlog,
# depending on platform.
# This is used when logging to stderr:
-#redirect_stderr = off # Enable capturing of stderr into log
+redirect_stderr = on # Enable capturing of stderr into log
# files
# (change requires restart)
@@ -303,7 +303,7 @@
#log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements
# and their durations.
-#silent_mode = off # DO NOT USE without syslog or
+silent_mode = on # DO NOT USE without syslog or
# redirect_stderr
# (change requires restart)
@@ -316,7 +316,7 @@
#log_connections = off
#log_disconnections = off
#log_duration = off
-#log_line_prefix = '' # Special values:
+log_line_prefix = '%t %d %u ' # Special values:
# %u = user name
# %d = database name
# %r = remote host and port

4
postgresql-firewall Normal file
View File

@ -0,0 +1,4 @@
## Name: PostgreSQL Server
## Description: Opens TCP port 5432 to allow remote connections to the PostgreSQL server.
TCP="5432"

193
postgresql-init Normal file
View File

@ -0,0 +1,193 @@
#!/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:
# 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=/var/lib/pgsql/data/postmaster.pid
if [ -r $DATADIR/PG_VERSION ] ; then
BIN_VERSION=$($H --version|sed 's/.* \([0-9]\+\.[0-9]\+\).*/\1/')
DATA_VERSION=$(cat $DATADIR/PG_VERSION)
if [ "$BIN_VERSION" != "$DATA_VERSION" ]; then
for libdir in /usr/lib64 /usr/lib; do
H=$libdir/postgresql/backup/$DATA_VERSION/postmaster
test -x $H && break
done
if test -x $H; then
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$libdir/postgresql/backup"
echo " Your databases are still using the format of PostgreSQL $DATA_VERSION."
echo " Therefore a backup of the old PostgreSQL server program will be used"
echo " until you have saved and removed your old database files"
echo " See also /usr/share/doc/packages/postgresql/README.SuSE.{de,en} ."
else
echo " Your databases are still using the format of PostgreSQL $DATA_VERSION,"
echo " but no backup of the old PostgreSQL server program was found."
echo " See /usr/share/doc/packages/postgresql/README.SuSE.{en,de}"
echo " for details on updating PostgeSQL."
exit 5
fi
fi
fi
# 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 sameuser\" $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, if it exists and no daemon is running.
checkproc -p $PIDFILE $H || {
rm -f /tmp/.s.PGSQL.5432 $PIDFILE
}
## Start daemon with startproc(8). If this fails
## the echo return value is set appropriate.
pg_ctl start -s -w -p $H -D $DATADIR -o "\"$OPTIONS\""
rc_status -v
;;
stop)
echo -n "Shutting down PostgreSQL"
## Stop daemon with killproc(8) and if this fails
## set the echo return value.
pg_ctl stop -s -D $DATADIR -m fast
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.
checkproc -p $PIDFILE $H
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

59
postgresql-pl.changes Normal file
View File

@ -0,0 +1,59 @@
-------------------------------------------------------------------
Wed Jun 6 16:00:40 CEST 2007 - max@suse.de
- Split the package into individual subpackages for PL/Perl, PL/Python
and PL/Tcl.
-------------------------------------------------------------------
Mon Feb 13 15:49:49 CET 2006 - max@suse.de
- New version: 8.1.3 (#150376).
- Relaxed dependencies between subpackages to simplify future
updates.
-------------------------------------------------------------------
Wed Jan 25 21:40:32 CET 2006 - mls@suse.de
- converted neededforbuild to BuildRequires
-------------------------------------------------------------------
Thu Dec 22 17:26:20 CET 2005 - max@suse.de
- New version: 8.1.1
-------------------------------------------------------------------
Mon Nov 14 14:35:37 CET 2005 - uli@suse.de
- hardwire thread safety to yes (test may hang QEMU, same as
postgres.spec)
-------------------------------------------------------------------
Wed Jun 15 16:48:39 CEST 2005 - max@suse.de
- Specify the path to tclConfig.sh
-------------------------------------------------------------------
Mon Apr 11 13:42:47 CEST 2005 - max@suse.de
- New version: 8.0.2
-------------------------------------------------------------------
Mon Apr 4 16:12:27 CEST 2005 - uli@suse.de
- hardwire thread safety to yes (test may hang QEMU)
-------------------------------------------------------------------
Mon Sep 13 16:57:07 CEST 2004 - max@suse.de
- Take the proper linking options from Perl, so that libperl.so
can be found when loading plperl into the postgresql server.
-------------------------------------------------------------------
Thu Sep 9 16:41:13 CEST 2004 - max@suse.de
- Fixed the package name inside postgresql-pl.spec.
-------------------------------------------------------------------
Mon Sep 6 16:26:22 CEST 2004 - max@suse.de
- Created a separate spec file for the postgresql-pl subpackage.

229
postgresql-pl.spec Normal file
View File

@ -0,0 +1,229 @@
#
# spec file for package postgresql-pl (Version 8.2.6)
#
# Copyright (c) 2008 SUSE LINUX Products GmbH, Nuernberg, Germany.
# This file and all modifications and additions to the pristine
# package are under the same license as the package itself.
#
# Please submit bugfixes or comments via http://bugs.opensuse.org/
#
# norootforbuild
Name: postgresql-pl
BuildRequires: krb5-devel openssl-devel pam-devel python-devel tcl-devel zlib-devel
Summary: The PL/Tcl, PL/Perl, and PL/Python Procedural Languages for PostgreSQL
Version: 8.2.6
Release: 1
License: BSD 3-Clause
Group: Productivity/Databases/Servers
Source0: postgresql-%version.tar.bz2
NoSource: 0
Url: http://www.postgresql.org/
Requires: postgresql-server = 8.2
BuildRoot: %{_tmppath}/%{name}-%{version}-build
%define pls plperl plpython tcl
%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 PL/Tcl, PL/Perl, and PL/Python procedural
languages for PostgreSQL. With these modules one can use Perl, Python,
and Tcl to write stored procedures, functions, and triggers.
PostgreSQL also offers the built-in procedural language PL/SQL which is
included in the postgresql-server package.
Authors:
--------
Marc G. Fournier <scrappy@hub.org>
Tom Lane <tgl@sss.pgh.pa.us>
Vadim B. Mikheev <vadim4o@yahoo.com>
Bruce Momjian <pgman@candle.pha.pa.us>
Jan Wieck <JanWieck@Yahoo.com>
%package -n postgresql-plperl
Summary: The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL
Group: Productivity/Databases/Servers
Obsoletes: postgresql-pl
Provides: postgresql-pl:%_libdir/postgresql/plperl.so
Requires: perl
Requires: postgresql-server = 8.2
%description -n postgresql-plperl
This package contains the the PL/Tcl, PL/Perl, and PL/Python procedural
languages for the back-end. With these modules one can use Perl,
Python, and Tcl to write stored procedures, functions and triggers.
PostgreSQL also offers the builtin procedural language PL/SQL.
Authors:
--------
Andrew Yu <andrew@CS.Berkeley.edu>
Jolly Chen <jolly@CS.Berkeley.edu>
Bruce Momjian <maillist@candle.pha.pa.us>
Thomas G. Lockhart <lockhart@alumni.caltech.edu>
Tom Lane <tgl@sss.pgh.pa.us>
The Hermit Hacker <scrappy@hub.org>
etc.
%package -n postgresql-plpython
Summary: The PL/Python Procedural Languages for PostgreSQL
Group: Productivity/Databases/Servers
Obsoletes: postgresql-pl
Provides: postgresql-pl:%_libdir/postgresql/pltcl.so
Requires: python
Requires: postgresql-server = 8.2
%description -n postgresql-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.
PostgreSQL also offers the built-in procedural language PL/SQL which is
included in the postgresql-server package.
Authors:
--------
Marc G. Fournier <scrappy@hub.org>
Tom Lane <tgl@sss.pgh.pa.us>
Vadim B. Mikheev <vadim4o@yahoo.com>
Bruce Momjian <pgman@candle.pha.pa.us>
Jan Wieck <JanWieck@Yahoo.com>
%package -n postgresql-pltcl
Summary: PL/Tcl Procedural Language for PostgreSQL
Group: Productivity/Databases/Tools
Obsoletes: postgresql-pl
Provides: postgresql-pl:%_libdir/postgresql/plpython.so
Requires: tcl
Requires: postgresql-server = 8.2
%description -n postgresql-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.
PostgreSQL also offers the built-in procedural language PL/SQL which is
included in the postgresql-server package.
Authors:
--------
Marc G. Fournier <scrappy@hub.org>
Tom Lane <tgl@sss.pgh.pa.us>
Vadim B. Mikheev <vadim4o@yahoo.com>
Bruce Momjian <pgman@candle.pha.pa.us>
Jan Wieck <JanWieck@Yahoo.com>
%prep
# The sources for the postgresql-pl package can be found
# in the postgresql source RPM.
%setup -q -n postgresql-%{version}
%build
#autoconf
export CFLAGS="%optflags"
./configure \
--prefix=%_prefix \
--libdir=%_libdir \
--bindir=%_bindir \
--includedir=%_includedir/pgsql \
--datadir=%_datadir/postgresql \
--mandir=%_mandir \
--with-docdir=%_docdir \
--enable-nls \
--enable-thread-safety \
--enable-thread-safety-force \
--enable-integer-datetimes \
--without-readline \
--with-python \
--with-perl \
--with-tcl \
--without-tk \
--with-tclconfig=%_libdir \
--with-openssl \
--with-pam \
%if %suse_version < 1000
--with-includes="/usr/include/heimdal /usr/include/et" \
%endif
--with-krb5
# needed for plperl
make -C src/backend ../../src/include/utils/fmgroids.h
for f in %pls; do
make %{?jobs:-j%jobs} -C src/pl/$f all
done
%install
for f in %pls; do
make DESTDIR=%buildroot -C src/pl/$f install
done
%clean
rm -rf %buildroot
%files -n postgresql-pltcl
%defattr(-,root,root)
%dir %_libdir/postgresql
%_libdir/postgresql/pltcl.so
%_datadir/postgresql
%_bindir/pltcl*
%files -n postgresql-plperl
%defattr(-,root,root)
%dir %_libdir/postgresql
%_libdir/postgresql/plperl.so
%files -n postgresql-plpython
%defattr(-,root,root)
%dir %_libdir/postgresql
%_libdir/postgresql/plpython.so
%changelog
* Wed Jun 06 2007 - max@suse.de
- Split the package into individual subpackages for PL/Perl, PL/Python
and PL/Tcl.
* Mon Feb 13 2006 - max@suse.de
- New version: 8.1.3 (#150376).
- Relaxed dependencies between subpackages to simplify future
updates.
* Wed Jan 25 2006 - mls@suse.de
- converted neededforbuild to BuildRequires
* Thu Dec 22 2005 - max@suse.de
- New version: 8.1.1
* Mon Nov 14 2005 - uli@suse.de
- hardwire thread safety to yes (test may hang QEMU, same as
postgres.spec)
* Wed Jun 15 2005 - max@suse.de
- Specify the path to tclConfig.sh
* Mon Apr 11 2005 - max@suse.de
- New version: 8.0.2
* Mon Apr 04 2005 - uli@suse.de
- hardwire thread safety to yes (test may hang QEMU)
* Mon Sep 13 2004 - max@suse.de
- Take the proper linking options from Perl, so that libperl.so
can be found when loading plperl into the postgresql server.
* Thu Sep 09 2004 - max@suse.de
- Fixed the package name inside postgresql-pl.spec.
* Mon Sep 06 2004 - max@suse.de
- Created a separate spec file for the postgresql-pl subpackage.

39
postgresql-sysconfig Normal file
View File

@ -0,0 +1,39 @@
## 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=""

1066
postgresql.changes Normal file

File diff suppressed because it is too large Load Diff

1023
postgresql.spec Normal file

File diff suppressed because it is too large Load Diff

1064
postgresql.spec.in Normal file

File diff suppressed because it is too large Load Diff

0
ready Normal file
View File