GritDB 1.1 manual
Admin Guide
A manual for engineers who run GritDB after finishing QuickStart. It follows the order of operations, from installation planning through installation details, start and stop, configuration, table operations, checks, backup and restore, upgrades, logs, limitations, and security.
- 0About this guideAudience, contents, task map, and scope of the Admin guide
- 1Installation planningSetup types, supported platforms, sizing, OS settings, disk layout, ports, and bringing in files
- 2Installation detailsAll installation options, other paths, installing as root, data volume relocation, ports, installation logs, and multiple installations
- 3Reinitialization, upgrade, and removalData reinitialization and restore, pre-upgrade checks, minor/major upgrade, rollback, and removal and disposal
- 4Start and stop operationsStart sequence and completion check, stop methods and time, start after a crash, cleanup of leftovers, status check, and start at boot
- 5ConfigurationConfiguration locations, postgresql.conf managed block, how to change settings and precedence, when changes take effect, recommended values by server size, and GritDB engine configuration
- 6Database and table operationsCreate databases, registration requirements, register and unregister, receive into an analytics setup, view status, analytics sessions, and operations not to perform on registered tables
- 7Monitoring and routine checksMonitoring metrics, thresholds, daily/weekly/monthly checklists, analytics setup monitoring, routine cleanup, and pre-production checks
- 8Backup and restoreBackup unit, offline backup, PostgreSQL backup tools and GritDB, restore, restore verification, and taking the analytics setup again
- 9Log managementLog file map, format and levels, rotation, PostgreSQL log rotation, retention and cleanup, core files, and export
- 10LimitationsPlatform, numeric limits, PostgreSQL compatibility scope, storage structure, operating rules, and features not in 1.1
- 11SecuritySecurity overview, installation defaults, changing authentication, remote connections, accounts and privileges, analytics sessions and row security, file permissions, and security limits of 1.1
- AReferenceInstallation options, settings, SQL functions, log files, directories, diagnostic queries, Oracle and Tibero mapping, and glossary
This manual is for GritDB 1.1. For a first installation, read QuickStartfirst.