Re: Why are data files stored in /var/lib

From: Rafal Pietrak <rafal(at)ztk-rp(dot)eu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Why are data files stored in /var/lib
Date: 2016-04-30 13:32:07
Message-ID: 5724B3D7.3070102@ztk-rp.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

W dniu 30.04.2016 o 05:45, Manuel Gómez pisze:
> On Fri, Apr 29, 2016 at 11:00 PM, Charles Clavadetscher
> <clavadetscher(at)swisspug(dot)org> wrote:
>> I had a discussion yesterday with some friends, who are sysadmins about the location of database files. In a default installation
>> from a distribution (apt-get install) PostgreSQL creates a cluster unter /var/lib/. According to my colleagues /var/lib should not
>> contain data that is supposed to last over time.
>
> Your sysadmin friends should read the excellent
> http://www.pathname.com/fhs/pub/fhs-2.3.html#VARLIBVARIABLESTATEINFORMATION

I always wandered why /SRV isn't used for that (see:
http://www.pathname.com/fhs/pub/fhs-2.3.html#SRVDATAFORSERVICESPROVIDEDBYSYSTEM)

Personally, (irrespectively of the package/distribution defaults) I
always put my databases in /srv/pgdat - upgrades that disrupt such
initial override are seldom.

-R

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Mcdowell 2016-04-30 14:40:34 Vacuum of large tables causing replication delays to hot standby
Previous Message John R Pierce 2016-04-30 07:59:01 Re: Why are data files stored in /var/lib