7.1.2 RPMs

I built my own binary RPMs with rpm -bb and this spec file. I compiled
and "installed" postgres using the instructions in comments in the %build
section because I haven't bothered to figure out how %build works. This
installation is roughly based on the RedHat 6.0 SPEC file and probably has
a couple of file assignments wrong (server -vs- client -vs- devel).

I have to say that ANT chaps my ass. What ever happened to

javac x.java; jar cf blah.jar `cat find . -name '*.class' -print`

? Make is obsolete, but nothing real has stepped forward to replace it.

Summary: Postgres 7.1 client
Name: postgres
Version: 7.1.2
Release: 1
Group: Applications/Databases
BuildRoot: /tmp/build
Autoreqprov: no
Provides: plenty-of-hate libpq.so.2

%description

This is postgres 7.1.2.

It includes the utilities any database client will need

%package server
Summary: Postgres 7.1 server
Group: Applications/Databases

%description server

This is postgres 7.1.2.

It includes the server binaries and anything else you need to run a
database.

%package jdbc
Summary: Postgres 7.1 JDBC
Group: Applications/Databases

%description jdbc

This is JDBC for postgres 7.1.2.

%package perl
Summary: Postgres 7.1 perl DBD
Group: Applications/Databases

%description perl

This is the perl DBD for postgres 7.1.2.

%package devel
Summary: Postgres 7.1 development libraries
Group: Applications/Databases

%description devel

These are libraries used to develop binaries that use postgres.

%build

# x=/tmp/build
# ./configure --prefix=$x/usr --with-odbc --with-perl --with-java --with-includes=/usr/include/readline
# time make -j 2 install
# mkdir -p $x/var/lib/pgsql
# mkdir -p $x/usr/lib/pgsql; mv $x/usr/share/postgresql/java/postgresql.jar $x/usr/lib/pgsql/jdbc7.0-1.2.jar
# ( cd src/interfaces/perl5/ && make PREFIX=$x/usr/ -f Makefile install )

#

