Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4D651632880 for ; Tue, 16 Mar 2010 20:12:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 28877-06 for ; Tue, 16 Mar 2010 23:12:06 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from out02.mta.xmission.com (out02.mta.xmission.com [166.70.13.232]) by mail.postgresql.org (Postfix) with ESMTP id 94EB7635D5E for ; Tue, 16 Mar 2010 20:12:06 -0300 (ADT) Received: from in02.mta.xmission.com ([166.70.13.52]) by out02.mta.xmission.com with esmtps (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1Nrfvg-0007DT-2D; Tue, 16 Mar 2010 17:12:04 -0600 Received: from [208.187.158.94] (helo=[172.16.1.233]) by in02.mta.xmission.com with esmtpsa (SSLv3:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1Nrfvf-0001tu-TH; Tue, 16 Mar 2010 17:12:03 -0600 Message-ID: <4BA010BF.5050209@gmail.com> Date: Tue, 16 Mar 2010 17:14:07 -0600 From: Rob Sargent User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.8) Gecko/20100228 SUSE/3.0.3-1.1.1 Lightning/1.0b1 Thunderbird/3.0.3 MIME-Version: 1.0 To: Tom Lane CC: Richard Huxton , pgsql-sql@postgresql.org Subject: Re: installing uuid generators References: <4B9EC98B.8080201@gmail.com> <4B9F4D6C.5040708@archonet.com> <4B9FC93A.1090209@gmail.com> <4B9FE5E1.9090403@archonet.com> <13996.1268771218@sss.pgh.pa.us> In-Reply-To: <13996.1268771218@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-XM-SPF: eid=; ; ; mid=; ; ; hst=in02.mta.xmission.com; ; ; ip=208.187.158.94; ; ; frm=robjsargent@gmail.com; ; ; spf=neutral X-SA-Exim-Connect-IP: 208.187.158.94 X-SA-Exim-Rcpt-To: tgl@sss.pgh.pa.us, dev@archonet.com, pgsql-sql@postgresql.org, rsargent@amirsys.com X-SA-Exim-Mail-From: robjsargent@gmail.com X-SA-Exim-Scanned: No (on in02.mta.xmission.com); SAEximRunCond expanded to false 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/118 X-Sequence-Number: 33825 On 03/16/2010 02:26 PM, Tom Lane wrote: > Richard Huxton writes: >> On 16/03/10 18:08, Rob Sargent wrote: >>> I'm still left worried about the correct procedure for getting uuid-oosp >>> installed properly on SUSE 11. Does the server release's contrib >>> contain uuid-ossp? I didn't see it on my desktop release. (I don't >>> want to have to tell my mates to go through the issues I had building >>> the lib etc.) > >> I'd be surprised if there wasn't a -contrib or -extras rpm with the >> relevant files. The community rpms should have them if the "official" >> Suse ones don't > > If there is a contrib rpm but it doesn't seem to contain uuid-ossp, > the likely reason is that the maintainer never got around to adding > --with-ossp-uuid to the build options. (I know it took me a while > to add that to the Fedora build :-(.) You could confirm or deny > that theory by looking at the output of pg_config --configure. > If so, file a bug report with SUSE asking for that to be added. > > regards, tom lane As Tom suspected the SUSE build doesn't name ossp stuff, to wit: $ pg_config BINDIR = /usr/bin DOCDIR = /usr/share/doc/packages/postgresql HTMLDIR = /usr/share/doc/packages/postgresql INCLUDEDIR = /usr/include/pgsql PKGINCLUDEDIR = /usr/include/pgsql INCLUDEDIR-SERVER = /usr/include/pgsql/server LIBDIR = /usr/lib64 PKGLIBDIR = /usr/lib64/postgresql LOCALEDIR = /usr/share/locale MANDIR = /usr/share/man SHAREDIR = /usr/share/postgresql SYSCONFDIR = /usr/etc/postgresql PGXS = /usr/lib64/postgresql/pgxs/src/makefiles/pgxs.mk CONFIGURE = '--prefix=/usr' '--libdir=/usr/lib64' '--bindir=/usr/bin' '--includedir=/usr/include/pgsql' '--datadir=/usr/share/postgresql' '--mandir=/usr/share/man' '--docdir=/usr/share/doc/packages' '--disable-rpath' '--enable-nls' '--enable-thread-safety' '--enable-integer-datetimes' '--without-python' '--without-perl' '--without-tcl' '--with-openssl' '--with-pam' '--with-krb5' '--with-gssapi' '--with-ldap' '--with-libxml' '--with-libxslt' '--with-system-tzdata=/usr/share/zoneinfo' 'CFLAGS=-fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g ' CC = gcc CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2 CFLAGS = -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv CFLAGS_SL = -fpic LDFLAGS = -Wl,--as-needed LDFLAGS_SL = LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5 -lcom_err -lgssapi_krb5 -lz -lreadline -lcrypt -ldl -lm VERSION = PostgreSQL 8.4.2 And I guess --without-perl explains some the machinations necessary to get bucardo working. Thanks to all.