Pkg artefacts

Matthew Seaman matthew at
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
database startup



-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 972 bytes
Desc: OpenPGP digital signature
URL: <>

More information about the freebsd-questions mailing list