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/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=vertica&name=testDB &catalog=%2Fhome%2Fdbadmin%2FtestDB &data=%2Fhome%2Fdbadmin%2FtestDB |
Response:
{ "jobid": "CreateDatabase-testDB-2014-07-07 15:49:53.219445", "resource": "/jobs/CreateDatabase-testDB-2014-07-07 15:49:53.219445", "userid": "dbadmin" }