 | |
Re: [ADMIN] [SQL] pg_dump: aborting because of server version mismatch
mailing.database.pgsql-admin mailing.database.pgsql-admin
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: [ADMIN] [SQL] pg_dump: aborting because of server version mismatch -
05-11-2012
, 02:39 PM
|
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 (AT) stripes39 (DOT) com <mailto:mitesh.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* |
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.
Quote:
|
*pg_dump: aborting because of server version mismatch* -e All database backups complete! |
Adrian Klaver
adrian.klaver (AT) gmail (DOT) com
--
Sent via pgsql-admin mailing list (pgsql-admin (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.