Pkg artefacts

Amitabh Kant amitabhkant at gmail.com
Thu Dec 8 17:05:50 UTC 2016


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 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
>
>         Cheers,
>
>         Matthew
>
>
>
>


More information about the freebsd-questions mailing list