Re: Installation trouble - Solved - Mailing list pgsql-general

This patch should be sent to SuSE, not PostgreSQL.

---------------------------------------------------------------------------

Weberhofer GmbH wrote:
> 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
othervalid 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.rpmand the appended patches for the
specfiles 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
e2fsprogsfile filesystem fillup findutils flex gawk gdbm-devel glibc glibc-devel glibc-locale gpm grep groff gzip info
insservkbd less libacl libattr libgcc libstdc++ libxcrypt m4 make man mktemp modutils ncurses ncurses-devel net-tools
netcfgopenldap2-client openssl pam pam-devel pam-modules patch permissions popt ps rcs readline sed sendmail shadow
stracesyslogd sysvinit tar texinfo timezone unzip util-linux vim zlib zlib-devel autoconf automake binutils cracklib
e2fsprogs-develgcc 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
diffutilse2fsprogs file filesystem fillup findutils flex gawk gdbm-devel glibc glibc-devel glibc-locale gpm grep groff
gzipinfo insserv less libacl libattr libgcc libstdc++ libxcrypt m4 make man mktemp modutils ncurses ncurses-devel
net-toolsnetcfg openldap2-client openssl pam pam-modules patch permissions popt ps shadow rcs readline sed strace
syslogdsysvinit tar tcpd texinfo timezone unzip util-linux vim zlib zlib-devel autoconf automake binutils gcc gdbm
gettextheimdal-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@weberhofer.at
> +- fixed some incompatibilities with SuSE 8.2 and SuSE 9.0
>  * Wed Dec 14 2005 - max@suse.de
>  - New version: 8.1.1
>  * Fri Jun 17 2005 - max@suse.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
diffutilse2fsprogs file filesystem fillup findutils flex gawk gdbm-devel gettext-devel glibc glibc-devel glibc-locale
gpmgrep groff gzip info insserv klogd less libacl libattr libcom_err libgcc libnscd libselinux libstdc++ libxcrypt
libziom4 make man mktemp module-init-tools ncurses ncurses-devel net-tools netcfg openldap2-client openssl pam
pam-modulespatch permissions popt procinfo procps psmisc pwdutils rcs readline sed strace sysvinit tar tcpd texinfo
timezoneunzip util-linux vim zlib zlib-devel autoconf automake binutils e2fsprogs-devel gcc gdbm gettext krb5
krb5-devellibtool 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
diffutilse2fsprogs file filesystem fillup findutils flex gawk gdbm-devel gettext glibc glibc-devel glibc-locale gpm
grepgroff gzip info insserv syslogd less libacl libattr libgcc libstdc++ libxcrypt m4 make man mktemp modutils ncurses
ncurses-develnet-tools netcfg openldap2-client openssl pam pam-modules patch permissions popt ps shadow rcs readline
sedstrace sysvinit tar tcpd texinfo timezone unzip util-linux vim zlib zlib-devel autoconf automake binutils gcc gdbm
heimdal-develheimdal-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@weberhofer.at
> |  fax   : +43 (0)1 5454421 19   | web  : http://weberhofer.at
> |  mobile: +43 (0)699 11998315
> |----------------------------------------------------------->>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073