creatdb - Creating a new database

SYNOPSIS

creatdb [options] database


DESCRIPTION
The program creatdb creates a new database. It takes a path name as an argument, which will be the name of the created database. Creatdb will create the directory named in the last component of the path; all other components (parent dirs) must exist.

Creatdb also creates the required system tables. Once creatdb has been run then any of the other Texis commands such as the interactive SQL interpreter (tsql) can be used.

The database is created with two users, _SYSTEM and PUBLIC. Neither user will have a password initially, unless specified with the --system-password or --public-password options. The _SYSTEM user will have complete full rights on the database. Any rights granted to PUBLIC will be available to anyone. If you access the database without specifying a username the default is PUBLIC. You can add a password to both of these accounts to restrict access to the database.

In version 7.00.1368581000 20130514 and later, the following command-line options were added:

--install-dir=dir
Give alternate Texis install dir
--texis-conf=path
Give alternate texis.ini configuration file
--system-password password
Specify _SYSTEM user password. The default is empty (no password). Note that the password is visible on the command line, so the shell's command-line history should be erased afterwards for security.
--public-password password
Specify PUBLIC user password. The default is empty (no password). Note that the password is visible on the command line, so the shell's command-line history should be erased afterwards.
--createlocks-methods method[,method...] Specify the createlocks methods to use (overriding [Texis] Createlocks Methods) in texis.ini.
[-V] Increase Texis verbosity (same as tsql -V). May be given multiple times to increase verbosity further.
[-h
Print command-line help.

Previous versions did not have any options, and would create a database in the current directory if no database was specified.


EXAMPLE

creatdb /usr/local/morph3/texis/testdb


Copyright © Thunderstone Software     Last updated: Dec 10 2018
Copyright © 2019 Thunderstone Software LLC. All rights reserved.