X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B55A253D9C for ; Sat, 30 Apr 2005 04:05:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86615-01 for ; Sat, 30 Apr 2005 07:05:35 +0000 (GMT) Received: from delta.evincetek.com (h-67-102-112-170.snvacaid.covad.net [67.102.112.170]) by svr1.postgresql.org (Postfix) with ESMTP id 6F5F653CD0 for ; Sat, 30 Apr 2005 04:05:34 -0300 (ADT) Received: from pengu (pengu.evincetek.com [192.168.1.52]) (authenticated bits=0) by delta.evincetek.com (8.12.11/8.12.11) with ESMTP id j3U7D7Ux013723; Sat, 30 Apr 2005 00:13:40 -0700 Message-ID: <004301c54d52$f0ea4870$3401a8c0@pengu> From: "Metin Ozisik" To: "Tom Lane" Cc: References: <003a01c549e4$1485eea0$3401a8c0@pengu> <28245.1114835916@sss.pgh.pa.us> Subject: Re: Build issues: "-static" builds resulting initdb problems Date: Sat, 30 Apr 2005 00:04:36 -0700 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.098 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/74 X-Sequence-Number: 21387 The purpose of using static linking is to reduce dependencies to shared-libraries (dependencies to different types and versions of Linux), so an instance of postgreSQL, say built on Suse 9.0, would still work on Mandrake 10.1. Yes it gets a bit bulky and have a number of disadvantages over dynamic linking (on the plus side it would be a bit faster), however the main motivater is binary portability. Regards, -metin ----- Original Message ----- From: "Tom Lane" To: "Metin Ozisik" Cc: Sent: Friday, April 29, 2005 9:38 PM Subject: Re: [SQL] Build issues: "-static" builds resulting initdb problems > "Metin Ozisik" writes: >> Build time parameter: CFLAGS="-static" ./configure > > Is there a particular reason for you to be doing that? > >> creating conversions ... FATAL: could not load library = >> "../ascii_and_misc.so": ../../ascii_and_misc.so: undefined symbol: = >> pg_mic2ascii > > pg_mic2ascii is a function exported by the core backend. I suppose > that "-static" is somehow suppressing the visibility of that symbol > to the dynamically loaded library ascii_and_misc.so. I am not sure > whether this indicates a dynamic loader bug, or whether it's a case > of "so don't do that then" ... but in any case I don't think it's > a Postgres bug. > > regards, tom lane