NovaStar Program Reference / Database / Overview
Database programs perform core tasks related to the database.
- Backup and Restore - backup and restore database
- Database Control - start, stop, etc. PostgreSQL
- Database Checks - checks database
- Database Maintenance - database maintenance
- Database Recalculation - database recalculation (calibrations, ratings, etc.)
- Master/Backup/Slave Replication - database replication
- Utilities, General - general utilities
- Utilities, PostgreSQL - PostgreSQL utilities (commands)
Backup and Restore
- Backup Overview
nsdbbackup- create (dump) database backupnsdbrestore- restore (load) a database backup
Database Control
postgresql- start, stop, etc. PostgreSQL
Database Checks
nsdbcheck- checks for and optionally repairs database problems
Database Maintenance
nsdbcompress- compress the database to reduce disk use and increase performancensdbmaintenance- make sure that data partition tables existnsdbmerge- merge redundant point data reportsnsdbmergeall- TODO smalers 2017-10-14 need to documentnsdbupdatedatapartitiontrigger- update NovaStar database data partition insert trigger function to latest version
Database Recalculation
nsdbrecalibrate- recalibrate point data (calculate scaled from raw value)nsdbvalidate- re-validate point data (set flag)
Master/Backup/Slave Replication
- Replication Overview
nsdbnetcheck- check whether database replication network is upnsdbrep- NovaStar replication control
Utilities, General
nsdbhostname- TODO smalers 2017-10-12 need to documentnsdbhostport- TODO smalers 2017-10-12 need to documentnsdblock- lock the NovaStar databasensdbpassword- set the NovaStar database password forpsqlcallsnsdbtimecheck- TODO smalers 2017-10-15 need to documentnsdbtrimid- reset database table id sequence to last number used