Skip to main content

Database Configuration

PostgreSQL database configuration and connection pooling.

Connection Settings​

APPSERVER_DB_HOST​

  • PostgreSQL server hostname
  • Default: localhost

APPSERVER_DB_PORT​

  • PostgreSQL server port
  • Default: 5432

APPSERVER_DB_NAME​

  • Database name
  • Default: appserver

APPSERVER_DB_USER​

  • Database username
  • Default: appserver

APPSERVER_DB_PASSWORD​

  • Database password
  • Required: Yes

APPSERVER_DB_SSLMODE​

  • SSL connection mode
  • Values: disable, require, verify-ca, verify-full
  • Default: disable
  • Production: Use verify-full

Connection String Format​

TODO: Document connection string format

postgres://user:password@host:port/dbname?sslmode=verify-full

Connection Pooling​

TODO: Document connection pool configuration:

  • Max connections
  • Idle connections
  • Connection lifetime
  • Connection timeout

Database Schema​

TODO: Document database schema:

  • Tables owned by AppServer
  • Application tables
  • Migrations

Migrations​

TODO: Document database migration strategy:

  • Migration tool
  • Migration files location
  • Running migrations
  • Rollback procedures

Performance Tuning​

TODO: Document performance settings:

  • Statement timeout
  • Idle in transaction timeout
  • Query optimization
  • Index management

Backup & Recovery​

TODO: Document backup strategies:

  • Backup frequency
  • Point-in-time recovery
  • Backup storage
  • Restore procedures

Monitoring​

TODO: Document database monitoring:

  • Connection pool metrics
  • Query performance
  • Slow query log
  • Database size and growth