Eu tenho um script de shell de backup que executa o pg_basebackup todas as noites. Quando tento executá-lo, recebo esta mensagem de erro dizendo que pg_basebackup aparentemente não é compatível com Postgres.app versão 16.3.
2024-07-25 14:38:37 - Backup script started.
2024-07-25 14:38:37 - PG_USER: postgres
2024-07-25 14:38:37 - BACKUP_DIR: /Volumes/Atoma/Backup
2024-07-25 14:38:37 - TEMP_BACKUP_DIR: /Volumes/Atoma/tmp_backup
2024-07-25 14:38:37 - DAY_OF_WEEK: Donnerstag
2024-07-25 14:38:37 - BACKUP_NAME: Donnerstag.tar.gz
2024-07-25 14:38:37 - LOG_FILE: /Users/tristan/Server_Backup/daily.log
2024-07-25 14:38:37 - Starting backup for Donnerstag.
2024-07-25 14:38:37 - Running pg_basebackup command.
pg_basebackup: error: incompatible server version 16.3 (Postgres.app)
pg_basebackup: removing contents of data directory "/Volumes/Atoma/tmp_backup"
2024-07-25 14:38:38 - Backup failed for Donnerstag.
2024-07-25 14:38:38 - Backup script finished.
Eu uso o macOS Sonoma 14.5 (23F79). Este é o meu script de backup:
#!/bin/zsh
# Variables
PG_USER="xyz"
PG_USER_PW="xyz"
PORT="5432"
HOST="localhost"
BACKUP_DIR="/Volumes/Atoma/Backup"
TEMP_BACKUP_DIR="/Volumes/Atoma/tmp_backup"
DAY_OF_WEEK=$(date +%A)
BACKUP_NAME="$DAY_OF_WEEK.tar.gz"
LOG_FILE="/Users/tristan/Server_Backup/daily.log"
# create temporary directory (needed for pg_basebackup)
mkdir -p $TEMP_BACKUP_DIR
# log with timestamp
log_with_timestamp() {
echo "$(date '+%Y-%m-%d %H:%M:%S') - $1" >> $LOG_FILE
}
# Start logging
log_with_timestamp "Backup script started."
# Logging variables
log_with_timestamp "PG_USER: $PG_USER"
log_with_timestamp "BACKUP_DIR: $BACKUP_DIR"
log_with_timestamp "TEMP_BACKUP_DIR: $TEMP_BACKUP_DIR"
log_with_timestamp "DAY_OF_WEEK: $DAY_OF_WEEK"
log_with_timestamp "BACKUP_NAME: $BACKUP_NAME"
log_with_timestamp "LOG_FILE: $LOG_FILE"
# Start backup log process
log_with_timestamp "Starting backup for $DAY_OF_WEEK."
# Set the PGPASSWORD environment variable
export PGPASSWORD=$PG_USER_PW
# Run pg_basebackup
log_with_timestamp "Running pg_basebackup command."
if pg_basebackup -h $HOST -p $PORT -U $PG_USER -D $TEMP_BACKUP_DIR -Ft -z -P -Xs 2>> $LOG_FILE; then
# Compress the backup and move it to the final destination
mv $TEMP_BACKUP_DIR/$BACKUP_NAME $BACKUP_DIR
log_with_timestamp "Backup completed successfully for $DAY_OF_WEEK."
else
log_with_timestamp "Backup failed for $DAY_OF_WEEK."
fi
# Clean up temporary backup directory
rm -rf $TEMP_BACKUP_DIR
# Unset the PGPASSWORD environment variable for security
unset PGPASSWORD
# End of script
log_with_timestamp "Backup script finished."
