whisper-create(1) [debian man page]

WHISPER-CREATE(1)					      General Commands Manual						 WHISPER-CREATE(1)

NAME

       whisper-create - create a whisper database

SYNOPSYS

       whisper-create path secondsPerPoint:pointsToStore [secondsPerPoint:pointsToStore]*

DESCRIPTION

       This  command  creates  a  new  whisper fixed-size database. For each database you specify one or more pairs of numbers describing how data
       points should be archived in this database. The first part of the pair is the precision, the second part of  the  pair  is  how	many  data
       points should be stored. You cannot configure two archives with the same precision inside a single database. Higher precision archives must
       evenly divide all lower precision archives' precision.

       The options are described below.

OPTIONS

       --overwrite
	      Overwrite an existing database.

       --xFilesFactor
	      The fraction of data points in a propagation interval that must have known values for a propagation to occur.

       -h, --help
	      Show the embedded help.

AUTHOR

       whisper is a fixed size database, created by Chris Davis.

       This manual page was written by Elliot Murphy <elliot@ubuntu.com>, for the Debian project (but may be used by others).

																 WHISPER-CREATE(1)

CREATE 
TABLESPACE(7)						   SQL Commands 					      CREATE TABLESPACE(7)

NAME

       CREATE TABLESPACE - define a new tablespace

SYNOPSIS

       CREATE TABLESPACE tablespacename [ OWNER username ] LOCATION 'directory'

DESCRIPTION

       CREATE TABLESPACE registers a new cluster-wide tablespace. The tablespace name must be distinct from the name of any existing tablespace in
       the database cluster.

       A tablespace allows superusers to define an alternative location on the file system where the data files containing database objects  (such
       as tables and indexes) can reside.

       A  user	with  appropriate  privileges can pass tablespacename to CREATE DATABASE, CREATE TABLE, CREATE INDEX or ADD CONSTRAINT to have the
       data files for these objects stored within the specified tablespace.

PARAMETERS

       tablespacename
	      The name of a tablespace to be created. The name cannot begin with pg_, as such names are reserved for system tablespaces.

       username
	      The name of the user who will own the tablespace. If omitted, defaults to the user executing the command. Only superusers can create
	      tablespaces, but they can assign ownership of tablespaces to non-superusers.

       directory
	      The directory that will be used for the tablespace. The directory must be empty and must be owned by the PostgreSQL system user. The
	      directory must be specified by an absolute path name.

NOTES

       Tablespaces are only supported on systems that support symbolic links.

       CREATE TABLESPACE cannot be executed inside a transaction block.

EXAMPLES

       Create a tablespace dbspace at /data/dbs:

       CREATE TABLESPACE dbspace LOCATION '/data/dbs';

       Create a tablespace indexspace at /data/indexes owned by user genevieve:

       CREATE TABLESPACE indexspace OWNER genevieve LOCATION '/data/indexes';

COMPATIBILITY

       CREATE TABLESPACE is a PostgreSQL extension.

SEE ALSO

       CREATE DATABASE [create_database(7)], CREATE TABLE [create_table(7)], CREATE INDEX [create_index(7)], DROP TABLESPACE [drop_tablespace(7)],
       ALTER TABLESPACE [alter_tablespace(7)]

SQL - Language Statements					    2010-05-14						      CREATE TABLESPACE(7)