LightDB Client Applications
This part contains reference information for
LightDB client applications and
utilities. Not all of these commands are of general utility; some
might require special privileges. The common feature of these
applications is that they can be run on any host, independent of
where the database server resides.
When specified on the command line, user and database names have
their case preserved — the presence of spaces or special
characters might require quoting. Table names and other identifiers
do not have their case preserved, except where documented, and
might require quoting.
Table of Contents
- clusterdb — cluster a LightDB database
- createdb — create a new LightDB database
- createuser — define a new LightDB user account
- dropdb — remove a LightDB database
- dropuser — remove a LightDB user account
- ecpg — embedded SQL C preprocessor
- ltbench — run a benchmark test on LightDB
- ltcenter — ltcenter is a command-line admin tool for observing and troubleshooting LightDB
- ltdts_recvlogical — is forked from lt_recvlogical, so it has most all behavior that in lt_recvlogical, such as control LightDB logical decoding streams. After that, it use wal2sql plugin transform the change from LightDB to Oracle database, and future will support Redis, Kafka, LightDB-A and so on.
- lt_basebackup — take a base backup of a LightDB cluster
- lt_config — retrieve information about the installed version of LightDB
- lt_dump —
extract a LightDB database into a script file or other archive file
- lt_dumpall — extract a LightDB database cluster into a script file
- lt_isready — check the connection status of a LightDB server
- lt_receivewal — stream write-ahead logs from a LightDB server
- lt_recvlogical — control LightDB logical decoding streams
- lt_restore —
restore a LightDB database from an
archive file created by lt_dump
- lt_verifybackup — verify the integrity of a base backup of a
LightDB cluster
- ltsql —
LightDB interactive terminal
- reindexdb — reindex a LightDB database
- vacuumdb — garbage-collect and analyze a LightDB database
- executor — use to execute grouped sql file in parallel
- lightdb_service.py — start/stop/restart a LightDB service