Re: Installation trouble - Solved

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 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@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 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@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

Bruce Momjian wrote:

This patch should be sent to SuSE, not PostgreSQL.

Actually, I think this should be incoporated into a spec file
specifically for suse within the PGDG rpms.

Sincerely,

Joshua D. Drake

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/

Joshua D. Drake wrote:

Bruce Momjian wrote:

This patch should be sent to SuSE, not PostgreSQL.

Actually, I think this should be incoporated into a spec file
specifically for suse within the PGDG rpms.

The PostgreSQL Global Development Group has official RPMs? I didn't
know. When Lamar did it it was always unofficial.

-- 
  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

Actually, I think this should be incoporated into a spec file
specifically for suse within the PGDG rpms.

The PostgreSQL Global Development Group has official RPMs? I didn't
know. When Lamar did it it was always unofficial.

Well they are kept on PostgreSQL.Org servers, they are called PGDG
rpms... I don't
think you can get much more official then that.

Joshua D. Drake

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/

Joshua D. Drake wrote:

Actually, I think this should be incoporated into a spec file
specifically for suse within the PGDG rpms.

The PostgreSQL Global Development Group has official RPMs? I didn't
know. When Lamar did it it was always unofficial.

Well they are kept on PostgreSQL.Org servers, they are called PGDG
rpms... I don't
think you can get much more official then that.

I think they are official like pginstaller/Win32 is official. It is
endorsed by our project, but sort of separate too.

-- 
  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

Well they are kept on PostgreSQL.Org servers, they are called PGDG
rpms... I don't
think you can get much more official then that.

I think they are official like pginstaller/Win32 is official. It is
endorsed by our project, but sort of separate too.

O.k. well now I am confused... Why the distinction?

Is TSearch2 part of the PostgreSQL project?, plPerl?

Those are both, independent though included in core (although one is
contrib)?

Joshua D. Drake

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/

Joshua D. Drake wrote:

Well they are kept on PostgreSQL.Org servers, they are called PGDG
rpms... I don't
think you can get much more official then that.

I think they are official like pginstaller/Win32 is official. It is
endorsed by our project, but sort of separate too.

O.k. well now I am confused... Why the distinction?

Is TSearch2 part of the PostgreSQL project?, plPerl?

Those are both, independent though included in core (although one is
contrib)?

The distinction is that RPMs and pginstaller are port-specific, binary
distributions.

-- 
  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

The distinction is that RPMs and pginstaller are port-specific, binary
distributions.

So they can't be considered official port releases for the PGDG? They
are not "forks".
Or, are you saying that the only official PGDG release is the source?

Sincerely,

Joshua D. Drake

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/

Joshua D. Drake wrote:

The distinction is that RPMs and pginstaller are port-specific, binary
distributions.

So they can't be considered official port releases for the PGDG? They
are not "forks".
Or, are you saying that the only official PGDG release is the source?

Yes, I think the only official PGDG stuff is source. The binaries are
done by port-specific teams. PGDG doesn't deal with MSI installer
issues, or RPM issues, only the port-specific teams do. I know I don't
read any RPM emails and any MSI issues are dealt with by the Win32
people.

-- 
  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

Yes, I think the only official PGDG stuff is source. The binaries are
done by port-specific teams. PGDG doesn't deal with MSI installer
issues, or RPM issues, only the port-specific teams do. I know I don't
read any RPM emails and any MSI issues are dealt with by the Win32
people.

Bruce using that methodology the website would not be official PGDG.
Hackers don't
deal with specific website issues, on the website team does.

Sincerely,

Joshua D. Drake

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/

Hi,

On Sat, 2005-12-17 at 09:19 -0800, Joshua D. Drake wrote:

This patch should be sent to SuSE, not PostgreSQL.

Actually, I think this should be incoporated into a spec file
specifically for suse within the PGDG rpms.

Well... PGDG RPM Building Project only aims to build RPMs for Red Hat
and Fedora Core. This has been so before, and personally *I* intend to
continue with the same policy.

Also, Reinhard Max is building official up2date SuSE packages.

