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
- lt_createdb — creates 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
- executor — use to execute grouped sql file in parallel
- lightdb_service.py — start/stop/restart a LightDB service
- lt_distributed_probackup.py — backup and restore a LightDB distributed cluster
- lt_distributed_dump.py —
extract a distributed LightDB database into an directory include script file or other archive file
- lt_distributed_restore.py —
restore a LightDB database from an
archive file created by lt_distributed_dump.py
- 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.
- ltdts_ora — Ltdts_ora is used for synchronize data from Oracle to LightDB.
- ltdts_mysql — ltdts_mysql is used for synchronize data from MySQL|MariaDB to LightDB.
- ltldr —
Compatible with ORACLE， loads data from external files into tables of an LightDB database。
- ltuldr —
Compatible with ORACLE,
obtaining all information of a table from the LightDB database.
- 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_probackup — manage backup and recovery of LightDB database clusters
- 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
- ltbench — run a benchmark test on LightDB
- ltcenter — ltcenter is a command-line admin tool for observing and troubleshooting LightDB
- ltsql —
LightDB interactive terminal
- reindexdb — reindex a LightDB database
- vacuumdb — garbage-collect and analyze a LightDB database