May 2018
Intermediate to advanced
576 pages
30h 25m
English
On Debian or Ubuntu systems, the default data directory location is: /var/lib/postgresql/R.r/main.
Here, R.r represents the major and minor release numbers of the database server software, respectively; for example, 9.6. The configuration files are located in /etc/postgresql/R.r/main/.
Note that for release 10 onwards, it will just be 10, not 10.0.
In both cases, main is just the name of a database server. Other names are also possible. For the sake of simplicity, we assume that you only have a single installation, although the point of including the release number and database server name as components of the directory path is to allow multiple database servers to coexist on the same host.