15 lines
430 B
Bash
15 lines
430 B
Bash
# Variables
|
|
BACKUP_DIR=./database/backups
|
|
PGUSER=postgres
|
|
PGPASSWORD=postgres
|
|
PGDATABASE=mydb
|
|
CONTAINER_NAME=db-c
|
|
|
|
# Get current date and time for backup file
|
|
TIMESTAMP=$(date)
|
|
BACKUP_FILE=$BACKUP_DIR/backup_$PGDATABASE_$TIMESTAMP.sql
|
|
|
|
# Run pg_dump inside the PostgreSQL container
|
|
docker exec -t $CONTAINER_NAME pg_dump -U $PGUSER $PGDATABASE > $BACKUP_FILE
|
|
|
|
echo "Backup completed: $BACKUP_FILE" |