NovaStar Program Reference / Database / nsdbserver
Overview
The nsdbserver program (script) performs system administration tasks for a NovaStar database.
An interactive text menu is shown, which displays useful information and
lists commands that can be run.
nsdbserver Menu (see also the full-size image)
Command Line Usage
The command line syntax is:
nsdbserver [parameters...]
Command line parameters are as follows.
nsdbserver Command Line Parameters
| Parameter | Description | Default |
|---|---|---|
-d |
Turn debug on. | |
-h |
Print the usage. | |
-i |
Run interactively because batch operations are not enabled. | This is the default run mode. |
-v |
Print the version. |
The following table describes nsdbserver menu commands.
nsdbserver Commands
| Command | Description |
|---|---|
| =========== | General commands |
d |
Toggle debug mode on/off. |
q (Quit) |
Exit the program. |
| =========== | Information commands |
lsbak |
List database backups (to restore). |
lsconf [dbname] |
List NovaStar configuration table. |
lsdb |
List PostgreSQL databases. |
lssessions [dbname] |
List PostgreSQL sessions used by programs. |
| =========== | Database administration commands |
newdb |
Create a new empty novastar database (needed for restore). |
restoredb |
Restore a NovaStar database from backup (.bak). |
renamedb |
Rename an existing database. |
dropdb |
Drop (delete) a database. |
reloadpg |
Reload PostgreSQL server configuration. |
restartpg |
Restart PostgreSQL server. |
id |
Set system identifier system_id in configuration table. |
Examples
Scheduling
In the future, batch commands may be added to nsdbserver and may be run on a schedule.
NovaStar Administrator Interface
Currently the Administrator does not edit any nsdbserver configuration properties.
Troubleshooting
Log files are written to the /var/log/nsdbserver folder.