Date: Thu, 8 Dec 2016 22:35:28 +0530 From: Amitabh Kant <amitabhkant@gmail.com> To: Matthew Seaman <matthew@freebsd.org> Cc: "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org> Subject: Re: Pkg artefacts Message-ID: <CAPTAQBLvHurBefsJrPRw1UEjy7oj79U-brp8uYJtn5oWVzgHLw@mail.gmail.com> In-Reply-To: <626b6aa7-d1db-2b73-4280-3c41aeb3c86a@FreeBSD.org> References: <9b0c2c966e0d071e3419fee21dd23d0f.squirrel@webmail.harte-lyne.ca> <626b6aa7-d1db-2b73-4280-3c41aeb3c86a@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
Mathew Does this mean that installing through ports/packages will now support multiple versions of postgresql (post 9.6) with different data directories? If yes, this removes a lot of pain for using pg_upgrade. Amitabh On Tue, Dec 6, 2016 at 11:00 PM, Matthew Seaman <matthew@freebsd.org> wrote: > On 2016/12/06 17:20, James B. Byrne via freebsd-questions wrote: > > 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? > > > > 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 > > > >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAPTAQBLvHurBefsJrPRw1UEjy7oj79U-brp8uYJtn5oWVzgHLw>