Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 96A80635F01 for ; Tue, 9 Mar 2010 04:33:55 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 41402-03 for ; Tue, 9 Mar 2010 08:33:41 +0000 (UTC) X-Greylist: delayed 00:09:12.479963 by SQLgrey-1.7.6 Received: from smtp5.clear.net.nz (smtp5.clear.net.nz [203.97.33.68]) by mail.postgresql.org (Postfix) with ESMTP id CBBCA634603 for ; Tue, 9 Mar 2010 04:33:36 -0400 (AST) Received: from [192.168.10.20] (203-97-214-3.cable.telstraclear.net [203.97.214.3]) by smtp5.clear.net.nz (CLEAR Net Mail) with ESMTP id <0KZ0005ACAFPW200@smtp5.clear.net.nz> for pgsql-admin@postgresql.org; Tue, 09 Mar 2010 21:33:26 +1300 (NZDT) Date: Tue, 09 Mar 2010 21:33:21 +1300 From: Rodger Donaldson Subject: Re: linux standard layout In-reply-to: <20B070D4-89E4-4618-94C4-F506B4B3EDAC@mimectl> To: "Plugge, Joe R." Cc: "pgsql-admin@postgresql.org" Reply-to: rodger@diaspora.gen.nz Message-id: <4B9607D1.9050401@diaspora.gen.nz> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit References: <5BE5D209-D7A9-4F4C-A58B-6628F0AC5915@mimectl> <20B070D4-89E4-4618-94C4-F506B4B3EDAC@mimectl> User-Agent: Thunderbird 2.0.0.23 (Windows/20090812) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/61 X-Sequence-Number: 33860 Plugge, Joe R. wrote: > It has been a while ago Scott, I don't remember exactly. If it currently is not an issue then I will not be so resistant to using packages/rpms for postgres installs. One other item, and maybe it is just that I have never done it ... how would one install a package/rpm and change page size, XML, or enable ssl connections? Just curious? I've literally never run into this on any version of Linux I've used (RH before they had EL and Fedora, RHEL, Fedora, Debian, Ubunt). Certainly I'd be stunned if any of the enterprise/long term release oriented distros did it (RHEL, CentOS, SLES, Debian, etc). Most packagers enable everything and the kitchen sink. I don't have a RHEL box handy, but as you can see from this Fedora 11 list: postgresql.i586 : PostgreSQL client programs and libraries postgresql-contrib.i586 : Contributed source and binaries distributed with : PostgreSQL postgresql-dbi-link.noarch : Partial implementation of the SQL/MED portion of : the SQL:2003 specification postgresql-devel.i586 : PostgreSQL development header files and libraries postgresql-docs.i586 : Extra documentation for PostgreSQL postgresql-ip4r.i586 : IPv4 and IPv4 range index types for PostgreSQL postgresql-jdbc.i586 : JDBC driver for PostgreSQL postgresql-libs.i586 : The shared libraries required for any PostgreSQL clients postgresql-odbc.i586 : PostgreSQL ODBC driver postgresql-odbcng.i586 : PostgreSQL ODBCng driver postgresql-pgpool-II.i586 : Pgpool is a connection pooling/replication server : for PostgreSQL postgresql-pgpool-II-devel.i586 : The development files for pgpool-II postgresql-pgpool-ha.noarch : Pgpool-HA uses heartbeat to keep pgpool from being : a single point of failure postgresql-pgpoolAdmin.noarch : PgpoolAdmin - web-based pgpool administration postgresql-plperl.i586 : The Perl procedural language for PostgreSQL postgresql-plpython.i586 : The Python procedural language for PostgreSQL postgresql-plruby.i586 : PostgreSQL Ruby Procedural Language postgresql-plruby-doc.i586 : Documentation for plruby postgresql-pltcl.i586 : The Tcl procedural language for PostgreSQL postgresql-python.i586 : Development module for Python code to access a : PostgreSQL DB postgresql-server.i586 : The programs needed to create and run a PostgreSQL : server postgresql-table_log.i586 : Log data changes in a PostgreSQL table postgresql-tcl.i586 : A Tcl client library for PostgreSQL postgresql-test.i586 : The test suite distributed with PostgreSQL postgresql_autodoc.noarch : PostgreSQL AutoDoc Utility ...what you get is pretty much everything, and the binaries are built with pretty much every option (kerberos, openssl, languages) either on or built into installable packages. The other benefit is that I know the PostgreSQL support for everything else on that Fedora system (PHP, Ruby, etc), will be at a matching version and tested to work with the server install. If Fedora have built with some options you don't like, my preference is to download the SRPM, tinker with the spec file, and build a new set of RPMs, which maximised the chances of everything just working.