On Tue, 20 Mar 2001, Tom Lane wrote:
> Lamar Owen <[EMAIL PROTECTED]> writes:
> > DROP TABLE temptest;
> > + NOTICE: FlushRelationBuffers(temptest, 0): block 0 is referenced (private 0,
>global 1)
> > + ERROR: heap_drop_with_catalog: FlushRelationBuffers returned -2
> > SELECT * FROM temptest;
> Hoo, that's interesting ... Exactly what fileset were you using again?
When you say 'fileset', I'm assuming you are referring to the --schedule
parameter -- I am invoking the following command:
./pg_regress --schedule=parallel_schedule
7.1beta6 distribution tarball. LC_ALL=C. Compiled on RedHat 7 as shipped.
I'm rerunning to see if it is intermittent. Second run -- no error. Running a
third time......no error. Now I'm confused. What would cause such an error,
Tom? I'm going to check on my desktop, once power gets more stable (and it
quits lightning -- yes, a snowstorm with lightning :-0 I certainly got what I
wanted.....). So, more to come later.
> > Seeing that RC1 is in prep, is there a pressing need to upload and
> > release beta 6 RPM's, or will it be a day or two before RC1?
> I think you might as well wait for RC1 as far as actually making RPMs
> goes. But do you want to let anyone else check out the RPM build
> process? For instance, I've been wondering what you did about the
> which-set-of-headers-to-install issue.
Oh, ok. Spec file attached. All other files needed are the beta6 tarball and
the contents of the beta4-1 source rpm, with names changed to match the beta6
version number. There are some other changes I have to merge in --
particularly a set from Karl for the optional PL/Perl build, as well as others,
so this is a preliminary spec file.
But I was just getting the basic build done and tested.
To directly answer your question, I'm using 'make install-all-headers' and
stuffing it into the devel rpm in one piece at this time.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
Summary: PostgreSQL client programs and libraries.
Name: postgresql
Version: 7.1beta6
Release: 0.2
License: BSD
Group: Applications/Databases
Source0: ftp://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.gz
Source3: postgresql.init-%{version}
Source4: file-lists-pgsql-%{version}.tar.gz
Source5: ftp://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.gz.md5
Source6: README.rpm-dist.postgresql-%{version}
Source7: pg-migration-scripts-%{version}.tar.gz
Source8: logrotate.postgresql-%{version}
Source10: http://www.retep.org.uk/postgres/jdbc7.0-1.1.jar
Source11: http://www.retep.org.uk/postgres/jdbc7.0-1.2.jar
Source12: postgresql-dump.1.gz
Source14: rh-pgdump.sh
Patch1: rpm-pgsql-%{version}.patch
Requires: perl
Prereq: /sbin/chkconfig /sbin/ldconfig /usr/sbin/useradd initscripts
BuildPrereq: python-devel perl tcl /lib/cpp
Url: http://www.postgresql.org/
Obsoletes: postgresql-clients
Buildroot: %{_tmppath}/%{name}-%{version}-root
# This is the PostgreSQL Global Development Group Official RPMset spec file.
# Copyright 2000 Lamar Owen <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
# and others listed.
# Major Contributors:
# ---------------
# Lamar Owen
# Trond Eivind Glomsrød <[EMAIL PROTECTED]>
# Thomas Lockhart
# This spec file and ancilliary files are licensed in accordance with
# The PostgreSQL license.
#Below are the default build package list macros. These can be overridden by defining
# on the rpm command line:
# rpm --define 'packagename 1' .... to force the package to build.
# rpm --define 'packagename 0' .... to force the package NOT to build.
# The base package, the lib package, the devel package, and the server package always get built.
%{!?perl:%define perl 1}
%{!?tcl:%define tcl 1}
%{!?tkpkg:%define tkpkg %{expand:tcl}}
%{!?odbc:%define odbc 1}
%{!?jdbc:%define jdbc 1}
%{!?test:%define test 1}
%{!?python:%define python 1}
%{!?pltcl:%define pltcl 1}
%{!?plperl:%define plperl 1}
# Utility feature defines.
%{!?enable_mb:%define enable_mb 1}
%{!?pgacess:%define pgaccess 1}
%dump
%description
PostgreSQL is an advanced Object-Relational database management system
(DBMS) that supports almost all SQL constructs (including
transactions, subselects and user-defined types and functions). The
postgresql package includes the client programs and libraries that
you'll need to access a PostgreSQL DBMS server. These PostgreSQL
client programs are programs that directly manipulate the internal
structure of PostgreSQL databases on a PostgreSQL server. These client
programs can be located on the same machine with the PostgreSQL
server, or may be on a remote machine which accesses a PostgreSQL
server over a network connection. This package contains the client
libraries for C and C++, as well as command-line utilities for
managing PostgreSQL databases on a PostgreSQL server.
If you want to manipulate a PostgreSQL database on a remote PostgreSQL
server, you need this package. You also need to install this package
if you're installing the postgresql-server package.
%package libs
Summary: The shared libraries required for any PostgreSQL clients.
Group: Applications/Databases
Provides: libpq.so.2.1 libpq.so.2.0
%description libs
The postgresql-libs package provides the essential shared libraries for any
PostgreSQL client program or interface. You will need to install this package
to use any other PostgreSQL package or any clients that need to connect to a
PostgreSQL server.
%package server
Summary: The programs needed to create and run a PostgreSQL server.
Group: Applications/Databases
Prereq: /usr/sbin/useradd
Requires: postgresql = %{version}
%description server
The postgresql-server package includes the programs needed to create
and run a PostgreSQL server, which will in turn allow you to create
and maintain PostgreSQL databases. PostgreSQL is an advanced
Object-Relational database management system (DBMS) that supports
almost all SQL constructs (including transactions, subselects and
user-defined types and functions). You should install
postgresql-server if you want to create and maintain your own
PostgreSQL databases and/or your own PostgreSQL server. You also need
to install the postgresql package.
%package devel
Summary: PostgreSQL development header files and libraries.
Group: Development/Libraries
Requires: postgresql = %{version}
%description devel
The postgresql-devel package contains the header files and libraries
needed to compile C or 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 which will interact with a PostgreSQL server. If
you're installing postgresql-server, you need to install this
package.
#------------
%if %tcl
%package tcl
Summary: A Tcl client library, and the PL/Tcl procedural language for PostgreSQL.
Group: Applications/Databases
Requires: tcl >= 8.0, postgresql = %{version}
%description tcl
PostgreSQL is an advanced Object-Relational database management
system. The postgresql-tcl package contains the libpgtcl client library,
the pg-enchanced pgtclsh, and the PL/Tcl procedural language for the backend.
%endif
#------------
%if %tkpkg
%package tk
Summary: Tk shell and tk-based GUI for PostgreSQL.
Group: Applications/Databases
Requires: tcl >= 8.0, tk >= 8.0, postgresql = %{version}
%description tk
PostgreSQL is an advanced Object-Relational database management
system. The postgresql-tk package contains the pgaccess
program. Pgaccess is a graphical front end, written in Tcl/Tk, for the
psql and related PostgreSQL client programs.
%endif
#------------
%if %odbc
%package odbc
Summary: The ODBC driver needed for accessing a PostgreSQL DB using ODBC.
Group: Applications/Databases
Requires: postgresql = %{version}
%description odbc
PostgreSQL is an advanced Object-Relational database management
system. The postgresql-odbc package includes the ODBC (Open DataBase
Connectivity) driver and sample configuration files needed for
applications to access a PostgreSQL database using ODBC.
%endif
#------------
%if %perl
%package perl
Summary: Development module needed for Perl code to access a PostgreSQL DB.
Group: Applications/Databases
Requires: perl >= 5.004-4, postgresql = %{version}
%description perl
PostgreSQL is an advanced Object-Relational database management
system. The postgresql-perl package includes a module for developers
to use when writing Perl code for accessing a PostgreSQL database.
%endif
#------------
%if %python
%package python
Summary: Development module for Python code to access a PostgreSQL DB.
Group: Applications/Databases
Requires: python >= 1.5, postgresql = %{version}
%description python
PostgreSQL is an advanced Object-Relational database management
system. The postgresql-python package includes a module for
developers to use when writing Python code for accessing a PostgreSQL
database.
%endif
#----------
%if %jdbc
%package jdbc
Summary: Files needed for Java programs to access a PostgreSQL database.
Group: Applications/Databases
Requires: postgresql = %{version}
%description jdbc
PostgreSQL is an advanced Object-Relational database management
system. The postgresql-jdbc package includes the .jar file needed for
Java programs to access a PostgreSQL database.
%endif
#------------
%if %test
%package test
Summary: The test suite distributed with PostgreSQL.
Group: Applications/Databases
Requires: postgresql = %{version}
%description test
PostgreSQL is an advanced Object-Relational database management
system. The postgresql-test package includes the sources and pre-built
binaries of various tests for the PostgreSQL database management
system, including regression tests and benchmarks.
%endif
%prep
%setup -q
%patch1 -p1
#
%build
# Get file lists....
tar xzf %{SOURCE4}
#Commented out for testing on other platforms for now.
# If libtool installed, copy some files....
#if [ -d /usr/share/libtool ]
#then
# cp /usr/share/libtool/config.* .
#fi
CFLAGS="$RPM_OPT_FLAGS"
./configure --enable-hba --enable-locale --with-CXX --prefix=/usr\
%if %perl
--with-perl \
%endif
%if %enable_mb
--enable-multibyte \
%endif
%if %tcl
--with-tcl \
%endif
%if %tkpkg
%else
--without-tk \
%endif
%if %odbc
--with-odbc \
%endif
--enable-syslog\
%if %python
--with-python \
%endif
--sysconfdir=/etc/pgsql \
--mandir=%{_mandir} \
--docdir=%{_docdir} \
--includedir=%{_includedir}/pgsql \
--datadir=/usr/share/pgsql
make COPT="$CFLAGS" all
%if %python
pushd src
pushd interfaces/python
cp /usr/lib/python1.5/config/Makefile.pre.in .
echo *shared* > Setup
echo _pg pgmodule.c -I../../include -I../libpq -L../libpq -lpq -lcrypt >> Setup
make -f Makefile.pre.in boot
make
popd
popd
%endif
%if %test
pushd src/test
make all
popd
%endif
%install
rm -rf $RPM_BUILD_ROOT
make DESTDIR=$RPM_BUILD_ROOT install
%if %perl
make PREFIX=$RPM_BUILD_ROOT/usr -C src/interfaces/perl5 -f Makefile install
# Get rid of the packing list generated by the perl Makefile, and build my own...
find $RPM_BUILD_ROOT/usr/lib/perl5 -name .packlist -exec rm -f {} \;
find $RPM_BUILD_ROOT/usr/lib/perl5 -type f -print | \
sed -e "s|$RPM_BUILD_ROOT/|/|g" | \
sed -e "s|.*/man/.*|&\*|" > perlfiles.list
find $RPM_BUILD_ROOT/usr/lib/perl5 -type d -name Pg -print | \
sed -e "s|$RPM_BUILD_ROOT/|%dir /|g" >> perlfiles.list
# check and fixup Pg manpage location....
if [ ! -e $RPM_BUILD_ROOT%{_mandir}/man3/Pg.* ]
then
mkdir -p $RPM_BUILD_ROOT%{_mandir}/man3
cp `find $RPM_BUILD_ROOT -name 'Pg.3*' -print` $RPM_BUILD_ROOT%{_mandir}/man3
fi
pushd src/interfaces
mkdir -p $RPM_BUILD_ROOT/usr/share/pgsql/perl5
cp -a perl5/test.pl $RPM_BUILD_ROOT/usr/share/pgsql/perl5
popd
# remove perllocal.pod from the file list - only occurs with 5.6
perl -pi -e "s/^.*perllocal.pod$//" perlfiles.list
mkdir -p $RPM_BUILD_ROOT/usr/lib/perl5/site_perl/%{_arch}-linux/auto/Pg
%endif
make -C doc
# man pages....
pushd $RPM_BUILD_ROOT%{_mandir}
tar xzf $RPM_BUILD_DIR/postgresql-%{version}/doc/man.tar.gz
# the postgresql-dump manpage.....
cp %{SOURCE12} man1
popd
# install the dump script
install -m755 %SOURCE14 $RPM_BUILD_ROOT/usr/bin/
# copy over the includes needed for SPI development.
#pushd src/include
#/lib/cpp -M -I. -I../backend executor/spi.h | \
# xargs -n 1| \
# grep \\W| \
# grep -v ^/| \
# grep -v spi.o | \
# grep -v spi.h | \
# sort | \
# cpio -pdu $RPM_BUILD_ROOT/usr/include/pgsql
# thank you, cpio....
# New method using the make system....
make DESTDIR=$RPM_BUILD_ROOT install-all-headers
#fixup directory permissions for SPI stuff...
#pushd $RPM_BUILD_ROOT/usr/include/pgsql
#chmod 755 access catalog executor nodes rewrite storage tcop utils
#popd
#popd
# copy over Makefile.global to the include dir....
install -m755 src/Makefile.global $RPM_BUILD_ROOT/usr/include/pgsql
%if %pgaccess
# pgaccess installation
pushd src/bin
install -m 755 pgaccess/pgaccess $RPM_BUILD_ROOT/usr/bin
mkdir -p $RPM_BUILD_ROOT/usr/share/pgsql/pgaccess
install -m 644 pgaccess/main.tcl $RPM_BUILD_ROOT/usr/share/pgsql/pgaccess
tar cf - pgaccess/lib pgaccess/images | tar xf - -C $RPM_BUILD_ROOT/usr/share/pgsql
cp -a pgaccess/doc/html ../../doc/pgaccess
cp pgaccess/demo/*.sql ../../doc/pgaccess
popd
%endif
%if %python
# Python
pushd src/interfaces/python
# Makefile.pre.in doesn't yet support .py files anyway, so we stick to a manual installation
mkdir -p $RPM_BUILD_ROOT/usr/lib/python1.5/site-packages
install -m 755 _pgmodule.so *.py $RPM_BUILD_ROOT/usr/lib/python1.5/site-packages/
popd
%endif
%if %jdbc
# Java/JDBC
# The user will have to set a CLASSPATH to find it here, but not sure where else to put it...
# Install 7.0 JDBC jars
install -m 755 %{SOURCE10} $RPM_BUILD_ROOT/usr/share/pgsql
install -m 755 %{SOURCE11} $RPM_BUILD_ROOT/usr/share/pgsql
%endif
# Fixup more permissions...
chmod 644 $RPM_BUILD_ROOT%{_mandir}/*/*
chmod +x $RPM_BUILD_ROOT/usr/lib/lib*.so.*
# The initscripts....
# Redhat-style....
if [ -d /etc/rc.d/init.d ]
then
install -d $RPM_BUILD_ROOT/etc/rc.d/init.d
install -m 755 %{SOURCE3} $RPM_BUILD_ROOT/etc/rc.d/init.d/postgresql
mv redhat-style-files.lst files.lst
fi
# SuSE-style....
# NOTE: SuSE stuff not yet fully implemented -- this is likely to not work yet.
# Putting SuSE-style stuff here
if [ -d /sbin/init.d ]
then
# install the SuSE stuff...
mv suse-style-files.lst files.lst
fi
# PGDATA needs removal of group and world permissions due to pg_pwd hole.
install -d -m 700 $RPM_BUILD_ROOT/var/lib/pgsql/data
# backups of data go here...
install -d -m 700 $RPM_BUILD_ROOT/var/lib/pgsql/backups
%if %test
# tests. There are many files included here that are unnecessary, but include
# them anyway for completeness.
mkdir -p $RPM_BUILD_ROOT/usr/share/pgsql/test
cp -a src/test/regress $RPM_BUILD_ROOT/usr/share/pgsql/test
install -m 0755 config/config.guess $RPM_BUILD_ROOT/usr/share/pgsql
install -m 0755 contrib/spi/refint.so $RPM_BUILD_ROOT/usr/share/pgsql/test/regress
install -m 0755 contrib/spi/autoinc.so $RPM_BUILD_ROOT/usr/share/pgsql/test/regress
chown -R postgres.postgres $RPM_BUILD_ROOT/usr/share/pgsql/test/regress
%endif
# Upgrade scripts.
pushd $RPM_BUILD_ROOT
tar xzf %{SOURCE7}
popd
#logrotate script source (which needs WORK)
mkdir -p $RPM_BUILD_ROOT/etc/logrotate.d
cp %{SOURCE8} $RPM_BUILD_ROOT/etc/logrotate.d/postgres
chmod 0644 $RPM_BUILD_ROOT/etc/logrotate.d/postgres
# Fix some more documentation
# no need for the OS2 client
rm -rf contrib/os2client
gzip doc/internals.ps
cp %{SOURCE6} README.rpm-dist
# remove the binaries from contrib
rm -f `find contrib -name "*.so"`
rm -f contrib/spi/preprocessor/step1.e
# Fix a dangling symlink
mkdir -p $RPM_BUILD_ROOT/usr/include/pgsql/port
cp src/include/port/linux.h $RPM_BUILD_ROOT/usr/include/pgsql/port/
ln -sf port/linux.h $RPM_BUILD_ROOT/usr/include/pgsql/os.h
# Symlink libpq.so.2.0 to libpq.so.2.1 for backwards compatibility, until
# -soname patches are the norm.
pushd $RPM_BUILD_ROOT/usr/lib
ln -s libpq.so.2.1 libpq.so.2.0
popd
%pre
# Need to make backups of some executables if an upgrade
# They will be needed to do a dump of the old version's database.
# All output redirected to /dev/null.
if [ $1 -gt 1 ]
then
mkdir -p /usr/lib/pgsql/backup > /dev/null
pushd /usr/bin > /dev/null
cp -fp postmaster postgres pg_dump pg_dumpall psql /usr/share/pgsql/backup > /dev/null 2>&1 || :
popd > /dev/null
pushd /usr/lib > /dev/null
cp -fp libpq.* /usr/share/pgsql/backup > /dev/null 2>&1 || :
popd > /dev/null
fi
%post -p /sbin/ldconfig
%postun -p /sbin/ldconfig
%pre server
groupadd -g 26 postgres >/dev/null 2>&1 || :
useradd -M -n -g postgres -o -r -d /var/lib/pgsql -s /bin/bash \
-c "PostgreSQL Server" -u 26 postgres >/dev/null 2>&1 || :
touch /var/log/pgsql
chown postgres.postgres /var/log/pgsql
chmod 0700 /var/log/pgsql
%post server
/sbin/ldconfig
echo PGLIB=/usr/share/pgsql >> ~postgres/.bash_profile
echo PGDATA=/var/lib/pgsql/data >> ~postgres/.bash_profile
echo export PGLIB PGDATA >> ~postgres/.bash_profile
%preun server
if [ $1 = 0 ] ; then
chkconfig --del postgresql
fi
%postun server
/sbin/ldconfig
if [ $1 -ge 1 ]; then
/sbin/service postgresql condrestart >/dev/null 2>&1
fi
if [ $1 = 0 ] ; then
userdel postgres >/dev/null 2>&1 || :
groupdel postgres >/dev/null 2>&1 || :
fi
%if %odbc
%post -p /sbin/ldconfig odbc
%postun -p /sbin/ldconfig odbc
%endif
%if %tcl
%post -p /sbin/ldconfig tcl
%postun -p /sbin/ldconfig tcl
%endif
%if %test
%post test
chown -R postgres.postgres /usr/share/pgsql/test >/dev/null 2>&1 || :
%endif
%clean
#rm -rf $RPM_BUILD_ROOT
#rm -f perlfiles.list
# Ok, we are dynamically generating some filelists. These are by default
# under the BUILD/postgresql-x.y.z tree.
# Note that macros such as config are available in those lists.
# The lists differentiate between RedHat, SuSE, and others.
%files
%defattr(-,root,root)
%doc doc/FAQ doc/KNOWN_BUGS doc/MISSING_FEATURES doc/README*
%doc COPYRIGHT README HISTORY doc/bug.template
%doc contrib doc/src/*
%doc README.rpm-dist
%doc %{_docdir}/postgresql/html
/usr/bin/createdb
/usr/bin/createlang
/usr/bin/createuser
/usr/bin/dropdb
/usr/bin/droplang
/usr/bin/dropuser
/usr/bin/pg_dump
/usr/bin/pg_dumpall
/usr/bin/psql
/usr/bin/vacuumdb
%{_mandir}/man1/createdb.1*
%{_mandir}/man1/createlang.1*
%{_mandir}/man1/createuser.1*
%{_mandir}/man1/dropdb.1*
%{_mandir}/man1/droplang.1*
%{_mandir}/man1/dropuser.1*
%{_mandir}/man1/pg_dump.1*
%{_mandir}/man1/pg_dumpall.1*
%{_mandir}/man1/psql.1*
%{_mandir}/manl/*
%files libs
/usr/lib/libpq.so*
/usr/lib/libecpg.so*
/usr/lib/libpq++.so*
/usr/lib/libpgeasy.so*
%files server -f files.lst
%defattr(-,root,root)
/etc/logrotate.d/postgres
/usr/bin/initdb
/usr/bin/initlocation
/usr/bin/ipcclean
/usr/bin/pg_ctl
/usr/bin/pg_encoding
/usr/bin/pg_id
/usr/bin/pg_passwd
/usr/bin/postgres
/usr/bin/postgresql-dump
/usr/bin/postmaster
/usr/bin/rh-pgdump.sh
%{_mandir}/man1/initdb.1*
%{_mandir}/man1/initlocation.1*
%{_mandir}/man1/ipcclean.1*
%{_mandir}/man1/pg_ctl.1*
%{_mandir}/man1/pgadmin.1*
%{_mandir}/man1/pg_passwd.1*
%{_mandir}/man1/postgres.1*
%{_mandir}/man1/postmaster.1*
%{_mandir}/man1/vacuumdb.1*
%{_mandir}/man1/postgresql-dump.1*
/usr/share/pgsql/global.bki
/usr/share/pgsql/global.description
/usr/share/pgsql/template1.bki
/usr/share/pgsql/template1.description
/usr/share/pgsql/*.sample
/usr/lib/plpgsql.so
%attr(700,postgres,postgres) %dir /usr/share/pgsql/backup
/usr/share/pgsql/backup/pg_dumpall_new
%attr(700,postgres,postgres) %dir /var/lib/pgsql/data
%attr(700,postgres,postgres) %dir /var/lib/pgsql/backups
%files devel
%defattr(-,root,root)
/usr/include/pgsql
/usr/bin/ecpg
/usr/lib/lib*.a
/usr/bin/pg_config
%{_mandir}/man1/ecpg.1*
%if %tcl
%files tcl
%defattr(-,root,root)
%attr(755,root,root) /usr/lib/libpgtcl.so*
/usr/bin/pgtclsh
%{_mandir}/man1/pgtclsh.1*
/usr/lib/pltcl.so
%endif
%if %tkpkg
%files tk
%defattr(-,root,root)
%if %pgaccess
%doc doc/pgaccess/*
/usr/share/pgsql/pgaccess
/usr/bin/pgaccess
%{_mandir}/man1/pgaccess.1*
%endif
/usr/bin/pgtksh
%{_mandir}/man1/pgtksh.1*
%endif
%if %odbc
%files odbc
%defattr(-,root,root)
%attr(755,root,root) /usr/lib/libpsqlodbc.so*
/etc/pgsql/odbcinst.ini
/usr/share/pgsql/odbc.sql
%endif
%if %perl
%files -f perlfiles.list perl
%defattr (-,root,root)
%dir /usr/lib/perl5/site_perl/%{_arch}-linux/auto
/usr/share/pgsql/perl5
%{_mandir}/man3/Pg.*
%endif
%if %python
%files python
%defattr(-,root,root)
%doc src/interfaces/python/README src/interfaces/python/tutorial
/usr/lib/python1.5/site-packages/_pgmodule.so
/usr/lib/python1.5/site-packages/*.py
%endif
%if %jdbc
%files jdbc
%defattr(-,root,root)
/usr/share/pgsql/jdbc7.0-1.1.jar
/usr/share/pgsql/jdbc7.0-1.2.jar
%endif
%if %test
%files test
%defattr(-,postgres,postgres)
%attr(755,postgres,postgres)/usr/share/pgsql/config.guess
%attr(-,postgres,postgres)/usr/share/pgsql/test/regress/*
%endif
# Conventions for PostgreSQL RPM releases:
# Pre-releases are those that are built from CVS snapshots or pre-release
# tarballs from postgresql.org. Pre-releases should have a fractional release
# number to show their pre-release status. Official beta releases are not
# considered pre-releases, nor are release candidates, as their beta or
# release candidate status is reflected in the version of the tarball. Pre-
# releases' versions do not change -- the pre-release tarball of 7.0.3, for
# example, has the same tarball version as the final official release of 7.0.3:
# but the tarball is different.
# Pre-release RPM's should not be put up on the public ftp.postgresql.org server
# -- only full integer releases should be.
# Start changelog proper below this comment
%changelog
* Tue Mar 20 2001 Lamar Owen <[EMAIL PROTECTED]>
- Beta 6 initial build.
- Use make install-all-headers instead of cpio hack for devel headers.
- Split out the libs into the libs subpackage.
- Updated initscript to use pg_ctl to stop
- Updated initscript to initdb and start postmaster with LC_ALL=C to
-- prevent index corruption.
* Sun Jan 28 2001 Lamar Owen <[EMAIL PROTECTED]>
- Beta4
- Return to 'pgsql' directories instead of 'postgresql'
- Better perl patches.
* Mon Jan 15 2001 Lamar Owen <[EMAIL PROTECTED]>
- Edit patches to get rid of some cruft.
- Eliminate some more pre-7.1 specfile baggage that is no longer necessary.
- Moved pg_id to server
- added Makefile.global and pg_config to devel
- Corrected /usr/include/pgsql to /usr/include/postgresql
- Fixed some configure options. Will be trying the configure macro next release
- Since it is terminally ill in this version pg_upgrade is _gone_.
- Thanks to Peter E for a good review.
* Sun Jan 14 2001 Lamar Owen <[EMAIL PROTECTED]>
- Running regression. 1 on the release-o-meter.
- Minor patches to get regression running right.
- Initscript tweaking -- the old test for a database structure fails with 7.1's new structure.
* Sat Jan 13 2001 Lamar Owen <[EMAIL PROTECTED]>
- Perl 5 needs to be built with PREFIX set on the Makefile, not GNUmakefile....
- The 7.1 build is different from the 7.0 build -- see the configure line.
- NOTE: many files that used to be in /usr/share/postgresql are now in /usr/share/postgresql!
- by request, conditional packages are now supported. See the top of the spec.
- Fixed the server postinstall problems.
* Mon Jan 08 2001 Lamar Owen <[EMAIL PROTECTED]>
- First 7.1 beta test-build
* Wed Nov 15 2000 Lamar Owen <[EMAIL PROTECTED]>
- Buggy dependency on /lib/cpp -- not a PreReq, but a BuildPreReq.
* Tue Nov 14 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- made a template for IA64 (symlink to i386)
* Mon Nov 13 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- add patch for IA64 (I got one from Lamar and modified it)
* Mon Nov 13 2000 Lamar Owen <[EMAIL PROTECTED]>
- RELEASE: 7.0.3-1
- Minor edits to initscript.
- PRE-RELEASE: 7.0.3-0.6 (final test)
- Final 7.0.3 tarball.
- Cross-dist changes to RedHat initscript for better portability.
- changed README.rpm name to README.rpm-dist (the .rpm extension confused
--some GUI file managers, as RealPlayer also uses that extension).
- Edited README.rpm-dist to reflect cross-distribution packaging.
- NOTE: SuSE cross-compatibility is not yet complete SuSE RPM's for 7.0.3
--that are tailored for SuSE will be made available.
- Fixed stupid dependency -- the main .so's were in the devel package (Arggh)
* Sat Nov 11 2000 Lamar Owen <[EMAIL PROTECTED]>
- PRE-RELEASE: 7.0.3-0.5
- Framework for better distribution-independent build
- Conditional around libtool conf stuff copy (For RedHat 6.1 and such).
- Conditional around RedHat-style initscript stuff.
- Comments at top of spec file now list copyright and license for spec file,
--as the license and copyright for the spec file itself has not previously
--been stated.
- Envvars for postgres home dir login in .bash_profile.
- initscript now checks for success and failure functions using:
--typeset -f|grep "declare -f function_name" construct.
* Fri Nov 10 2000 Lamar Owen <[EMAIL PROTECTED]>
- PRE-RELEASE: 7.0.3-0.4
- Directory ownership on /usr/share/postgresql/test/regress was root.root.
- Patch Makefile.shlib to not use -soname for RPM's.
- Newer prerelease 7.0.3 tarball.
* Thu Nov 09 2000 Lamar Owen <[EMAIL PROTECTED]>
- PRE-RELEASE: 7.0.3-0.3
- Don't bother copying the test stuff I'm not packaging.
- Fix group add/del stuff in server subpackage post and postun scriptlets.
- symlink /usr/lib/libpq.so.2.0 -> libpq.so.2.1
* Mon Nov 06 2000 Lamar Owen <[EMAIL PROTECTED]>
- PRE-RELEASE: 7.0.3-0.2
- preliminary 7.0.3 distribution tarball -- reinstated man pages, etc.
* Sat Nov 04 2000 Lamar Owen <[EMAIL PROTECTED]>
- PRE-RELEASE: 7.0.3-0.1.
- Improved test subpackage -- only package regression.
- Latest pre-7.0.3 snapshot.
- Split out SuSE and Caldera spec files. Caldera COL eServer 2.3 requires
-- RPM 2.5.5-compatible spec files. SuSE is just too different from the others
-- for the spec file to cope, for now.
- TODO: man pages and documentation.
* Mon Oct 30 2000 Lamar Owen <[EMAIL PROTECTED]>
- pre-7.0.3
* Mon Oct 30 2000 Lamar Owen <[EMAIL PROTECTED]>
- Reenabled the test subpackage for ftp.postgresql.org dist.
- Backported to RH 6.2 -- involved the Pg man page, doesn't appear to require
-- other stuff to be done.
* Sun Oct 22 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- make /etc/logrotate.d/postgres 0644 instead of 0700 (#19520)
* Thu Oct 19 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- rebuild with new glibc which has semaphore fixes for Alpha
* Tue Sep 05 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- add documention for python interface (#17261)
- move the python interface tutorial to the %%doc section
* Thu Aug 24 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- the old dump script didn't work - added rh-pgdump.sh
to handle this. Point docs at it, and tell how it is to be used.
* Mon Aug 21 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- fix the initscript so it points you at the 7.0.2 directory
in /usr/share/doc, not 7.0 (#16163). Also, remove statement
it was built on a 6.2 system.
- prereq /lib/cpp and initscripts
- fix backups of existing files (#16706)
- fix conditional restart
* Sat Aug 19 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- fix README.rpm to it points at /usr/share/doc, not /usr/doc
(part of #16416)
* Wed Aug 16 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- don't build test package anymore, it's broken. These
tests should be run by pgsql developers and not
by db-developers, so it's not a big loss (#16165).
Obsolete it in the main package, so it doesn't get left over
* Mon Aug 14 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- reference docs in /usr/share/doc, not /usr/doc (#16163)
- add python-devel, perl and tcl as build prereqs
- use /dev/null as STDIN for su commands in initscripts,
to avoid error messages from not being able to read from
tty
* Sat Aug 05 2000 Bill Nottingham <[EMAIL PROTECTED]>
- condrestart fixes
* Mon Jul 31 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- remove all plperl references, to avoid confusing post install scripts
- cleanups
* Mon Jul 17 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- remove the symlink from libpq.so.2.0 to libpq.so.2.1
- remove some binaries from docs
- fix dangling symlink os.h
- use /sbin/service
* Thu Jul 13 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- don't strip manually
- fixes to init script so they look more like the rest
(#13749, from [EMAIL PROTECTED])
- use /etc/rc.d/init.d again (sigh)
* Wed Jul 12 2000 Prospector <[EMAIL PROTECTED]>
- automatic rebuild
* Thu Jul 06 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- "Prereq:", not "Requires:" for /etc/init.d
* Thu Jul 06 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- require /etc/init.d
* Wed Jun 21 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- remove perl kludge as perl 5.6 is now fixed
- include the man page for the perl module
- fix the init script and spec file to handle conditional
restart
- move the init file to /etc/init.d
- use License instead of Copyright
* Mon Jun 19 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- rebuild
* Tue Jun 13 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- use %%defattr on postgresql-perl
- use %%{_tmppath}
- Don't use release number in patch
- Don't build on ia64 yet
* Mon Jun 12 2000 Lamar Owen <[EMAIL PROTECTED]>
- 7.0.2-2
- Corrected misreporting of version.
- Corrected for non-root build clean script.
* Mon Jun 05 2000 Lamar Owen <[EMAIL PROTECTED]>
- 7.0.2
- Postgresql-dump manpage to man1, and to separate source file to facilitate
-- _mandir macro expansion correctness.
- NOTE: The PostScript documentation is no longer being included in the
-- PostgreSQL tarball. If demand is such, I will pull together a
-- postgresql-ps-docs subpackage or pull in the PostScript docs into the
-- main package.
- RPM patchset has release number, now, to prevent patchfile confusion :-(.
* Sat Jun 03 2000 Lamar Owen <[EMAIL PROTECTED]>
- Incorporate most of Trond's changes (reenabled the alpha
-- patches, as it was a packaging error on my part).
- Trimmed changelog history to Version 7.0beta1 on. To see the
-- previous changelog, grab the 6.5.3 RPM from RedHat 6.2 and pull the spec.
- Rev to 7.0.1 (which incorporates the syslog patch, which has
-- been removed from rpm-pgsql-7.0.1-1.patch)
* Fri May 26 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- disable the alpha patch, as it doesn't apply cleanly
- removed distribution, packager, vendor
- renamed spec file
- don't build pl-perl
- use %%{_mandir}
- now includes vacuumdb.1*
* Thu May 25 2000 Lamar Owen <[EMAIL PROTECTED]>
- 7.0-3
- Incorporated Tatsuo's syslog segmentation patches
- Incorporated some of Trond's changes (see below)
-- Fixed some Perl 5.6 oddness in Rawhide
- Incorporated some of Karl's changes (see below)
-- PL/Perl should now work.
- Fixed missing /usr/bin/pg_passwd.
* Mon May 22 2000 Karl DeBisschop <[EMAIL PROTECTED]>
- 7.0-2.1
- make plperl module (works for linux i386, your guess for other platforms)
- use "make COPT=" because postgreSQL configusre script ignores CFLAGS
* Sat May 20 2000 Lamar Owen <[EMAIL PROTECTED]>
- 7.0-2
- pg_options default values changed.
- SPI headers (again!) fixed in a permanent manner -- hopefully!
- Alpha patches!
* Wed May 17 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- changed bug in including man pages
* Tue May 16 2000 Trond Eivind Glomsrød <[EMAIL PROTECTED]>
- changed buildroot, removed packager, vendor, distribution
-- [Left all but buildroot as-is for PostgreSQL.org RPMS. LRO]
- don't strip in package [strip in PostgreSQL.org RPMS]
- fix perl weirdnesses (man page in bad location, remove
perllocal.pod from file list)
* Mon May 15 2000 Lamar Owen <[EMAIL PROTECTED]>
- 7.0 final -1
- Man pages restructured
- Changed README.rpm notices about BETA
- incorporated minor changes from testing
- still no 7.0 final alpha patches -- for -2 or -3, I guess.
- 7.0 JDBC jars!
* Sat May 06 2000 Lamar Owen <[EMAIL PROTECTED]>
- 7.0RC5-0.5
- UserID of 26 to conform to RedHat Standard, instead of 40. This only
-- is for new installs -- upgrades will use what was already there.
- Waiting on built jar's of JDBC. If none are forthcoming by release,
-- I'm going to have to bite the bullet and install the jdk....
* Mon May 01 2000 Lamar Owen <[EMAIL PROTECTED]>
- 7.0RC2-0.5
- Fixed /usr/src/redhat/BUILD path to $RPM_BUILD_DIR for portability
-- and so that RPM's can be built by non-root.
- Minor update to README.rpm
* Tue Apr 18 2000 Lamar Owen <[EMAIL PROTECTED]>
- 0.6
- Fixed patchset: wasn't patching pgaccess or -i in postmaster.opts.default
- minor update to README.rpm
* Mon Apr 17 2000 Lamar Owen <[EMAIL PROTECTED]>
- 7.0RC1-0.5 (release candidate 1.)
- Fixed SPI header directories' permisssions.
- Removed packaging of Alpha patches until Ryan releases RC1-tested set.
* Mon Apr 10 2000 Lamar Owen <[EMAIL PROTECTED]>
- 7.0beta5-0.1 (released instead of the release candidate)
* Sat Apr 08 2000 Lamar Owen <[EMAIL PROTECTED]>
- 7.0beta4-0.2 (pre-release-candidate CVS checkout)
- Alpha patches!
- pg_options.sample
* Fri Mar 24 2000 Lamar Owen <[EMAIL PROTECTED]>
- 7.0beta3-0.1
* Mon Feb 28 2000 Lamar Owen <[EMAIL PROTECTED]>
- Release 0.3
- Fixed stderr redir problem in init script
- Init script now uses pg_ctl to start postmaster
- Packaged inital pg_options for good logging
- built with timestamped logging.
* Tue Feb 22 2000 Lamar Owen <[EMAIL PROTECTED]>
- Initial 7.0beta1 build
- Moved PGDATA to /var/lib/pgsql/data
- First stab at logging and logrotate functionality -- test carefully!
- -tcl subpackage split -- tcl client and pltcl lang separated from
-- the Tk stuff. PgAccess and the tk client are now in the -tk subpackage.
- No patches for Alpha as yet.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
