April 2015
Intermediate to advanced
504 pages
11h 41m
English
Database server files are initially stored in a location referred to as the data directory. Additional data files may also be stored in tablespaces, if any exist.
In this recipe, you will learn how to find the location of these directories on a given database server.
You'll need to get an operating system access to the database system, which is what we call the platform on which the database runs.
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.4. The configuration files are located at /etc/postgresql/R.r/main/.
In both cases, ...