POST databases

Creates a job to create a new database with the provided parameters.

You must stop any running databases on the nodes on which you want to create the new database. If you do not, database creation fails.

Returns a job ID that can be used to determine the status of the job. See GET jobs.

Resource URL

https://<NODE>:5444/database

Authentication

Requires a VerticaAPIKey in the request header.

The API key must have admin level security.

Parameters

name
 Name of the database to create. 
passwd
 Password for the new database. 
only
 Optional list of hostnames to include in the database. By default, all nodes in the cluster are added to the database. 
exclude
 Optional list of hostnames to exclude from the database. 
catalog
 Path of the catalog directory. 
data
 Path of the data directory. 
port
 Port where the database listens for client connections. Default is 5433.

Example Request

POST 
https://<NODE>:5444/databases?passwd=db_password&name=db_name&
catalog=%2Fpath%2Fto%2Fcatalog&data=%2Fpath%2Fto%2Fdata_directory

Response: 

{
    "jobid": "CreateDatabase-testDB-2014-07-07 15:49:53.219445",
    "resource": "/jobs/CreateDatabase-testDB-2014-07-07 15:49:53.219445",
    "userid": "dbadmin"
}