Penguin
Recent Changes
Blame: initlocation(1)
EditPageHistoryDiffInfoLikePages
Annotated edit history of initlocation(1) version 1, including all changes. View license author blame.
Rev Author # Line
1 perry 1 INITLOCATION
2 !!!INITLOCATION
3 NAME
4 SYNOPSIS
5 DESCRIPTION
6 USAGE
7 ----
8 !!NAME
9
10
11 initlocation - create a secondary PostgreSQL database storage area
12 !!SYNOPSIS
13
14
15 __initlocation__ ''directory''
16 !!DESCRIPTION
17
18
19 __initlocation__ creates a new PostgreSQL secondary
20 database storage area. See the discussion under CREATE
21 DATABASE [[__create_database__(l)] about how to manage and
22 use secondary storage areas. If the argument does not
23 contain a slash and is not valid as a path, it is assumed to
24 be an environment variable, which is referenced. See the
25 examples at the end.
26
27
28 In order to use this command you must be logged in (using
29 __su__, for example) as the database
30 superuser.
31 !!USAGE
32
33
34 To create a database in an alternate location, using an
35 environment variable:
36
37
38 $ __export PGDATA2=/opt/postgres/data
39 __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:
40
41
42 $ __initlocation PGDATA2
43 __$ __createdb -D PGDATA2 testdb
44 __
45
46
47 Alternatively, if you allow absolute paths you could
48 write:
49
50
51 $ __initlocation /opt/postgres/data
52 __$ __createdb -D /opt/postgres/data/testdb testdb
53 __
54 ----
This page is a man page (or other imported legacy content). We are unable to automatically determine the license status of this page.