Re: [sfpug] pg_dump: aborting because of server version mismatch

Hi, Mitesh,

The error means exactly what it says: You're trying to use the 9.0.5 version of pg_dump to dump a server running 9.1.2; you need a version of pg_dump that is no older than the server you are trying to do the dump from.

On May 2, 2012, at 12:58 PM, Mitesh Shah wrote:

> Hi,
> I am trying to create a daily backup cron script but it fails with an error as below:
>
> Any pointers to resolve this will be greatly appreciated.
>
> Thanks,
> Mitesh Shah
> mitesh(dot)shah(at)stripes39(dot)com
>
> (1) Error:
> bash-3.2$ sh pg_backup_rotated_orig.sh
> Making backup directory in /Users/miteshshah/Documents/2012-05-02-daily/
> -e
>
> Performing full backups
> -e --------------------------------------------
>
> Plain backup of mitesh
> pg_dump: server version: 9.1.2; pg_dump version: 9.0.5
> pg_dump: aborting because of server version mismatch
> -e
> All database backups complete!
>
>
>
> (2.1) /Users/miteshshah/Desktop/pg_backup.config file:
> #############################
> ## POSTGRESQL BACKUP CONFIG ##
> ##############################
> # hostname to adhere to pg_hba policies.
> HOSTNAME= <host>
>
> # username to connect to database as.
> USERNAME=<user>
>
> # Database name
> DATABASE=<database>
>
> # This dir will be created if it doesn't exist. This must be writable by the user the script is
> # running as.
> BACKUP_DIR=<backup_dir>
>
> # SCRIPTPATH
> SCRIPTPATH=<path>
>
> # Will produce a custom-format backup if set to "yes"
> ENABLE_CUSTOM_BACKUPS=yes
>
> # Will produce a gzipped plain-format backup if set to "yes"
> ENABLE_PLAIN_BACKUPS=yes
>
>
> #### SETTINGS FOR ROTATED BACKUPS ####
>
> # Which day to take the weekly backup from (1-7 = Monday-Sunday)
> DAY_OF_WEEK_TO_KEEP=5
>
> # Number of days to keep daily backups
> DAYS_TO_KEEP=7
>
> # How many weeks to keep weekly backups
> WEEKS_TO_KEEP=5
>
> ######################################
>
>
> (2.2) /Users/miteshshah/Desktop/pg_backup_rotated_orig.sh
> #!/bin/bash
>
> ###########################
> ####### LOAD CONFIG #######
> ###########################
>
> source /Users/miteshshah/Desktop/pg_backup.config
>
>
> ###########################
> #### START THE BACKUPS ####
> ###########################
>
> function perform_backups()
> {
> SUFFIX=$1
> FINAL_BACKUP_DIR=$BACKUP_DIR"`date +\%Y-\%m-\%d`$SUFFIX/"
>
> echo "Making backup directory in $FINAL_BACKUP_DIR"
>
> if ! mkdir -p $FINAL_BACKUP_DIR; then
> echo "Cannot create backup directory in $FINAL_BACKUP_DIR. Go and fix it!"
> exit 1;
> fi;
>
>
> ###########################
> ###### FULL BACKUPS #######
> ###########################
>
> echo -e "\n\nPerforming full backups"
> echo -e "--------------------------------------------\n"
>
>
>
> if [ $ENABLE_PLAIN_BACKUPS = "yes" ]
> then
> echo "Plain backup of $DATABASE"
>
> if ! pg_dump -Fp -h "$HOSTNAME" -U "$USERNAME" "$DATABASE" | gzip > $FINAL_BACKUP_DIR"$DATABASE".sql.gz.in_progress; then
> echo "[!!ERROR!!] Failed to produce plain backup database $DATABASE"
> else
> mv $FINAL_BACKUP_DIR"$DATABASE".sql.gz.in_progress $FINAL_BACKUP_DIR"$DATABASE".sql.gz
> fi
> fi
>
> if [ $ENABLE_CUSTOM_BACKUPS = "yes" ]
> then
> echo "Custom backup of $DATABASE"
>
> if ! pg_dump -Fc -h "$HOSTNAME" -U "$USERNAME" "$DATABASE" -f $FINAL_BACKUP_DIR"$DATABASE".custom.in_progress; then
> echo "[!!ERROR!!] Failed to produce custom backup database $DATABASE"
> else
> mv $FINAL_BACKUP_DIR"$DATABASE".custom.in_progress $FINAL_BACKUP_DIR"$DATABASE".custom
> fi
> fi
>
>
>
> echo -e "\nAll database backups complete!"
> }
>
> # DAILY BACKUPS
>
> # Delete daily backups 7 days old or more
> find $BACKUP_DIR -maxdepth 1 -mtime +$DAYS_TO_KEEP -name "*-daily" -exec rm -rf '{}' ';'
>
>

--
-- Christophe Pettus
xof(at)thebuild(dot)com