Re: [SQL] [seapug] Re: [BUGS] pg_dump: aborting because of server version mismatchT

2012-05-03 Thread Robert Bernier
There used to be a switch in pg_dump that would disable the version, you can even see that's in the man page. However, it is not reccommended and the most recent versions have fully deprecated the switch. Technically speaking that means that you can even use an older version of pg_dump and it wo

[SQL] Re: [BUGS] pg_dump: aborting because of server version mismatch

2012-05-03 Thread Kevin Grittner
Mitesh Shah wrote: > *pg_dump: server version: 9.1.2; pg_dump version: 9.0.5* > *pg_dump: aborting because of server version mismatch* This is not a bug. Use a version of pg_dump which is at least as new as the server. The older version of pg_dump is unlikely to be able to recognize everythi

[SQL] pg_dump: aborting because of server version mismatch

2012-05-03 Thread Mitesh Shah
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.s...@stripes39.com *(1) Error:* bash-3.2$ sh pg_backup_rotated_orig.sh Making backup directory in /Users/miteshshah/Docum