Skip site navigation (1) Skip section navigation (2)

pg_dump: aborting because of server version mismatch

From: Mitesh Shah <mitesh(dot)shah(at)stripes39(dot)com>
To: seapug(at)postgresql(dot)org
Subject: pg_dump: aborting because of server version mismatch
Date: 2012-05-02 20:23:58
Message-ID: CAHofYQRT-WXgD-+nojF_UNqjnT+Oubf+uY542dS_-m+2ib7g+w@mail.gmail.com (view raw or flat)
Thread:
Lists: adelaide-au-pugatlpugaustinpugbostonpugbwpugpgsql-adminpgsql-bugspgsql-sqlseapugsfpug
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 '{}' ';'

In response to

Responses

austinpug by date

Next:From: Albin, Lloyd PDate: 2012-05-02 21:01:47
Subject: Re: pg_dump: aborting because of server version mismatch
Previous:From: Mitesh ShahDate: 2012-05-02 19:58:07
Subject: pg_dump: aborting because of server version mismatch

adelaide-au-pug by date

Next:From: Albin, Lloyd PDate: 2012-05-02 21:01:47
Subject: Re: pg_dump: aborting because of server version mismatch
Previous:From: Mitesh ShahDate: 2012-05-02 19:58:07
Subject: pg_dump: aborting because of server version mismatch

bostonpug by date

Next:From: Albin, Lloyd PDate: 2012-05-02 21:01:47
Subject: Re: pg_dump: aborting because of server version mismatch
Previous:From: Mitesh ShahDate: 2012-05-02 19:58:07
Subject: pg_dump: aborting because of server version mismatch

seapug by date

Next:From: Albin, Lloyd PDate: 2012-05-02 21:01:47
Subject: Re: pg_dump: aborting because of server version mismatch
Previous:From: Mitesh ShahDate: 2012-05-02 19:58:07
Subject: pg_dump: aborting because of server version mismatch

pgsql-admin by date

Next:From: Albin, Lloyd PDate: 2012-05-02 21:01:47
Subject: Re: pg_dump: aborting because of server version mismatch
Previous:From: Mitesh ShahDate: 2012-05-02 19:58:07
Subject: pg_dump: aborting because of server version mismatch

pgsql-bugs by date

Next:From: Albin, Lloyd PDate: 2012-05-02 21:01:47
Subject: Re: pg_dump: aborting because of server version mismatch
Previous:From: Mitesh ShahDate: 2012-05-02 19:58:07
Subject: pg_dump: aborting because of server version mismatch

sfpug by date

Next:From: Albin, Lloyd PDate: 2012-05-02 21:01:47
Subject: Re: pg_dump: aborting because of server version mismatch
Previous:From: Mitesh ShahDate: 2012-05-02 19:58:07
Subject: pg_dump: aborting because of server version mismatch

bwpug by date

Next:From: Albin, Lloyd PDate: 2012-05-02 21:01:47
Subject: Re: pg_dump: aborting because of server version mismatch
Previous:From: Mitesh ShahDate: 2012-05-02 19:58:07
Subject: pg_dump: aborting because of server version mismatch

atlpug by date

Next:From: Albin, Lloyd PDate: 2012-05-02 21:01:47
Subject: Re: pg_dump: aborting because of server version mismatch
Previous:From: Mitesh ShahDate: 2012-05-02 19:58:07
Subject: pg_dump: aborting because of server version mismatch

pgsql-sql by date

Next:From: Albin, Lloyd PDate: 2012-05-02 21:01:47
Subject: Re: pg_dump: aborting because of server version mismatch
Previous:From: Mitesh ShahDate: 2012-05-02 19:58:07
Subject: pg_dump: aborting because of server version mismatch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group