From owner-freebsd-questions@freebsd.org Tue Dec 6 17:20:16 2016 Return-Path: Delivered-To: freebsd-questions@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 946AAC69514 for ; Tue, 6 Dec 2016 17:20:16 +0000 (UTC) (envelope-from byrnejb@harte-lyne.ca) Received: from inet08.hamilton.harte-lyne.ca (inet08.hamilton.harte-lyne.ca [216.185.71.28]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "inet08.hamilton.harte-lyne.ca", Issuer "CA HLL ISSUER 01" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 682CA18C9 for ; Tue, 6 Dec 2016 17:20:16 +0000 (UTC) (envelope-from byrnejb@harte-lyne.ca) Received: from localhost (localhost [127.0.0.1]) by inet08.hamilton.harte-lyne.ca (Postfix) with ESMTP id AC633621F8 for ; Tue, 6 Dec 2016 12:20:08 -0500 (EST) X-Virus-Scanned: amavisd-new at harte-lyne.ca Received: from inet08.hamilton.harte-lyne.ca ([127.0.0.1]) by localhost (inet08.hamilton.harte-lyne.ca [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id IinuNjXa2vAr for ; Tue, 6 Dec 2016 12:20:07 -0500 (EST) Received: from webmail.harte-lyne.ca (inet04.hamilton.harte-lyne.ca [216.185.71.24]) (using TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by inet08.hamilton.harte-lyne.ca (Postfix) with ESMTPSA id 305846218A for ; Tue, 6 Dec 2016 12:20:07 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=harte-lyne.ca; s=dkim_hll; t=1481044807; bh=kr7sM/Gn277schrBGd7/ENqxGqcof6GiD6fiPV1STGw=; h=Date:Subject:From:To:Reply-To; b=Gl6AgevsDtb27Av7FO/KAtL4qThD5nyLPD5sDhZD7OT4ckPGyYAJcJRroMDGhdIb2 ykvtXMuP0XXwXRFMxwKHGzNyKq7V2ajyRld2tk8Zfn6FPUVk8R96XVdZ9kKEJqB0IF y9DuhKR0s1o1yoa9RvsmdQKCJqPZcdRxm+NpjC0seI77d59dfFin/ILzYbbyjOys2B etvCdEBLxuoiJev6wABwhisk4om3SbXY6hWkoB7maDXPrwnrkEem7YUSL/5+Kn00uc kmm+z8CvA3F8ii1NcV/+84nVjGEABxEdegC+xsEjABd62olIEu1sxNa/IyN3VOe+9S 7YvWQlKc2vNPw== Received: from 216.185.71.44 (SquirrelMail authenticated user byrnejb_hll) by webmail.harte-lyne.ca with HTTP; Tue, 6 Dec 2016 12:20:07 -0500 Message-ID: <9b0c2c966e0d071e3419fee21dd23d0f.squirrel@webmail.harte-lyne.ca> Date: Tue, 6 Dec 2016 12:20:07 -0500 Subject: Pkg artefacts From: "James B. Byrne" To: freebsd-questions@freebsd.org Reply-To: byrnejb@harte-lyne.ca User-Agent: SquirrelMail/1.4.22-4.el6 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 06 Dec 2016 17:20:16 -0000 We find this on a FreeBSD-11p0 system: ll /usr/local/pgsql total 17 drwx------ 19 pgsql pgsql 25 Nov 24 12:52 data ll /var/lib/pgsql total 17 drwx------ 19 postgres postgres 27 Dec 1 12:44 9.6 Checking the contents of both directories reveals a remarkable congruence. So, why do two virtually identical directory trees, albeit with different owners, exist on this system? We use pkg to manage software applications. And this is what pkg reveals. pkg info postgresql\* postgresql96-client-9.6.0 postgresql96-contrib-9.6.0 postgresql96-docs-9.6.0_1 postgresql96-server-9.6.0_1 pkg info postgresql96-server postgresql96-server-9.6.0_1 Name : postgresql96-server Version : 9.6.0_1 Installed on : Wed Nov 30 10:36:03 2016 EST Origin : databases/postgresql96-server Architecture : freebsd:11:x86:64 Prefix : /usr/local Categories : databases Licenses : Maintainer : pgsql@FreeBSD.org Which directory is the correct one for our installed version of the server? I am guessing /usr/local/pgsql. On this server when we upgraded from FreeBSD-10 to 11 we also ran portsnap update to complete the upgrade process. But that does not tell me how we ended up with two version of the postgresql data structure. Any ideas out there? -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Do NOT open attachments nor follow links sent by e-Mail James B. Byrne mailto:ByrneJB@Harte-Lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3