One may state that Tom Lane is building RPMs for Fedora Core / Red Hat,
however RHEL policy does not allow users by upgrading to latest versions
via up2date; so I know that those people (including me :-) ) use the
community RPM versions to keep up with the latest version.

So, as Bruce stated, the patch (does not fit into our spec and) should
be redirected to SuSE.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/

Devrim GUNDUZ wrote:

Well... PGDG RPM Building Project only aims to build RPMs for Red Hat
and Fedora Core. This has been so before, and personally *I* intend to
continue with the same policy.

I specifically recall that this was once exactly not the policy, but of
course you are free to do what you want. (In my mind it certainly
makes technical sense to produce operating system specific packages.)

But I have two requests to clarify this situation:

1. Adjust the description of the pgfoundry project pgsqlrpms to
something like "This project aims to build PostgreSQL RPMS for Red Hat
and Fedora and maintain them."

2. When you put them on the FTP server, put them in a subdirectory
"redhat" (instead of or below "linux") to avoid that users fall into
the trap redhat == linux == rpm.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

1. Adjust the description of the pgfoundry project pgsqlrpms to
something like "This project aims to build PostgreSQL RPMS for Red Hat
and Fedora and maintain them."

2. When you put them on the FTP server, put them in a subdirectory
"redhat" (instead of or below "linux") to avoid that users fall into
the trap redhat == linux == rpm.

This is already done:

/pub/mirrors/postgresql/binary/v8.1.1/linux/rpms

227 Entering Passive Mode (128,111,24,43,254,97).
150 Opening ASCII mode data connection for file list
drwxr-xr-x 7 ftp ftp 512 Dec 13 15:35 fedora
drwxr-xr-x 8 ftp ftp 512 Dec 17 02:36 redhat

Devrim perhaps we should talk with the OpenSuSE guy about getting his
RPMS up there as well?

Joshua D. Drake

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/

Hi,

On Mon, 19 Dec 2005, Joshua D. Drake wrote:

Devrim perhaps we should talk with the OpenSuSE guy about getting his RPMS up
there as well?

We once did that; but SuSE could not keep up2date with the new versions. I
don't know the current status, though. We'd be happy to mirror them in
our FTP site... Let me contact with Reinhard again.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

Hi,

On Mon, 19 Dec 2005, Peter Eisentraut wrote:

1. Adjust the description of the pgfoundry project pgsqlrpms to
something like "This project aims to build PostgreSQL RPMS for Red Hat
and Fedora and maintain them."

Done.

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

Joshua D. Drake wrote:

/pub/mirrors/postgresql/binary/v8.1.1/linux/rpms

227 Entering Passive Mode (128,111,24,43,254,97).
150 Opening ASCII mode data connection for file list
drwxr-xr-x 7 ftp ftp 512 Dec 13 15:35 fedora
drwxr-xr-x 8 ftp ftp 512 Dec 17 02:36 redhat

OK, but that is still weird. Either it's linux/fedora/rpms or
rpms/linux/fedora. The other way doesn't make sense.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Peter Eisentraut wrote:

Joshua D. Drake wrote:

/pub/mirrors/postgresql/binary/v8.1.1/linux/rpms

227 Entering Passive Mode (128,111,24,43,254,97).
150 Opening ASCII mode data connection for file list
drwxr-xr-x 7 ftp ftp 512 Dec 13 15:35 fedora
drwxr-xr-x 8 ftp ftp 512 Dec 17 02:36 redhat

OK, but that is still weird. Either it's linux/fedora/rpms or
rpms/linux/fedora. The other way doesn't make sense.

I don't know about that because I am hoping to start provided .debs as
well and
.debs are going to be at a minimum /linux/debs/ubuntu and /linux/debs/debian

Sincerely,

Joshua D. Drake

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/

Joshua D. Drake wrote:

I don't know about that because I am hoping to start provided .debs as
well and
.debs are going to be at a minimum /linux/debs/ubuntu

and /linux/debs/debian

But Debian packages are not only available on Linux. (The same is
reportedly true of RPM, but I don't know of a practical example.) I
think debian, redhat, etc. are the operating system names that parallel
"win32". "linux" should just disappear. And so should "rpms" or
"debs" unless it's part of the tree's internal organisation.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/