A. Command reference card
The commands below assume the standard paths (the gritdb account, ~/gritdb1, and port 5432).
Installation
| Task |
Command |
| Compare checksums |
cd ~/pkg && sha256sum -c SHA256SUMS |
| Extract the archive |
tar -xzf gritdb-*.tar.gz |
| Verify files |
cd ~/pkg/gritdb-*/ && ./install_gritdb.sh --verify-only |
| Install |
cd ~/pkg/gritdb-*/ && ./install_gritdb.sh |
| Installed version |
jq -r .product_version ~/gritdb1/share/gritdb/manifest.json |
Start and stop
| Task |
Command |
| Start |
~/gritdb1/bin/gritdb-start |
| Confirm that it accepts connections |
~/gritdb1/bin/pg_isready -p 5432 |
| Normal stop |
~/gritdb1/bin/gritdb-stop |
| Quick stop |
~/gritdb1/bin/gritdb-stop --quick |
| Restart |
~/gritdb1/bin/gritdb-stop && ~/gritdb1/bin/gritdb-start |
Status checks
| Task |
Command |
| Four processes |
ps -o pid,comm -p "$(cut -d: -f2 ~/gritdb1/run/grit_admin.pid | paste -sd,)" |
| Confirm the stop (no output is normal) |
pgrep -u gritdb -l -x 'GritAdmin|GritSurfer|GritCatalog|postgres' |
| Connect |
~/gritdb1/bin/psql -p 5432 -d postgres |
| Disk |
df -h ~/gritdb1/datafiles |
| Data size |
du -sh ~/gritdb1/datafiles/* |
| Instance ID |
~/gritdb1/bin/grit_instance_id ~/gritdb1 |
| Log location |
~/gritdb1/log/ |
Tables (in psql)
| Task |
SQL |
| Set the registration condition |
ALTER TABLE <table> REPLICA IDENTITY FULL; |
| Register |
SELECT register_gritsurfer_table('<schema>', '<table>'); |
| List registered tables |
SELECT schema_name, table_name FROM get_gritsurfer_tables(); |
| Unregister |
SELECT unregister_gritsurfer_table('<schema>', '<table>'); |
gritdb.grit_surfer_heartbeat is an internal GritDB registered table. It always appears in the list. Do not unregister or drop it (Admin 6.5).pg_toast.pg_toast_<number> is the TOAST table that is registered together with a table that has long-value columns (for example, text). It appears as one line in the list (Admin 6.5).
If a problem occurs
| Task |
See |
| Find an entry by error text |
Section 7.3 |
| Collect diagnostic data and contact support |
Section 7.4 |
When you read the md source, type each \| in a table as |. In the web and PDF versions, it appears as |. You can copy the process check command as it is from section 4.3.
