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