Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 908FF9F9BFF for ; Fri, 7 Sep 2007 22:57:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 91234-09 for ; Fri, 7 Sep 2007 22:57:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.190]) by postgresql.org (Postfix) with ESMTP id 09CF09FA068 for ; Fri, 7 Sep 2007 22:57:35 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id l15so548657rvb for ; Fri, 07 Sep 2007 18:57:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; 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=03QUCWgQhADuKzjjT7GdQR2BqLgkJtqaNsodnU1+5ug=; b=uZVF3iiUbeyWblToleQRCa/sh91mjVDi1gwSfu14YyGH4plyGQlDydRF7ahkUQdhIF2GAfPi6T5BmgBJ+D7RuUinrIjWL1YKJ9iNOVz7lphPVGI69nx41ZT9NT5fdbjs1IbljUqMduqRrxu7Qv48srw7MdMQQBVPCmLKZZlPSz8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=UPye2MuO1ZrOSDsOepgMNEtlhmhaLUVIhwQoCDMAdLmzgSjAIYVc1Uei/0zJZTZwSHzl567Luhqm4Ic/m1rvGQtyjU4fqE6Mlq/L/+1+1MZr5Vc2v8k3yFBQQkZPoSa5r6WxP1kSw3t4+N4QDB0KU37+cGmcaHkYIkUKNDfMWI0= Received: by 10.141.113.6 with SMTP id q6mr962248rvm.1189216654455; Fri, 07 Sep 2007 18:57:34 -0700 (PDT) Received: by 10.141.159.11 with HTTP; Fri, 7 Sep 2007 18:57:34 -0700 (PDT) Message-ID: Date: Fri, 7 Sep 2007 20:57:34 -0500 From: "Scott Marlowe" To: "Tom Lane" Subject: Re: Can't login to 8.2.4 if not superuser... Cc: "Daniel Rubio" , pgsql-admin@postgresql.org In-Reply-To: <21163.1189175920@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <46DE594F.30900@tinet.org> <13068.1189004492@sss.pgh.pa.us> <46DFAD00.5070907@tinet.org> <22268.1189088283@sss.pgh.pa.us> <46E0F84D.4080409@tinet.org> <46E102BA.7030907@tinet.org> <21163.1189175920@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/51 X-Sequence-Number: 26812 On 9/7/07, Tom Lane wrote: > Daniel Rubio writes: > > Using the older gcc version to compile, the problem disappears ... > > Hmm. gcc 4.0.4 is hardly new. I'm wondering about the weird CFLAGS and > include/link paths shown in your pg_config output. What does all that > do? > > >> CPPFLAGS = -I/sfw10/builds/build/sfw10-patch/usr/src/cmd/postgres/rltmp/include > >> -I/usr/sfw/include > >> CFLAGS = -xO3 isn't that an Optimization setting? Pretty sure pgsql is not recommended above 2. or is -xO something different? OP, Have you tried compiling with just the bare minimum switches to get a working version and go from there?