NovaStar Program Reference / Database / Overview

Database programs perform tasks related to the NovaStar database, such as backups, and synchronization.

• 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.)
• Database Replication - database replication
• Utilities, General - general utilities
• Utilities, PostgreSQL - PostgreSQL utilities (commands)

See also:

• Data Import Programs
• Data Export Programs

---

Backup and Restore

• Backup Overview
• nsdbbackup - create (dump) database backup
• nsdbrestore - 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 performance
• nsdbmaintenance - make sure that data partition tables exist
• nsdbmerge - merge redundant point data reports
• nsdbmergeall - TODO smalers 2017-10-14 need to document
• See installation program: nsdbupdatedatapartitiontrigger - 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)

Database Replication

• Replication Overview
• nsdbnetcheck - check whether database replication network is up
• nsdbrep - NovaStar replication control

Utilities, General

• nsdbhostname - TODO smalers 2017-10-12 need to document
• nsdbhostport - TODO smalers 2017-10-12 need to document
• nsdblock - lock the NovaStar database
• nsdbpassword - set the NovaStar database password for psql calls
• nsdbtimecheck - TODO smalers 2017-10-15 need to document
• nsdbtrimid - reset database table id sequence to last number used

Utilities, PostgreSQL

• pgadmin3 - PostgreSQL graphical user interface
• psql - PostgreSQL command line tool
• slonik - Slony replication command line tool