initlocation man page on BSDOS

Man page or keyword search:  
man Server   6284 pages
apropos Keyword Search (all sections)
Output format
BSDOS logo
[printable version]

INITLOCATION(1)		PostgreSQL Server Applications	       INITLOCATION(1)

NAME
       initlocation - Create a secondary Postgres database storage 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
       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

Application			  2000-11-11		       INITLOCATION(1)
[top]
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server BSDOS

List of man pages available for BSDOS

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net