Обсуждение: postgres rpms for solaris and suse
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
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.
> > 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
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/