This page in other versions: Unsupported versions: 6.4 / 6.5 / 7.0



initlocation — Create a secondary Postgres database storage area
initlocation directory



Where in your Unix filesystem do you want alternate databases to go?


initlocation will create directories in the specified place.


initlocation creates a new Postgres secondary database storage area. See the discussion under CREATE DATABASE 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) the database superuser.


To create a database in an alternate location, using an environment variable:

$ export PGDATA2=/opt/postgres/data
$ initlocation PGDATA2
$ createdb 'testdb' -D 'PGDATA2'

Alternatively, if you allow absolute paths you could write:

$ initlocation /opt/postgres/data
$ createdb testdb -D '/opt/postgres/data/testdb'

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group