Locating the database server files
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.
Getting ready
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.
How to do it…
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, ...
Get PostgreSQL 9 Administration Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
