View Source: initlocation(1) - Waikato Linux Users Group

Edit PageHistory Diff Info LikePages

INITLOCATION
!!!INITLOCATION
NAME
SYNOPSIS
DESCRIPTION
USAGE
----
!!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__(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 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.
!!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__ 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
__
----

2 pages link to initlocation(1):

This page is a man page (or other imported legacy content). We are unable to automatically determine the license status of this page.

Last edited on Monday, June 3, 2002 6:50:22 pm by "perry"

Edit PageHistory Diff Info LikePages