MANAGE_INDICES

NAME
SYNOPSIS
DESCRIPTION
OPTIONS
RETURN VALUES
AUTHORS

NAME

manage_indices − A tool to manage indices on Emdros databases

SYNOPSIS

manage_indices --create [options] database-name
manage_indices
--drop [options] database-name
manage_indices
--help
manage_indices
(-V|--version)

DESCRIPTION

manage_indices is a tool for creating and dropping indices on an Emdros database’s object types. If the option "--type object-type-name" is given, only that object type is affected. If this option is not given, all object types in the database are affected.

OPTIONS

manage_indices supports the following command-line switches:
−−help

show help

−V , −−version

show version

−−create

indices are created

−−drop

indices are dropped

−b , −−backend backend

set database backend to ‘backend’. Valid values are: For PostgreSQL: "p", "pg", "postgres", and "postgresql". For MySQL: "m", "my", and "mysql". For SQLite 2.X.X: "2", "s", "l", "lt", "sqlite", and "sqlite2". For SQLite 3.X.X: "3", "s3", "lt3", and "sqlite3". −t , −−type object-type-name only the object type object-type-name is affected

−h , −−host hostname

set db back-end hostname to connect to (default is ’localhost’). Has no effect on SQLite.

−u , −−user user

set database user to connect as (default is ’emdf’). Has no effect on SQLite.

−p , −−password password

set password to use for the database user. Has no effect on SQLite, unless you have an encryption-enabled SQLite, in which case this gets passed as the key.

RETURN VALUES

0 Success
1
Wrong usage
2
Connection to backend server could not be established
3
An exception occurred (the type is printed on stderr)
5
Database error

AUTHORS

Written Ulrik Sandborg-Petersen (ulrikp@emdros.org).