# 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"