%files devel
/usr/lib/*.a
/usr/lib/*.so
/usr/include/postgresql
/usr/bin/ecpg

/usr/man/man1/ecpg.1

%files server
%defattr(-,root,root)

%dir %attr(-,postgres,postgres) /var/lib/pgsql

/usr/bin/initdb
/usr/bin/initlocation
/usr/bin/ipcclean
/usr/bin/pg_config
/usr/bin/pg_ctl
/usr/bin/pg_passwd
#/usr/bin/pg_upgrade
#/usr/bin/pg_version
/usr/bin/pg_restore
/usr/bin/postgres
/usr/bin/postmaster

/usr/man/man1/initdb.1
/usr/man/man1/initlocation.1
/usr/man/man1/ipcclean.1
/usr/man/man1/pg_config.1
/usr/man/man1/pg_ctl.1
/usr/man/man1/pg_passwd.1
/usr/man/man1/pg_restore.1
#/usr/man/man1/pg_upgrade.1

/usr/man/man1/pgaccess.1
#/usr/man/man1/pgadmin.1
/usr/man/man1/postgres.1
/usr/man/man1/postmaster.1

#%attr(755,root,root) /usr/lib/pgsql/plpgsql.so
/usr/share/postgresql/global.bki
/usr/share/postgresql/global.description
/usr/share/postgresql/template1.bki
/usr/share/postgresql/template1.description
/usr/share/postgresql/pg_hba.conf.sample
/usr/share/postgresql/pg_ident.conf.sample
#/usr/share/postgresql/pg_geqo.sample
#/usr/share/postgresql/pg_options.sample
/usr/share/postgresql/postgresql.conf.sample
/usr/etc/postgresql/odbcinst.ini
/usr/share/postgresql/odbc.sql

#/usr/lib/pgsql/postmaster.opts.default.sample

%pre server
useradd -M -o -r -d /var/lib/pgsql -s /bin/bash -c "Postgres owner" -u 40 postgres

%preun server
if [ $1 = 0 ] ; then
chkconfig --del postgresql
fi

%postun server

/sbin/ldconfig
if [ $1 = 0 ] ; then
userdel postgres >/dev/null 2>&1 || :
fi

%files
%defattr(-,root,root)

/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/pg_id
/usr/bin/psql
/usr/bin/vacuumdb

%attr(755,root,root) /usr/lib/libpq.so.2.1
%attr(755,root,root) /usr/lib/libecpg.so.3.2.0
#%attr(755,root,root) /usr/lib/libpq++.so.3.1
%attr(755,root,root) /usr/lib/libpgeasy.so.2.1
%attr(755,root,root) /usr/lib/libpsqlodbc.so.0.26

/usr/man/man1/createdb.1
/usr/man/man1/createlang.1
/usr/man/man1/createuser.1
/usr/man/man1/dropdb.1
/usr/man/man1/droplang.1
/usr/man/man1/dropuser.1

/usr/man/man1/pg_dump.1
/usr/man/man1/pg_dumpall.1
/usr/man/man1/psql.1
/usr/man/man1/vacuumdb.1

/usr/man/man1/pgtclsh.1
/usr/man/man1/pgtksh.1

/usr/man/manl/abort.l
/usr/man/manl/alter_group.l
/usr/man/manl/alter_table.l
/usr/man/manl/alter_user.l
/usr/man/manl/begin.l
/usr/man/manl/checkpoint.l
/usr/man/manl/close.l
/usr/man/manl/cluster.l
/usr/man/manl/comment.l
/usr/man/manl/commit.l
/usr/man/manl/copy.l
/usr/man/manl/create_aggregate.l
/usr/man/manl/create_constraint_trigger.l
/usr/man/manl/create_database.l
/usr/man/manl/create_function.l
/usr/man/manl/create_group.l
/usr/man/manl/create_index.l
/usr/man/manl/create_language.l
/usr/man/manl/create_operator.l
/usr/man/manl/create_rule.l
/usr/man/manl/create_sequence.l
/usr/man/manl/create_table.l
/usr/man/manl/create_table_as.l
/usr/man/manl/create_trigger.l
/usr/man/manl/create_type.l
/usr/man/manl/create_user.l
/usr/man/manl/create_view.l
/usr/man/manl/declare.l
/usr/man/manl/delete.l
/usr/man/manl/drop_aggregate.l
/usr/man/manl/drop_database.l
/usr/man/manl/drop_function.l
/usr/man/manl/drop_group.l
/usr/man/manl/drop_index.l
/usr/man/manl/drop_language.l
/usr/man/manl/drop_operator.l
/usr/man/manl/drop_rule.l
/usr/man/manl/drop_sequence.l
/usr/man/manl/drop_table.l
/usr/man/manl/drop_trigger.l
/usr/man/manl/drop_type.l
/usr/man/manl/drop_user.l
/usr/man/manl/drop_view.l
/usr/man/manl/end.l
/usr/man/manl/explain.l
/usr/man/manl/fetch.l
/usr/man/manl/grant.l
/usr/man/manl/insert.l
/usr/man/manl/listen.l
/usr/man/manl/load.l
/usr/man/manl/lock.l
/usr/man/manl/move.l
/usr/man/manl/notify.l
/usr/man/manl/reindex.l
/usr/man/manl/reset.l
/usr/man/manl/revoke.l
/usr/man/manl/rollback.l
/usr/man/manl/select.l
/usr/man/manl/select_into.l
/usr/man/manl/set_constraints.l
/usr/man/manl/set.l
/usr/man/manl/set_transaction.l
/usr/man/manl/show.l
/usr/man/manl/truncate.l
/usr/man/manl/unlisten.l
/usr/man/manl/update.l
/usr/man/manl/vacuum.l

%post
/sbin/ldconfig

%postun
/sbin/ldconfig

%files perl
%defattr(-,root,root)

/usr/lib/perl5/site_perl/5.005/i386-linux/auto/Pg
/usr/lib/perl5/site_perl/5.005/i386-linux/Pg.pm
/usr/lib/perl5/man/man3/Pg.3

%files jdbc
%defattr(-,root,root)

/usr/lib/pgsql/jdbc7.0-1.2.jar
/usr/share/postgresql/java/postgresql-examples.jar
/usr/share/postgresql/java/retepTools.jar