#!/bin/bash
# L6 CGIS data census on 14.225.11.8 - read-only psql, LIGHTWEIGHT (no pg_database_size)
set -u
OUT="/root/ir-assessment/redteam/gitlab_vdss_com_vn/L6_cgis_db_census_8.txt"
PSQL="host=14.225.11.8 port=5432 user=postgres dbname=postgres connect_timeout=10"
export PGPASSWORD='Ctech2022!@#'

{
  echo "===L6 CGIS DB CENSUS 14.225.11.8 $(date -u) ==="
  echo "--- version ---"
  psql "$PSQL" -Atc "SELECT version();"
  echo "--- DB NAMES ---"
  psql "$PSQL" -Atc "SELECT datname FROM pg_database WHERE NOT datistemplate ORDER BY datname;"
  echo "--- DB COUNT ---"
  psql "$PSQL" -Atc "SELECT count(*) FROM pg_database WHERE NOT datistemplate;"
  echo "===END==="
} > "$OUT" 2>&1

echo "--- output file: $OUT ---"
wc -l "$OUT"