Date: Tue, 6 Dec 2016 17:30:41 +0000 From: Matthew Seaman <matthew@FreeBSD.org> To: freebsd-questions@freebsd.org Subject: Re: Pkg artefacts Message-ID: <626b6aa7-d1db-2b73-4280-3c41aeb3c86a@FreeBSD.org> In-Reply-To: <9b0c2c966e0d071e3419fee21dd23d0f.squirrel@webmail.harte-lyne.ca> References: <9b0c2c966e0d071e3419fee21dd23d0f.squirrel@webmail.harte-lyne.ca>
next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --aK6ONbMENk9q2L2TjBfaqW4SRlRidIWcd Content-Type: multipart/mixed; boundary="njexxwQf1x0Q0O2UlFQ5xBsThboFLwbcR"; protected-headers="v1" From: Matthew Seaman <matthew@FreeBSD.org> 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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?626b6aa7-d1db-2b73-4280-3c41aeb3c86a>