initlocation  - Create a secondary Postgres database stor­
       age area


SYNOPSIS

       initlocation directory


DESCRIPTION

       initlocation creates a  new  Postgres  secondary  database
       storage  area.   See  the discussion under CREATE DATABASE
       [create_database(l)] 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  envi­
       ronment 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.


USAGE

       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  environ­
       ment  variable. The system must be configured so the post­
       master 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


Man(1) output converted with man2html