Home Man
Search
Today's Posts
Register

Linux & Unix Commands - Search Man Pages

RedHat 9 (Linux i386) - man page for initlocation (redhat section 1)

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)


All times are GMT -4. The time now is 04:20 AM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
UNIX.COM Login
Username:
Password:  
Show Password