POST databases

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

Important

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/databases

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://: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"
}