redhat man page for initlocation

Query: initlocation

OS: redhat

Section: 1

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

INITLOCATION(1) 					  PostgreSQL Server Applications					   INITLOCATION(1)

NAME
initlocation - create a secondary PostgreSQL database storage area
SYNOPSIS
initlocation directory
DESCRIPTION
initlocation creates a new PostgreSQL secondary database storage area. See the discussion under CREATE DATABASE [create_database(7)] about how to manage and use secondary storage areas. If the argument does not contain a slash and is not valid as a path, it is assumed to be an environment variable, which is referenced. See the examples at the end. In order to use this command you must be logged in (using su, for example) as the database superuser.
EXAMPLES
To create a database in an alternate location, using an environment variable: $ export PGDATA2=/opt/postgres/data Stop and start postmaster so it sees the PGDATA2 environment variable. The system must be configured so the postmaster sees PGDATA2 every time it starts. Finally: $ initlocation PGDATA2 $ createdb -D PGDATA2 testdb Alternatively, if you allow absolute paths you could write: $ initlocation /opt/postgres/data $ createdb -D /opt/postgres/data/testdb testdb
SEE ALSO
PostgreSQL Administrator's Guide Application 2002-11-22 INITLOCATION(1)
Related Man Pages
createuser(1) - redhat
drop_database(7) - centos
dropdb(1) - redhat
alter_database(7) - suse
createdb(1) - osx
Similar Topics in the Unix Linux Community
Make all words begin with capital letter?
CentOS7 restoring file capabilities
Issue with "rsh" on RedHat
[TIP] Processing YAML files with yq