amitabhkant at gmail.com
Thu Dec 8 17:05:50 UTC 2016
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.
On Tue, Dec 6, 2016 at 11:00 PM, Matthew Seaman <matthew at 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
More information about the freebsd-questions