Message-ID: <4FAD6AE6.6000904@gmail.com>
Date: Fri, 11 May 2012 12:39:18 -0700
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
	rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
To: Mitesh Shah <mitesh.shah@stripes39.com>
CC: pgsql-admin@postgresql.org, pgsql-bugs@postgresql.org,
	pgsql-sql@postgresql.org, adelaide-au-pug@postgresql.org,
	seapug@postgresql.org
Subject: Re: [SQL] pg_dump: aborting because of server version mismatch
References: 
 <CAHofYQQ6yvHGCiHPBqTAL5fU=3haWXdE7oX-3=q=pcGYPajFxg@mail.gmail.com>
In-Reply-To: 
 <CAHofYQQ6yvHGCiHPBqTAL5fU=3haWXdE7oX-3=q=pcGYPajFxg@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 05/02/2012 12:55 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 <mailto: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*

The problem is you are using an older version of pg_dump to dump a newer 
database. That will not work.
Possible solution:
You are running via cron. Cron has its own environment. Unless you are 
explicit in your pathing you can get surprising results, see above.
Find the path to the 9.1.2 version of pg_dump and use that absolute path 
in your script.

> *pg_dump: aborting because of server version mismatch*
> -e
> All database backups complete!
>

-- 
Adrian Klaver
adrian.klaver@gmail.com