Thread: Re: Installation trouble - Solved

Re: Installation trouble - Solved

From
Weberhofer GmbH
Date:
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
|----------------------------------------------------------->>


Re: Installation trouble - Solved

From
Bruce Momjian
Date:
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

Re: Installation trouble - Solved

From
"Joshua D. Drake"
Date:
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/


Re: Installation trouble - Solved

From
Bruce Momjian
Date:
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

Re: Installation trouble - Solved

From
"Joshua D. Drake"
Date:
>>>
>>>
>>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/


Re: Installation trouble - Solved

From
Bruce Momjian
Date:
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

Re: Installation trouble - Solved

From
"Joshua D. Drake"
Date:
>>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/


Re: Installation trouble - Solved

From
Bruce Momjian
Date:
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

Re: Installation trouble - Solved

From
"Joshua D. Drake"
Date:
>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/


Re: Installation trouble - Solved

From
Bruce Momjian
Date:
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

Re: Installation trouble - Solved

From
"Joshua D. Drake"
Date:
>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/


Re: Installation trouble - Solved

From
Devrim GUNDUZ
Date:
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/


Re: Installation trouble - Solved

From
Peter Eisentraut
Date:
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/

Re: Installation trouble - Solved

From
"Joshua D. Drake"
Date:
>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/


Re: Installation trouble - Solved

From
Devrim GUNDUZ
Date:
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/


Re: Installation trouble - Solved

From
Devrim GUNDUZ
Date:
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/


Re: Installation trouble - Solved

From
Peter Eisentraut
Date:
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/

Re: Installation trouble - Solved

From
"Joshua D. Drake"
Date:
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/


Re: Installation trouble - Solved

From
Peter Eisentraut
Date:
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/