Use OS username for database naming convention

[NOVA-Openclaw]

Convention

All nova-* projects should use the OS username for database naming to enable multi-user setups.

Pattern:

DB_USER="${PGUSER:-$(whoami)}"
DB_NAME="${DB_USER//-/_}_memory"  # Replace hyphens with underscores

Examples:

• User nova → database nova_memory
• User nova-staging → database nova_staging_memory
• User argus → database argus_memory

Rationale:

• Enables clean multi-user setups on same PostgreSQL server
• Each user/agent gets isolated database
• Prevents conflicts between production, staging, and test instances

Implementation:

1. Update any install scripts to use dynamic database naming
2. Update any code that connects to the database to derive name from username
3. Update documentation to reflect this convention

Reference: nova-memory#4 is the canonical implementation.