Обсуждение: Download not found for postgreSQL 9.1 for both SUSE and Red Hat on IBM Power (ppc)

Hi,

Referring to the document for PostgreSQL 9.1 supported platforms http://www=
.postgresql.org/docs/9.1/static/supported-platforms.html, it is mentioned t=
hat=20
1.  In general, PostgreSQL can be expected to work on these CPU architectur=
es: x86, x86_64, IA64, PowerPC, PowerPC 64, S/390, S/390x, Sparc, Sparc 64,=
 Alpha, ARM, MIPS, MIPSEL, M68K, and PA-RISC.
2. PostgreSQL can be expected to work on these operating systems: Linux (al=
l recent distributions), Windows (Win2000 SP4 and later), FreeBSD, OpenBSD,=
 NetBSD, Mac OS X, AIX, HP/UX, IRIX, Solaris, Tru64 Unix, and UnixWare.

I would like to find out whether postgreSQL 9.1 is supported for both SUSE =
and Red Hat on IBM Power (ppc). From the above it seems that it is supporte=
d however I am unable to find the download links for both SUSE and Red Hat =
on IBM Power.=20

On the SUSE site I am only able to find download for i586 and x86_64 only. =
(http://software.opensuse.org/search?q=3Dpostgres&baseproject=3DSUSE%3ASLE-=
11%3ASP1&lang=3Den&exclude_debug=3Dtrue)=20
On rpm repositories site I am able to find repo packages for Red Hat Enterp=
rise for i386 and x86_64 only. (http://yum.postgresql.org/repopackages.php )

What is the latest version of postgreSQL supported for  SUSE and Red Hat on=
 IBM Power (ppc) ? Is it still supported or not going to be released for po=
stgreSQL 9.1? If it is still supported please send me the download links fo=
r both SUSE and Red Hat on IBM Power.

Regards,
Eye Gee=

On Wed, Mar 28, 2012 at 4:02 AM, Eye Gee <eyegee@cmg.com.my> wrote:
> Referring to the document for PostgreSQL 9.1 supported platforms
> http://www.postgresql.org/docs/9.1/static/supported-platforms.html, it is
> mentioned that
> 1.=A0 In general, PostgreSQL can be expected to work on these CPU
> architectures: x86, x86_64, IA64, PowerPC, PowerPC 64, S/390, S/390x, Spa=
rc,
> Sparc 64, Alpha, ARM, MIPS, MIPSEL, M68K, and PA-RISC.
> 2. PostgreSQL can be expected to work on these operating systems: Linux (=
all
> recent distributions), Windows (Win2000 SP4 and later), FreeBSD, OpenBSD,
> NetBSD, Mac OS X, AIX, HP/UX, IRIX, Solaris, Tru64 Unix, and UnixWare.
>
> I would like to find out whether postgreSQL 9.1 is supported for both SUSE
> and Red Hat on IBM Power (ppc). From the above it seems that it is
> supported=A0however I am unable to find the download links for both SUSE =
and
> Red Hat on IBM Power.
>
> On the SUSE site I am only able to find download for i586 and x86_64 only.
> (http://software.opensuse.org/search?q=3Dpostgres&baseproject=3DSUSE%3ASL=
E-11%3ASP1&lang=3Den&exclude_debug=3Dtrue)
> On rpm repositories site I am able to find repo packages for Red Hat
> Enterprise for i386 and x86_64 only.
> (http://yum.postgresql.org/repopackages.php )
>
> What is the latest version of postgreSQL supported for=A0 SUSE and Red Ha=
t on
> IBM Power (ppc) ? Is it=A0still supported or not going to be released for
> postgreSQL 9.1? If it is still supported=A0please send me the download=A0=
links
> for both SUSE and Red Hat on IBM Power.

I think you're confusing the question of platform support with the
question of package availability.  If you're running a Linux
distribution such as SUSE or Red Hat, the easiest way to install
PostgreSQL is by using your operating system's package management tool
- e.g., on Red Hat:

yum list available 'postgresql*'
yum install postgresql-server postgresql (and any others you want)

I don't know the corresponding commands for SuSE, but I'm sure they
exist.  The packages at http://yum.postgresql.org/repopackages.php are
alternative packages published by the PostgreSQL project itself, which
can be useful if (for example) your operating system vendor is
shipping an older version, and you want the latest and greatest.  But
you're only going to find pre-built binary packages there for the most
popular version/distribution/architecture combinations.  If you are
running something more obscure and don't want to use your OS vendor's
packages, you can still compile it yourself, and it should work fine.
I've done a bunch of testing recently on PPC64 and it works great.

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Hi Robert,

Thanks for your reply.

I am actually looking for postgresql packages for SUSE and Red Hat on IBM
Power.

I found the site  for SUSE Linux Enterprise Server 11 for IBM PPC,

http://www.suse.com/LinuxPackages/packageRouter.jsp?product=server&version=11&service_pack=&architecture=ppc&package_name=index_group
However the postgresql version is 8.3.5. I need the latest version which is
9.1,

The site http://yum.postgresql.org/repopackages.php which mentioned is only
available for for Red Hat Enterprise for i386 and x86_64 only. I need Red
Hat on IBM Power.

The rpm files should have a ppc64.rpm  extension. However I am unable to
find such installer for version 9.1. I can only find for version 8.3.5 for
SUSE on IBM Power.

Can you point to me which sites I can refer to for the 9.1 installer for
SUSE and Red Hat for IBM Power. We would like to evaluate postgreSQL on SUSE
and Red Hat on IBM Power.  Subscription to support from your side could also
be needed at future stage.

Regards,
Eye Gee


----- Original Message -----
From: "Robert Haas" <robertmhaas@gmail.com>
To: "Eye Gee" <eyegee@cmg.com.my>
Cc: <pgsql-bugs@postgresql.org>
Sent: Sunday, April 01, 2012 8:46 AM
Subject: Re: [BUGS] Download not found for postgreSQL 9.1 for both SUSE and
Red Hat on IBM Power (ppc)


On Wed, Mar 28, 2012 at 4:02 AM, Eye Gee <eyegee@cmg.com.my> wrote:
> Referring to the document for PostgreSQL 9.1 supported platforms
> http://www.postgresql.org/docs/9.1/static/supported-platforms.html, it is
> mentioned that
> 1. In general, PostgreSQL can be expected to work on these CPU
> architectures: x86, x86_64, IA64, PowerPC, PowerPC 64, S/390, S/390x,
> Sparc,
> Sparc 64, Alpha, ARM, MIPS, MIPSEL, M68K, and PA-RISC.
> 2. PostgreSQL can be expected to work on these operating systems: Linux
> (all
> recent distributions), Windows (Win2000 SP4 and later), FreeBSD, OpenBSD,
> NetBSD, Mac OS X, AIX, HP/UX, IRIX, Solaris, Tru64 Unix, and UnixWare.
>
> I would like to find out whether postgreSQL 9.1 is supported for both SUSE
> and Red Hat on IBM Power (ppc). From the above it seems that it is
> supported however I am unable to find the download links for both SUSE and
> Red Hat on IBM Power.
>
> On the SUSE site I am only able to find download for i586 and x86_64 only.
> (http://software.opensuse.org/search?q=postgres&baseproject=SUSE%3ASLE-11%3ASP1&lang=en&exclude_debug=true)
> On rpm repositories site I am able to find repo packages for Red Hat
> Enterprise for i386 and x86_64 only.
> (http://yum.postgresql.org/repopackages.php )
>
> What is the latest version of postgreSQL supported for SUSE and Red Hat on
> IBM Power (ppc) ? Is it still supported or not going to be released for
> postgreSQL 9.1? If it is still supported please send me the download links
> for both SUSE and Red Hat on IBM Power.

I think you're confusing the question of platform support with the
question of package availability.  If you're running a Linux
distribution such as SUSE or Red Hat, the easiest way to install
PostgreSQL is by using your operating system's package management tool
- e.g., on Red Hat:

yum list available 'postgresql*'
yum install postgresql-server postgresql (and any others you want)

I don't know the corresponding commands for SuSE, but I'm sure they
exist.  The packages at http://yum.postgresql.org/repopackages.php are
alternative packages published by the PostgreSQL project itself, which
can be useful if (for example) your operating system vendor is
shipping an older version, and you want the latest and greatest.  But
you're only going to find pre-built binary packages there for the most
popular version/distribution/architecture combinations.  If you are
running something more obscure and don't want to use your OS vendor's
packages, you can still compile it yourself, and it should work fine.
I've done a bunch of testing recently on PPC64 and it works great.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

"Eye Gee" <eyegee@cmg.com.my> wrote:

> Can you point to me which sites I can refer to for the 9.1
> installer for SUSE and Red Hat for IBM Power.

As Robert pointed out, there is a difference between an environment
being supported by the community (i.e., we expect it to work if
built and installed there, and will try very hard to fix any bugs
found there) and the availability of an installer for that
environment.  It is up to someone with an interest in a particular
environment to provide an installer.

If there is no installer for a supported environment, you have the
option of building from source and installing your own build.  I
found that to be surprisingly easy, and our shop runs in production
on our own builds.  See this page for more information:

http://www.postgresql.org/docs/current/interactive/installation.html

If you have any problems while following the documented installation
steps there, please post again -- but not on the pgsql-bugs list.
Try pgsql-general.

-Kevin

Hi,

On Mon, 2012-04-02 at 12:16 +0800, Eye Gee wrote:

> The site http://yum.postgresql.org/repopackages.php which mentioned is
> only  available for for Red Hat Enterprise for i386 and x86_64 only. I
> need Red  Hat on IBM Power.

We don't have an RPM build server for PPC, so we don't have the RPMs.
for PPC in PostgreSQL RPM repository.

Regards,

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> If there is no installer for a supported environment, you have the
> option of building from source and installing your own build.

In particular, if someone else has prepared an SRPM that matches the
platform you are using, it's really quite trivial to build RPMs for
the particular architecture you are using --- basically you just point
rpmbuild --rebuild at the SRPM.

            regards, tom lane