.env.example

# Source Database Configuration
SOURCE_DB_HOST=localhost
SOURCE_DB_PORT=5432
SOURCE_DB_USER=postgres
SOURCE_DB_PASSWORD=postgres
SOURCE_DB_NAME=source_db
SOURCE_DB_SCHEMA=public
SOURCE_DB_SSLMODE=disable

# Destination Database Configuration
DEST_DB_HOST=localhost
DEST_DB_PORT=5432
DEST_DB_USER=postgres
DEST_DB_PASSWORD=postgres
DEST_DB_NAME=dest_db
DEST_DB_SCHEMA=public
DEST_DB_SSLMODE=disable

# Tables to Transfer (comma-separated, must have same count)
# Format: schema.table or just table (will use default schema)
# Examples:
#   SOURCE_TABLES=users,orders,products
#   DEST_TABLES=users_backup,orders_backup,products_backup
SOURCE_TABLES=
DEST_TABLES=


# Transfer Configuration
# BATCH_SIZE: Number of rows per batch (for progress tracking, streaming is always used)
BATCH_SIZE=10000

# TRUNCATE_BEFORE_TRANSFER: Set to "true" to truncate destination table before transfer
TRUNCATE_BEFORE_TRANSFER=false

# DISABLE_TRIGGERS: Set to "true" to disable triggers during transfer (requires superuser)
DISABLE_TRIGGERS=false