Thread: postgres rpms for solaris and suse

postgres rpms for solaris and suse

From
"Kasia Tuszynska"
Date:
Hello Everybody,

I would like to install Postgresql 8.2.4 or Postgresql 8.3 on both
solaris 10 and suse10.
On the postgres site I found rpms to install on red hat and fedora, but
not for the os' above.

Does that mean that in order to install on either solaris or suse I :
1. need to install from source
2. can use the red hat rpms
a. (I tried that on suse, the rpm install failed with dependencies to 3
.so's, I thought of finding the so's and trying again)
3. get the rpms from a different location
a. (I tried that as well, for solaris I found rpms build by solaris
folks but they were not the version I needed, for suse I also found rpms
on a suse site but upon their execution, the data dir of PGDATA was not
created, so postgres did not have anything to initialize off of,
rendering those rpms not very trust worthy)

Is there some magic rpm source I am missing? Or should I just install
from source?

Thank you,
Sincerely,
Kasia

Re: postgres rpms for solaris and suse

From
"Scott Marlowe"
Date:
On Feb 8, 2008 5:54 PM, Kasia Tuszynska <ktuszynska@esri.com> wrote:
> Hello Everybody,
>
> I would like to install Postgresql 8.2.4 or Postgresql 8.3 on both
> solaris 10 and suse10.

Sun makes packages of postgresql available.  Do a search for
postgresql on the sun.com site.  Last I checked it was in the top 10.

> On the postgres site I found rpms to install on red hat and fedora, but
> not for the os' above.

Yeah, that's to be expected.

> Does that mean that in order to install on either solaris or suse I :
> 1. need to install from source

For Suse, probably if you want to keep up to date.

> 2. can use the red hat rpms

Nope.

> Is there some magic rpm source I am missing? Or should I just install
> from source?

Honestly, on a db only server it's not an entirely crazy idea.  About
2/3 of all pgsql servers I've set up have been source builds for
various reasons.  Just create a conf.local file that's a sh script
with all your options and put that script into source repo, and if you
need ot build a new server you just need that and a .tar.gz file.
Dead simple.

If you want multiple versions just use --prefix to put each in a
different directory and set a lib path for each env before starting.

Re: postgres rpms for solaris and suse

From
"Peter Koczan"
Date:
> > Is there some magic rpm source I am missing? Or should I just install
> > from source?
>
> Honestly, on a db only server it's not an entirely crazy idea.  About
> 2/3 of all pgsql servers I've set up have been source builds for
> various reasons.  Just create a conf.local file that's a sh script
> with all your options and put that script into source repo, and if you
> need ot build a new server you just need that and a .tar.gz file.
> Dead simple.
>
> If you want multiple versions just use --prefix to put each in a
> different directory and set a lib path for each env before starting.

Where I work, I compile source and install binaries and libraries and
such into a networked file system (AFS in this case). When I upgrade,
all I have to do is compile once for each platform that I use and tell
the database server and clients that the new binaries are located at
/s/postgresql-8.2.6, for instance. Through a little hand-waving, smart
use of symlinks, and some AFS magic, everything "just works". It's a
lot easier than installing things everywhere.

Of course, you might not have access to a networked FS for installing
software. You could, in theory, compile PostgreSQL for each platform
you want, and then package it using a preferred format, and distribute
it that way. Sadly, I don't have experience doing this so I don't know
all the caveats involved.

Note that the databases themselves are stored locally on the database
servers, and not in AFS. Networked file systems aren't good for
databases, for both performance and reliability reasons, as has been
discussed before on these mailing lists.

Hope this helps.

Peter

Re: postgres rpms for solaris and suse

From
Peter Eisentraut
Date:
Am Samstag, 9. Februar 2008 schrieb Kasia Tuszynska:
> I would like to install Postgresql 8.2.4 or Postgresql 8.3 on both
> solaris 10 and suse10.
> On the postgres site I found rpms to install on red hat and fedora, but
> not for the os' above.

I have put 8.3.0 RPMs for SUSE on the openSUSE Build Service.  Search for it
at http://software.opensuse.org/search.

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