Re: Installation trouble - Solved

Dear Steve,

I have had the same problem related SuSE 8.2. A thing that additionally can be wrong is the LC_CTYPE setting in the environment. Running a SuSE system this can be set in /etc/sysconfig/language. I am using RC_LANG="de_DE.UTF-8", but other valid values should be fine, too.

For SuSE 8.2 I am currently using the source rpm files from ftp://ftp.suse.com/pub/projects/postgresql/postgresql-8.1.1/postgresql-8.1.1-1.src.rpm and the appended patches for the spec files to build the rpms.

Best regards,
Johannes Weberhofer

--- postgres.811-suse/postgresql.spec 2005-12-14 15:31:48.000000000 +0100
+++ postgres.811/postgresql.spec 2005-12-15 08:48:18.000000000 +0100
@@ -10,7 +10,7 @@

# norootforbuild
# neededforbuild kerberos-devel-packages openssl openssl-devel pam-devel readline readline-devel
-# usedforbuild aaa_base acl attr bash bind-utils bison bzip2 coreutils cpio cpp cvs cyrus-sasl db devs diffutils e2fsprogs file filesystem fillup findutils flex gawk gdbm-devel glibc glibc-devel glibc-locale gpm grep groff gzip info insserv kbd less libacl libattr libgcc libstdc++ libxcrypt m4 make man mktemp modutils ncurses ncurses-devel net-tools netcfg openldap2-client openssl pam pam-devel pam-modules patch permissions popt ps rcs readline sed sendmail shadow strace syslogd sysvinit tar texinfo timezone unzip util-linux vim zlib zlib-devel autoconf automake binutils cracklib e2fsprogs-devel gcc gdbm gettext heimdal heimdal-devel heimdal-lib libtool openssl-devel perl readline-devel rpm
+# usedforbuild aaa_base acl attr bash bind9-utils bison bzip2 coreutils cpio cpp cracklib cvs cyrus-sasl2 db devs diffutils e2fsprogs file filesystem fillup findutils flex gawk gdbm-devel glibc glibc-devel glibc-locale gpm grep groff gzip info insserv less libacl libattr libgcc libstdc++ libxcrypt m4 make man mktemp modutils ncurses ncurses-devel net-tools netcfg openldap2-client openssl pam pam-modules patch permissions popt ps shadow rcs readline sed strace syslogd sysvinit tar tcpd texinfo timezone unzip util-linux vim zlib zlib-devel autoconf automake binutils gcc gdbm gettext heimdal-devel heimdal-lib libtool openssl-devel pam-devel perl readline-devel rpm

Name: postgresql
Summary: PostgreSQL - the Database
@@ -78,7 +78,7 @@
%package libs
Summary: The shared libraries required for any PostgreSQL clients
Group: Productivity/Databases/Clients
-Provides: pg_ifa pg_lib postgresql-lib postgresql-libs = 8.0.1
+Provides: pg_ifa pg_lib postgresql-lib postgresql-libs = %{version}
Obsoletes: pg_ifa pg_lib postgresql-lib
PreReq: sh-utils fileutils

