Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3F8632E32A4 for ; Mon, 11 Feb 2008 17:47:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 91158-01-3 for ; Mon, 11 Feb 2008 17:46:57 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.176]) by postgresql.org (Postfix) with ESMTP id 61DFF2E3309 for ; Mon, 11 Feb 2008 17:46:41 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so2639786waf.5 for ; Mon, 11 Feb 2008 13:46:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=cEuEzsigijeqEZxmCGX7V+e7++gJLUpKLefJQePPtHo=; b=v0ojP4eDiEQbeznB9+RLivo/j7AUfZguANMWrZ/lYaTtcBLoXTQ9tzvxdkvIETAer8tBT6rr7YvOyiqtoxWNAN7bkxPgvCNj3xo95b6kt0M2H8OJlTU9NrP8J0vf1S0OhUHeD2AKatEWK3I+Awhms01mbmDItFVYbKtr3Sn/TNI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=A1KqBsQeCEnhgDiVDrxUuv2FY5qZGH6cdcigeGYoplOh6QAMyYhgh5+I76guVUwxFMXvTOKWOahZ5aQjvt8KEaNnitXOy9v06XIjR+4jzsZbyj8Prj4RvcHSrTj8r/oUTg2BbhmY4os1v0bkEI7pe1QuRfU877StCVlywaaShEI= Received: by 10.115.90.1 with SMTP id s1mr568703wal.50.1202766400109; Mon, 11 Feb 2008 13:46:40 -0800 (PST) Received: by 10.114.199.20 with HTTP; Mon, 11 Feb 2008 13:46:40 -0800 (PST) Message-ID: <4544e0330802111346u6723997bs2e3f3cbc82fc812e@mail.gmail.com> Date: Mon, 11 Feb 2008 15:46:40 -0600 From: "Peter Koczan" To: "Kasia Tuszynska" Subject: Re: postgres rpms for solaris and suse Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/144 X-Sequence-Number: 28218 > > 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