From: Christophe Pettus <xof@thebuild.com>
To: Mitesh Shah <mitesh.shah@stripes39.com>
Cc: sfpug@postgresql.org
Cc: atlpug@postgresql.org
Cc: austinpug@postgresql.org
Cc: bostonpug@postgresql.org
Cc: bwpug@postgresql.org
Subject: Re: [sfpug] pg_dump: aborting because of server version mismatch
Date: Wed, 2 May 2012 20:27:28 -0700
Message-ID: <7DDB8E70-7E48-4EA5-8D54-A4E754971830@thebuild.com> (raw)
In-Reply-To: <CAHofYQQOmZKT2Y=kUV0_GLgT59vjj8UBa5ShR0yHxyZYsGQd0w@mail.gmail.com>
References: <CAHofYQQ6yvHGCiHPBqTAL5fU=3haWXdE7oX-3=q=pcGYPajFxg@mail.gmail.com>
<CAHofYQQOmZKT2Y=kUV0_GLgT59vjj8UBa5ShR0yHxyZYsGQd0w@mail.gmail.com>
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.shah@stripes39.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@thebuild.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: xof@thebuild.com, mitesh.shah@stripes39.com, sfpug@postgresql.org, atlpug@postgresql.org, austinpug@postgresql.org, bostonpug@postgresql.org, bwpug@postgresql.org
Subject: Re: [sfpug] pg_dump: aborting because of server version mismatch
In-Reply-To: <7DDB8E70-7E48-4EA5-8D54-A4E754971830@thebuild.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox