.env.example

# --- PostgreSQL Connection Details ---
# Hostname or IP of your primary Laterbase PostgreSQL server
PRIMARY_HOST=your_primary_server_hostname_or_ip

# Password for the 'postgres' user (or replication user) on the primary server
# Used for both replication (standby) and backups (backup-agent)
REPL_PASSWORD=your_primary_db_password

# Comma-separated list of database names on the primary Laterbase server to back up
# Required by the backup-agent for pg_dump (e.g., db1,db2,another_db)
PRIMARY_DBS=your_laterbase_db_names

# Optional: Port and User for primary connection if not default (5432, postgres)
# PRIMARY_PORT=5432
# PRIMARY_USER=postgres

# --- Standby Server Configuration (Optional Overrides) ---
# These override the defaults set in docker-compose.yml for the standby service
# POSTGRES_USER=postgres
# POSTGRES_DB=laterbase_standby_db
# PGDATA=/var/lib/postgresql/data/pgdata

# --- pgAdmin Configuration ---
# Email address for the default pgAdmin user login
PGADMIN_EMAIL=your_pgadmin_email@example.com
# Password for the default pgAdmin user login
PGADMIN_PASSWORD=your_pgadmin_password
PGADMIN_ACCESS_SUBNET=192.168.65.0/24 # Subnet allowed to connect to standby (e.g., Docker network, VPN)
PG_REALWORLD_SUBNET=YOUR_LAN_OR_VPN_SUBNET # e.g., 192.168.1.0/24 (Optional: Allow connections from another network)

# --- Backup Agent & Duplicati Configuration ---

# Path on the host machine where local .sql.gz backups are stored by backup.sh
# This directory is mounted into the backup-agent container as /backups (writeable)
# and into the duplicati container as /backups (read-only).
LOCAL_BACKUP_PATH=./backups

# Number of days to keep local .sql.gz backups in the LOCAL_BACKUP_PATH volume.
# This cleanup is performed by backup.sh (run by the scheduler).
# Duplicati manages its own remote retention based on its job settings.
BACKUP_RETENTION_DAYS=7

# --- Duplicati Service Configuration ---
# Timezone for the Duplicati container (e.g., Europe/London, America/New_York, Etc/UTC)
# See https://en.wikipedia.org/wiki/List_of_tz_database_time_zones
TZ=Etc/UTC

# Optional: Set a password for the Duplicati Web UI. Uncomment and set the value.
# DUPLICATI_WEBSERVICE_PASSWORD=your_secure_password

# --- Duplicati Job Setup (Done via Web UI at http://localhost:8200) ---
# - General: Give your backup job a name. Encryption is recommended.
# - Destination: Choose your storage provider (e.g., Google Drive, S3, B2) and configure credentials/bucket details.
# - Source Data: Select the '/backups' folder inside the container.
# - Schedule: Set how often Duplicati should check for new files and upload them (e.g., "Run daily at 3:00 AM").
#             Note: backup.sh creates new .sql.gz files hourly (via Ofelia). Duplicati will upload any new files found since its last run.
# - Options: Configure remote retention (e.g., "Keep backups for 30 Days"). This controls how long backups are kept *at the destination*.