From: | "Charles Clavadetscher" <clavadetscher(at)swisspug(dot)org> |
---|---|
To: | "'Postgres General'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Why are data files stored in /var/lib |
Date: | 2016-04-30 03:30:09 |
Message-ID: | 013201d1a290$9e2acb10$da806130$@swisspug.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
I use version 9.5 on Linux Mint 17.3.
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. I am aware that the location can be modified to suit the needs of sysadmins as
described under these links.
http://www.postgresql.org/docs/current/static/storage-file-layout.html
http://www.postgresql.org/docs/current/static/runtime-config-file-locations.html
In the first link there is a line stating that "A common location for PGDATA is /var/lib/pgsql/data". My question is if there is a
specific reason for choosing /var/lib as the default for database file locations, some kind of best practices or alike. I assume
that there have been discussions on the topic?
Thank you and enjoy the weekend.
Charles
From | Date | Subject | |
---|---|---|---|
Next Message | Manuel Gómez | 2016-04-30 03:45:06 | Re: Why are data files stored in /var/lib |
Previous Message | Thomas Munro | 2016-04-30 02:16:48 | Re: How to manually force a transaction wraparound |