add new database server
Syntax
v-add-database-host TYPE HOST DBUSER DBPASS [MAX_DB] [CHARSETS] [TEMPLATE]
Options
Parameters | Parameters Description |
---|---|
TYPE | Type of database server on the host, available options are: mysql or pgsql |
HOST | Hostname or IP of the server |
DBUSER | User allowed to create/change/delete databases, users (very often root) |
DBPASS | Password for above user |
[MAX_DB] | [OPTIONAL] Maximum number of databases the server will have |
[CHARSETS] | [OPTIONAL] Default characterset used when creating databases, default value = "UTF8" |
[TEMPLATE] | [OPTIONAL] only used when TYPE is PostgreSQL, default value = "template1" |
Examples
Notes
The function add new database server to the server pool. It supports local and remote database servers, which is useful for clusters. By adding a host you can set limit for number of databases on a host. Template parameter is used only for PostgreSQL and has an default value “template1”. You can read more about templates in official PostgreSQL documentation.
Related Commands
Links
GitHub
whe i try to install postgre database, following step by step in page https://vestacp.com/docs/#how-to-setup-postgresql-debian-ubuntu
i receved this message
v-add-database-host pgsql localhost postgres pgp4sw0rd
v-add-database-host: command not found
could you halp me please
regards