CLI Tools:

• psql: interactive SQL shell for connecting to databases, run queries, etc.
• pg_ctl: Starts & stops the PostgreSQL server
• createdb / dropdb: Create or remove databases
• createuser / dropuser: Create or remove users
• pg_dump / pg_restore: Backup or restore a database

Data and config files:

• $PGDATA: data directory for storing databases, WAL logs, and config files.
• postgresql.conf: Main server configuration (ports, logging, memory settings)
• pg_hba.conf: Controls client authentication

• Postgres for Everything
• PostgreSQL - ArchWiki
• PGlite - Embeddable Postgres
• fergusstrange/embedded-postgres: Run Postgres locally in a Go application