From owner-freebsd-questions@freebsd.org Tue Dec 6 17:30:52 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 12449C6999E for ; Tue, 6 Dec 2016 17:30:52 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from smtp.infracaninophile.co.uk (smtp.infracaninophile.co.uk [IPv6:2001:8b0:151:1:c4ea:bd49:619b:6cb3]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 9CD0F11B for ; Tue, 6 Dec 2016 17:30:51 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from zero-gravitas.local (unknown [192.168.100.8]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: m.seaman@infracaninophile.co.uk) by smtp.infracaninophile.co.uk (Postfix) with ESMTPSA id 88F4B3F21 for ; Tue, 6 Dec 2016 17:30:47 +0000 (UTC) Authentication-Results: smtp.infracaninophile.co.uk; dmarc=none header.from=FreeBSD.org Authentication-Results: smtp.infracaninophile.co.uk/88F4B3F21; dkim=none; dkim-atps=neutral Subject: Re: Pkg artefacts To: freebsd-questions@freebsd.org References: <9b0c2c966e0d071e3419fee21dd23d0f.squirrel@webmail.harte-lyne.ca> From: Matthew Seaman Message-ID: <626b6aa7-d1db-2b73-4280-3c41aeb3c86a@FreeBSD.org> Date: Tue, 6 Dec 2016 17:30:41 +0000 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:45.0) Gecko/20100101 Thunderbird/45.5.0 MIME-Version: 1.0 In-Reply-To: <9b0c2c966e0d071e3419fee21dd23d0f.squirrel@webmail.harte-lyne.ca> Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="aK6ONbMENk9q2L2TjBfaqW4SRlRidIWcd" X-Spam-Status: No, score=-2.9 required=5.0 tests=ALL_TRUSTED,BAYES_00 autolearn=ham autolearn_force=no version=3.4.1 X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on smtp.infracaninophile.co.uk 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:30:52 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --aK6ONbMENk9q2L2TjBfaqW4SRlRidIWcd Content-Type: multipart/mixed; boundary="njexxwQf1x0Q0O2UlFQ5xBsThboFLwbcR"; protected-headers="v1" From: Matthew Seaman To: freebsd-questions@freebsd.org Message-ID: <626b6aa7-d1db-2b73-4280-3c41aeb3c86a@FreeBSD.org> Subject: Re: Pkg artefacts References: <9b0c2c966e0d071e3419fee21dd23d0f.squirrel@webmail.harte-lyne.ca> In-Reply-To: <9b0c2c966e0d071e3419fee21dd23d0f.squirrel@webmail.harte-lyne.ca> --njexxwQf1x0Q0O2UlFQ5xBsThboFLwbcR Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On 2016/12/06 17:20, James B. Byrne via freebsd-questions wrote: > We find this on a FreeBSD-11p0 system: >=20 > ll /usr/local/pgsql > total 17 > drwx------ 19 pgsql pgsql 25 Nov 24 12:52 data >=20 >=20 > ll /var/lib/pgsql > total 17 > drwx------ 19 postgres postgres 27 Dec 1 12:44 9.6 >=20 > 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? >=20 You previously had a version of postgresql earler than 9.6 installed. These older versions use the userid 'pgsql' and the default location for the data store is /usr/local/pgsql/data With postgresql 9.6 that changed. The userid is now 'postgres' and the datastore location should be /var/db/postgres/data96 See the 20160905 entry in UPDATING If you've got a postgresql data area as /var/lib/pgsql/9.6, you must have configured that locally. (Looks like a too-strict copy of the usual Linux layout, perhaps.) This is most likely to contain a more recent copy of your databases. Check /etc/rc.conf -- most of these settings can be overridden in the database startup Cheers, Matthew --njexxwQf1x0Q0O2UlFQ5xBsThboFLwbcR-- --aK6ONbMENk9q2L2TjBfaqW4SRlRidIWcd Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Comment: GPGTools - https://gpgtools.org iQJ8BAEBCgBmBQJYRvXHXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQxOUYxNTRFQ0JGMTEyRTUwNTQ0RTNGMzAw MDUxM0YxMEUwQTlFNEU3AAoJEABRPxDgqeTn5KcP/0H52VprgukC4Pl7ZMm9fgIj VGmihc7YlOjJw2cfye73AlO3n5PW02TKzBSzP7leLsf8Sc7Fwe4iQmNchUTLLxIO kStVEtWFbhKmyWVZ2zRFL6SJLCBx/CG7lMmpT7ivxeAdOsxIbuHljfengFtPdTXI iXD/Sgm7mE2E84SLrWaYbIMkMExOMt2bMAiHLLtrA0kqiathRtgUC8IBgrnHLQeH exUQmhcZxovGAer+C0g3CgXghyHAPM7dGwyNfB6iCnRBtKmSyyK4aHPj5pcHlLx0 kIo/kRxo8xlVi4kncfQxu9Xe/aHiZalSElLaltm92f9IPEnzcEPlI1sk9xx9gSyR z9j6dmPyvQU+sqSq70NGjyIPJWyfbXuSiKknC2iyqzo0Gzs0W14E1WzjA5bFlhql uAGRfJ/Qxj6mQA/YC/eS6/TBh32ieRXjYB3vj1vj3gW0qaxjNQeQan2in5ZIUXao nLEkDa6A1YVZNTBM3/gIsiJT15qgXT1oCsnx92PKy8kUln8jo6OUazlam63tUK8+ 1deyWbAG+44rpJ91LcchrEQmt1xaG74/2rJuOBxJf3gPIggxIf8AsWnr9IFg+j5c fepQOfIcJMR5waZV6jqY+rmBSgnoNy20BophyRRoLYJ7RDkyOOuQhxL8EaPmfWQN owFlsWoBUInq/AHBlJT4 =Dfmj -----END PGP SIGNATURE----- --aK6ONbMENk9q2L2TjBfaqW4SRlRidIWcd--