@@ -241,7 +241,16 @@
# Run the regression tests.
#
%ifnarch %arm
-make check || {
+%if %suse_version < 900
+if test -z "`grep '^testuser:' /etc/passwd`" ; then
+ useradd testuser
+fi
+chown -R testuser. src/test/
+SUCMD="su testuser -c"
+%else
+SUCMD=""
+%endif
+$SUCMD "make check" || {
cat regression.diffs
exit 1
}
@@ -280,7 +289,10 @@
gcc -shared -o %buildroot%_libdir/postgresql/backup/libreadline.so.4 -lreadline
gcc -shared -o %buildroot%_libdir/postgresql/backup/libssl.so.0.9.6 -lssl
gcc -shared -o %buildroot%_libdir/postgresql/backup/libcrypto.so.0.9.6 -lcrypto
+%if %suse_version < 1000
# This hack is needed because the soname major version was bumped in a patchlevel release
+gcc -shared -Wl,-soname,libpq.so.3 -o %buildroot%_libdir/libpq.so.3 -L%buildroot%_libdir -lpq
+%endif
cp doc/FAQ doc/KNOWN_BUGS doc/MISSING_FEATURES doc/README* COPYRIGHT \
README HISTORY doc/bug.template %buildroot%_docdir/postgresql
cp -a %SOURCE2 %buildroot%_docdir/postgresql/README.SuSE.de
@@ -462,6 +474,8 @@
%doc %_mandir/man1/pg_config.1*

%changelog -n postgresql
+* Thu Dec 15 2005 - office(at)weberhofer(dot)at
+- fixed some incompatibilities with SuSE 8.2 and SuSE 9.0
* Wed Dec 14 2005 - max(at)suse(dot)de
- New version: 8.1.1
* Fri Jun 17 2005 - max(at)suse(dot)de

--- postgres.811-suse/postgresql-pl.spec 2005-12-14 15:25:17.000000000 +0100
+++ postgres.811/postgresql-pl.spec 2005-12-15 08:46:43.000000000 +0100
@@ -1,5 +1,5 @@
#
-# spec file for package postgresql-pl (Version 8.0.3)
+# spec file for package postgresql-pl (Version 8.1.1)
#
# Copyright (c) 2005 SUSE LINUX Products GmbH, Nuernberg, Germany.
# This file and all modifications and additions to the pristine
@@ -11,7 +11,7 @@
# norootforbuild
# neededforbuild kerberos-devel-packages openssl openssl-devel pam-devel python python-devel tcl tcl-devel

-BuildRequires: aaa_base acl attr bash bind-utils bison bzip2 coreutils cpio cpp cracklib cvs cyrus-sasl db devs diffutils e2fsprogs file filesystem fillup findutils flex gawk gdbm-devel gettext-devel glibc glibc-devel glibc-locale gpm grep groff gzip info insserv klogd less libacl libattr libcom_err libgcc libnscd libselinux libstdc++ libxcrypt libzio m4 make man mktemp module-init-tools ncurses ncurses-devel net-tools netcfg openldap2-client openssl pam pam-modules patch permissions popt procinfo procps psmisc pwdutils rcs readline sed strace sysvinit tar tcpd texinfo timezone unzip util-linux vim zlib zlib-devel autoconf automake binutils e2fsprogs-devel gcc gdbm gettext krb5 krb5-devel libtool openssl-devel pam-devel perl python python-devel rpm tcl tcl-devel
+# usedforbuild aaa_base acl attr bash bind9-utils bison bzip2 coreutils cpio cpp cracklib cvs cyrus-sasl2 db devs diffutils e2fsprogs file filesystem fillup findutils flex gawk gdbm-devel gettext glibc glibc-devel glibc-locale gpm grep groff gzip info insserv syslogd less libacl libattr libgcc libstdc++ libxcrypt m4 make man mktemp modutils ncurses ncurses-devel net-tools netcfg openldap2-client openssl pam pam-modules patch permissions popt ps shadow rcs readline sed strace sysvinit tar tcpd texinfo timezone unzip util-linux vim zlib zlib-devel autoconf automake binutils gcc gdbm heimdal-devel heimdal-lib gettext libtool openssl-devel pam-devel perl python python-devel rpm tcl tcl-devel

Name: postgresql-pl
Summary: The PL/Tcl, PL/Perl, and PL/Python Procedural Languages for PostgreSQL

--

|---------------------------------
| weberhofer GmbH | Johannes Weberhofer
| information technologies, Austria
|
| phone : +43 (0)1 5454421 0 | email: office(at)weberhofer(dot)at
| fax : +43 (0)1 5454421 19 | web : http://weberhofer.at
| mobile: +43 (0)699 11998315
|----------------------------------------------------------->>