I'm trying to build postgresql current with odbc and perl support in
preparation to move some systems from MySQL to postgresql. My postgresql
experience is practically NIL at this point so bear with me.
The attached patch to the postgresql.spec file primarily implements odbc
which requires shared libraries to work with OpenOffice.org and StarOffice.
It appears that this option hasn't been tried since the install %post
processing for odbcinst was broken. I also did a crude hack to include
documentation since I'm climbing the learning curve.
It looks like building plperl requires building perl with the perl share
library which will require adding an option to perl to allow this.
Bill
--
INTERNET: [EMAIL PROTECTED] Bill Campbell; Celestial Software LLC
UUCP: camco!bill PO Box 820; 6641 E. Mercer Way
FAX: (206) 232-9186 Mercer Island, WA 98040-0820; (206) 236-1676
URL: http://www.celestial.com/
``If ye love wealth greater than liberty, the tranquillity of servitude
greater than the animating contest for freedom, go home from us in peace.
We seek not your consul, nor your arms. Crouch down and lick the hand that
feeds you. May your chains set lightly upon you; and may posterity forget
ye were our countrymen.'' -- Samuel Adams (American Patriot)
--- /tmp/postgresql.spec 2003-06-21 11:52:56.000000000 -0700
+++ postgresql.spec 2003-06-21 11:53:17.000000000 -0700
@@ -40,7 +40,7 @@
Group: Database
License: GPL
Version: %{V_postgresql}
-Release: 20030607
+Release: 20030614
# package options
%option with_cxx no
@@ -121,7 +121,7 @@
--with-readline \
--with-zlib \
--disable-syslog \
- --disable-shared
+ # --disable-shared
# build package
%{l_make} %{l_mflags -O}
@@ -153,7 +153,7 @@
./configure \
--with-postgres-lib=`pwd`/../src/interfaces/libpq \
--with-postgres-include=`pwd`/../src/interfaces/libpq \
- --disable-shared
+ # --with-shared
%{l_make} %{l_mflags -O}
)
%endif
@@ -204,8 +204,8 @@
%{l_make} %{l_mflags} install install-all-headers DESTDIR=$RPM_BUILD_ROOT
# strip down installation
- rm -rf $RPM_BUILD_ROOT%{l_prefix}/doc
- strip $RPM_BUILD_ROOT%{l_prefix}/bin/* >/dev/null 2>&1 || true
+ # rm -rf $RPM_BUILD_ROOT%{l_prefix}/doc
+ # strip $RPM_BUILD_ROOT%{l_prefix}/bin/* >/dev/null 2>&1 || true
rm -f $RPM_BUILD_ROOT%{l_prefix}/man/man1/pgaccess.1
rm -f $RPM_BUILD_ROOT%{l_prefix}/man/man1/pgtclsh.1
rm -f $RPM_BUILD_ROOT%{l_prefix}/man/man1/pgtksh.1
@@ -298,7 +298,7 @@
%{l_files_std} \
'%attr(700,%{l_rusr},%{l_rgrp}) %dir %{l_prefix}/var/postgresql/db' \
'%attr(755,%{l_rusr},%{l_rgrp}) %dir %{l_prefix}/var/postgresql/run' \
- '%config %{l_prefix}/var/postgresql/db/*.conf'
+ '%config(noreplace) %{l_prefix}/var/postgresql/db/*.conf'
%files -f files
@@ -386,7 +386,7 @@
echo "Description = PostgreSQL ODBC driver"
echo "Driver = $RPM_INSTALL_PREFIX/lib/psqlodbc.so"
echo "Threading = 2"
- ) $RPM_INSTALL_PREFIX/bin/odbcinst -i -d -r
+ ) | $RPM_INSTALL_PREFIX/bin/odbcinst -i -d -r
%endif
elif [ $1 -gt 1 ]; then
# upgrading of installation
