From owner-freebsd-ports@freebsd.org Fri Jun 26 23:23:55 2020 Return-Path: Delivered-To: freebsd-ports@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id B0551361D8F for ; Fri, 26 Jun 2020 23:23:55 +0000 (UTC) (envelope-from pete@nomadlogic.org) Received: from mail.nomadlogic.org (mail.nomadlogic.org [174.136.98.114]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "mail.nomadlogic.org", Issuer "Let's Encrypt Authority X3" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 49ttHZ4WtDz40hk; Fri, 26 Jun 2020 23:23:54 +0000 (UTC) (envelope-from pete@nomadlogic.org) Received: from [192.168.1.160] (cpe-23-243-161-111.socal.res.rr.com [23.243.161.111]) by mail.nomadlogic.org (OpenSMTPD) with ESMTPSA id a11b2914 (TLSv1.3:TLS_AES_256_GCM_SHA384:256:NO); Fri, 26 Jun 2020 23:23:46 +0000 (UTC) Subject: Re: stable postgresql11 appears to have issues To: dwilde1@gmail.com, Christoph Moench-Tegeder Cc: freebsd-ports@freebsd.org, pgsql@freebsd.org, brooks@freebsd.org References: <20200626164512.GA2475@elch.exwg.net> From: Pete Wright Message-ID: <5c9da71e-119f-4077-27be-296e17c6e14c@nomadlogic.org> Date: Fri, 26 Jun 2020 16:23:41 -0700 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:68.0) Gecko/20100101 Thunderbird/68.9.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US X-Rspamd-Queue-Id: 49ttHZ4WtDz40hk X-Spamd-Bar: - Authentication-Results: mx1.freebsd.org; dkim=none; dmarc=none; spf=pass (mx1.freebsd.org: domain of pete@nomadlogic.org designates 174.136.98.114 as permitted sender) smtp.mailfrom=pete@nomadlogic.org X-Spamd-Result: default: False [-1.81 / 15.00]; RCVD_VIA_SMTP_AUTH(0.00)[]; ARC_NA(0.00)[]; MID_RHS_MATCH_FROM(0.00)[]; FROM_HAS_DN(0.00)[]; TO_DN_SOME(0.00)[]; R_SPF_ALLOW(-0.20)[+mx]; NEURAL_HAM_LONG(-0.95)[-0.952]; MIME_GOOD(-0.10)[text/plain]; DMARC_NA(0.00)[nomadlogic.org]; NEURAL_HAM_MEDIUM(-0.20)[-0.202]; RCPT_COUNT_FIVE(0.00)[5]; TO_MATCH_ENVRCPT_SOME(0.00)[]; NEURAL_HAM_SHORT(-0.36)[-0.358]; FREEMAIL_TO(0.00)[gmail.com,burggraben.net]; FROM_EQ_ENVFROM(0.00)[]; R_DKIM_NA(0.00)[]; MIME_TRACE(0.00)[0:+]; ASN(0.00)[asn:25795, ipnet:174.136.96.0/20, country:US]; RCVD_COUNT_TWO(0.00)[2]; RCVD_TLS_ALL(0.00)[]; RECEIVED_SPAMHAUS_PBL(0.00)[23.243.161.111:received] X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.33 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 26 Jun 2020 23:23:55 -0000 On 6/26/20 3:52 PM, Donald Wilde wrote: > On 6/26/20, Christoph Moench-Tegeder wrote: >> ## Donald Wilde (dwilde1@gmail.com): >> >>> I ran into an issue, documented in the attachments, that seems to >>> point to some quantity that does not include version 8 of the port, >>> only 1 - 7. Being a tidy soul, I used make clean first and that >>> resulted in a rebuild of LLVM90 as well. >> This report misses some vital information - e.g. what version of >> FreeBSD this is (and I'm only guessing this is on amd64), which >> would give some clue what the base compiler is. The attachments >> are somewhat incomplete, too - did you even have a look at >> llvm90_makeinstall.txt? Especially the configure output from >> PostgreSQL could have been helpful. > Christoph, please bear with me. It's been long enough since I worked > with FreeBSD that I don't even know what "vital information" I'm not > giving you. I'm peddling as fast as I can, and loving every minute, > but I'm not "there" yet. out of curiosity is there a reason why you are building locally versus using the pre-built binary packages?  I use the prebuilt postgresql binaries for development and production systems, so unless their is an option missing in the default pkg I'd highly recommend going that route. (look for all postgresql11 pkgs available) $ pkg search postgresql11 (install psql server for example) $ pkg install postgresql11-server cheers, -pete -- Pete Wright pete@nomadlogic.org @nomadlogicLA