Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

Databases - Practical PostgreSQL
Previous Page Home Next Page

Initializing a Secondary Database Location

If you are not interested in creating a new database cluster, but simply wish to store a particular database in a different data directory, use initlocation . The initlocation program creates the directories needed for a secondary database storage area. For more information on how to create a database in a secondary data storage area, refer to the Section called Creating and Removing a Database " later in this chapter. Here is the syntax for initlocation :

  initlocation 
directory

In this syntax, directory is the path for the new secondary database location. This command should be run as the user which runs the postmaster , so that it will have the necessary rights in the created path.

Example 9-8 demonstrates how to initialize a secondary database storage area in the /usr/local/pgsql/booktown2 directory:

Example 9-8. Initializing a Secondary Database Location

[postgres@booktown ~]$ 
initlocation /usr/local/pgsql/booktown2

Databases - Practical PostgreSQL
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire