v2.0
- About PTK
- Quick Start
- Guidance
- Preparing Configuration File
- Checking the System
- Deploy Database Cluster
- Manage Clusters
- Show Cluster List
- Show Cluster Status
- Start Database
- Stop Database
- Restart Database
- Rebuild Database
- Switchover
- Failover
- Show Plugin Information
- Install Plugins
- Upgrade Database
- Scale-out Cluster
- Scale-in Cluster
- Show Database HBA
- Set Database HBA
- Show Database Parameters
- Set Database Parameters
- Show Cluster Topology Configuration
- Show Cluster Meta Information
- Update Cluster Comment
- Update Database IP
- Role Management
- Install CM
- Uninstall CM
- Manage Cluster VIP
- Install MogHA Service
- Uninstall MogHA Service
- Rename Cluster
- Create Empty Cluster
- Throw Out A Node
- Takeover A Node
- Manage Cluster
- Uninstall Database Cluster
- Collect OS Information
- Download MogDB Installer
- Encrypt Sensitive Information
- Upgrade PTK
- PTKC
- Compatible With Higher Versions of MogDB
- Reference
- Samples of Configuration Files
- Commands
- ptk
- ptk completion
- ptk view-static-config
- ptk init-cluster
- ptk collect
- ptk rec-guc
- ptk cache
- ptk gen-ptkc
- ptk manage
- ptk demo
- ptk meta
- ptk version
- ptk self
- ptk gen-om-xml
- ptk env
- ptk gen-static-config
- ptk cluster
- ptk cluster createdb
- ptk cluster uninstall-compat-tools
- ptk cluster install-compat-tools
- ptk cluster install-mogila
- ptk cluster rename
- ptk cluster throwout
- ptk cluster takeover
- ptk cluster uninstall-cm
- ptk cluster install-cm
- ptk cluster gen-cert-files
- ptk cluster load-cm-vip
- ptk cluster del-kerberos-auth
- ptk cluster add-kerberos-auth
- ptk cluster uninstall-kerberos-server
- ptk cluster install-kerberos-server
- ptk cluster is-in-upgrade
- ptk cluster upgrade-rollback
- ptk cluster upgrade-commit
- ptk cluster upgrade
- ptk cluster demote
- ptk cluster promote
- ptk cluster refresh
- ptk cluster shell
- ptk cluster modify-comment
- ptk cluster show-config
- ptk cluster set-guc
- ptk cluster show-guc
- ptk cluster set-hba
- ptk cluster show-hba
- ptk cluster scale-out
- ptk cluster scale-in
- ptk cluster uninstall-mogha
- ptk cluster install-mogha
- ptk cluster list-plugins
- ptk cluster install-plugin
- ptk cluster inspect
- ptk cluster failover
- ptk cluster switchover
- ptk cluster build
- ptk cluster status
- ptk cluster restart
- ptk cluster stop
- ptk cluster start
- ptk uninstall
- ptk ls
- ptk install
- ptk exec
- ptk template
- ptk encrypt
- ptk checkos
- ptk download
- ptk candidate
- Troubleshooting
- FAQ
- Release Notes
- Community
- Appendix: YAML Syntax
ptk cluster createdb
Create Database
Syntax
ptk cluster createdb [flags]
Example
# Create Database
ptk cluster -n <CLUSTER_NAME> createdb --dbname <DBNAME>
[--owner <OWNER>] [--encoding <ENCODING>] [--lc-collate <LC_COLLATE>]
[--lc-type <LC_CTYPE>] [--compatibility <DBCOMPATIBILITY>]
[--tablespace <TABLESPACE>] [--connlimit <LIMIT>]
Option
--compatibility string
- Description: Database compatibility
- Data type: string
- Default value: "A"
--connlimit int
- Description: CONNECTION LIMIT of database
- Data type: int
- Default value: 0
--dbname string
- Description: Database name
- Data type: string
- Default value: ""
--encoding string
- Description: ENCODING of database
- Data type: string
- Default value: ""
--lc-collate string
- Description: LC_COLLATE of database
- Data type: string
- Default value: ""
--lc-type string
- Description: LC_TYPE of database
- Data type: string
- Default value: ""
--owner string
- Description: OWNER of database
- Data type: string
- Default value: ""
--tablespace string
- Description: TABLESPACE of database
- Data type: string
- Default value: ""
Option Inherited from the Parent Command
--disable-color
- Description: Disable color logging
- Data type: bool
- Default value: false
--disable-debug-log
- Description: Do not generate debug log files
- Data type: bool
- Default value: false
--disable-progressbar
- Description: Progress bar not shown globally
- Data type: bool
- Default value: false
-h, --help
- Description: Print help information
- Data type: bool
- Default value: false
--log-file string
- Description: Specify the path to the runlog file
- Data type: string
- Default value: ""
--log-format string
- Description: Specify the output format of the runlog, options: [text, json].
- Data type: string
- Default value: "text"
--log-level string
- Description: Specify the runtime log level, options: [debug, info, warning, error, panic].
- Data type: string
- Default value: "info"
-n, --name string
- Description: Cluster name
- Data type: string
- Default value: ""
--silence
- Description: Does not print logs to standard output
- Data type: bool
- Default value: false
--skip-fix-ssh
- Description: No need to repair ssh connections interactively
- Data type: bool
- Default value: false
Added Version
v1.7
More Command
- ptk cluster - Manage cluster