matthew at FreeBSD.org
Tue Dec 6 17:30:52 UTC 2016
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
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 972 bytes
Desc: OpenPGP digital signature
More information about the freebsd-questions