Part II. Installation and Configuration
This part covers topics that are of interest to a QHB database administrator. This includes installation of the software, set up and configuration of the server, management of users and databases, and maintenance tasks. Anyone who runs a QHB server, even for personal use, but especially in production, should be familiar with the topics covered in this part.
The information in this part is arranged approximately in the order in which a new user should read it. But the chapters are self-contained and can be read individually as desired. The information in this part is presented in a narrative fashion in topical units. Readers looking for a complete description of a particular command should see Chapter SQL Commands.
The first few chapters are written so they can be understood without prerequisite knowledge, so new users who need to set up their own server can begin their exploration with this part. The rest of this part is about tuning and management; that material assumes that the reader is familiar with the general use of the QHB database system. Readers are encouraged to look at Part I Internals and Part III The SQL Language for additional information.
-
- The QHB User Account
- Creating a Database Cluster
- Starting the Database Server
- Managing Kernel Resources
- Shutting Down the Server
- Upgrading a QHB Cluster
- Preventing Server Spoofing
- Encryption Options
- Secure TCP/IP Connections with SSL
- Secure TCP/IP Connections with GSSAPI Encryption
- Secure TCP/IP Connections with SSH Tunnels
- Advanced Security. Memory Cleaning
-
- Setting Parameters
- File Locations
- Connections and Authentication
- Resource Consumption
- Write Ahead Log
- Replication
- Query Planning
- Error Reporting and Logging
- Run-time Statistics
- Automatic Vacuuming
- Client Connection Defaults
- Lock Management
- Version and Platform Compatibility
- Error Handling
- Preset Options
- Customized Options
- Developer Options
- Short Options
- QHB-specific Module and Extension Options
-
- clusterdb — cluster a QHB database
- createdb — create a new QHB database
- createuser — define a new QHB user account
- dropdb — remove a QHB database
- dropuser — remove a QHB user account
- qhb_amcheck — checks for corruption in one or more QHB databases
- qhb_basebackup — take a base backup of a QHB cluster
- pgbench — run a benchmark test on QHB
- pg_config — retrieve information about the installed version of QHB
- qhb_dump — extract a QHB database into a script file or other archive file
- qhb_dumpall — extract a QHB database cluster into a script file
- qhb_isready — check the connection status of a QHB server
- qhb_receivewal — stream write-ahead logs from a QHB server
- qhb_recvlogical — control QHB logical decoding streams
- qhb_restore — restore a QHB database from an archive file created by qhb_dump
- qhb_verifybackup — verify the integrity of a base backup of a QHB cluster
- psql — QHB interactive terminal
- reindexdb — reindex a QHB database
- vacuumdb — garbage-collect and analyze a QHB database
-
- initdb — create a new QHB database cluster
- qhb_archivecleanup — clean up QHB WAL archive files
- qhb_bootstrap — create a new QHB database cluster (functional analogue of initdb, completely modified due to the specifics of QHB)
- qhb_checksums — enable, disable or check data checksums in a QHB database cluster
- qhb_controldata — display control information of a QHB database cluster
- qhb_ctl — initialize, start, stop, or control a QHB server
- qhb_resetwal — reset the write-ahead log and other control information of a QHB database cluster
- qhb_rewind — synchronize a QHB data directory with another data directory that was forked from it
- qhb_test_fsync — determine fastest wal_sync_method for QHB
- qhb_test_timing — measure timing overhead
- qhb_upgrade — upgrade a QHB server instance
- qhb_waldump — display a human-readable rendering of the write-ahead log of a QHB database cluster