=20 # Will produce a custom-format backup if set to "yes" ENABLE_CUSTOM_BACKUPS=3Dyes =20 # Will produce a gzipped plain-format backup if set to "yes" ENABLE_PLAIN_BACKUPS=3Dyes =20 =20 #### SETTINGS FOR ROTATED BACKUPS #### =20 # Which day to take the weekly backup from (1-7 =3D Monday-Sunday) DAY_OF_WEEK_TO_KEEP=3D5 =20 # Number of days to keep daily backups DAYS_TO_KEEP=3D7 =20 # How many weeks to keep weekly backups WEEKS_TO_KEEP=3D5 =20 ###################################### =20 =20 (2.2) /Users/miteshshah/Desktop/pg_backup_rotated_orig.sh #!/bin/bash =20 ########################### ####### LOAD CONFIG ####### ########################### =20 source /Users/miteshshah/Desktop/pg_backup.config =20 =20 ########################### #### START THE BACKUPS #### ########################### =20 function perform_backups() { SUFFIX=3D$1 FINAL_BACKUP_DIR=3D$BACKUP_DIR"`date +\%Y-\%m-\%d`$SUFFIX/" =20 echo "Making backup directory in $FINAL_BACKUP_DIR" =20 if ! mkdir -p $FINAL_BACKUP_DIR; then echo "Cannot create backup directory in $FINAL_BACKUP_DIR. Go and fix it!" exit 1; fi; =20 =20 ########################### ###### FULL BACKUPS ####### ########################### =20 echo -e "\n\nPerforming full backups" echo -e "--------------------------------------------\n" =20 =20 =20 if [ $ENABLE_PLAIN_BACKUPS =3D "yes" ] then echo "Plain backup of $DATABASE" =20 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 =20 if [ $ENABLE_CUSTOM_BACKUPS =3D "yes" ] then echo "Custom backup of $DATABASE" =20 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 =20 =20 =20 echo -e "\nAll database backups complete!" } =20 # DAILY BACKUPS =20 # Delete daily backups 7 days old or more find $BACKUP_DIR -maxdepth 1 -mtime +$DAYS_TO_KEEP -name "*-daily" -exec rm -rf '{}' ';' =20 =20 ------_=_NextPart_001_01CD28A6.C45C7392 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Mitesh,

Your server is newer than your pg_dump program. pg_dump must be the = same version as server version. You need to upgrade your pg_dump to be = version 9.1.2. It should have installed that version when you = installed/upgraded your Postgres version but may have been installed in = a different location or the one you are using for your script is not the = one that came with your server (separate install). So all you need to do = in your script is to point to the one that comes with the server and it = will work or update the one that you are currently using in the script = to version 9.1.2.

Lloyd

From:= = seapug-owner@postgresql.org [mailto:seapug-owner@postgresql.org] On = Behalf Of Mitesh Shah
Sent: Wednesday, May 02, 2012 1:24 = PM
To: seapug@postgresql.org
Subject: [seapug] = pg_dump: aborting because of server version = mismatch

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=3D = <host>

# = username to connect to database as.

USERNAME=3D<user>

# = Database name

DATABASE=3D<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=3D<backup_dir>

# SCRIPTPATH

SCRIPTPATH=3D<path>

# = Will produce a custom-format backup if set to = "yes"

ENABLE_CUSTOM_BACKUPS=3Dyes

<= div>

# Will produce a gzipped plain-format backup if set to = "yes"

ENABLE_PLAIN_BACKUPS=3Dyes

#### SETTINGS FOR ROTATED BACKUPS = ####

# = Which day to take the weekly backup from (1-7 =3D = Monday-Sunday)

DAY_OF_WEEK_TO_KEEP=3D5

# = Number of days to keep daily backups

DAYS_TO_KEEP=3D7

# = How many weeks to keep weekly backups

WEEKS_TO_KEEP=3D5

######################################

(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=3D$1

= FINAL_BACKUP_DIR=3D$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 =3D "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

= if [ $ENABLE_CUSTOM_BACKUPS =3D "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

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 '{}' = ';'

------_=_NextPart_001_01CD28A6.C45C7392--