#!/bin/bash

# Define the PostgreSQL credentials and backup file information
PGUSER=""
PGHOST=""
PGPORT=""
PGDATABASE=""

# Generate a timestamp in the format yyyy-mm-dd-hh-mm
TIMESTAMP=$(date +"%Y-%m-%d-%H-%M")

# Define the backup file name with the timestamp
BACKUP_FILENAME="backup_$TIMESTAMP.tar"

# Prompt for the database password
echo "Please enter the PostgreSQL password:"
read -s PGPASSWORD

# Export the password to be used by pg_dump
export PGPASSWORD

# Execute the pg_dump command
pg_dump -U $PGUSER -h $PGHOST -p $PGPORT -W -F t $PGDATABASE > $BACKUP_FILENAME

# Unset the password for security reasons
unset PGPASSWORD

echo "Backup completed successfully."

#!/bin/bash

# Define the PostgreSQL credentials and backup file information
PGUSER=""
PGHOST=""
PGPORT=""
PGDATABASE=""

# Generate a timestamp in the format yyyy-mm-dd-hh-mm
TIMESTAMP=$(date +"%Y-%m-%d-%H-%M")

# Define the backup file name with the timestamp
BACKUP_FILENAME="backup_$TIMESTAMP.tar"

# Prompt for the database password
echo "Please enter the PostgreSQL password:"
read -s PGPASSWORD

# Export the password to be used by pg_dump
export PGPASSWORD

# Execute the pg_dump command
pg_dump -U $PGUSER -h $PGHOST -p $PGPORT -W -F t $PGDATABASE > $BACKUP_FILENAME

# Unset the password for security reasons
unset PGPASSWORD

echo "Backup completed successfully."