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

From: Robert Bernier <rbernier(at)mediosystems(dot)com>
To: seapug(at)postgresql(dot)org
Cc: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>, adelaide-au-pug(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, "Mitesh Shah" <mitesh(dot)shah(at)stripes39(dot)com>
Subject: Re: [seapug] Re: [BUGS] pg_dump: aborting because of server version mismatchT
Date: 2012-05-02 22:27:49
Message-ID: 201205021527.50466.rbernier@mediosystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: adelaide-au-pug atlpug austinpug bostonpug bwpug pgsql-admin pgsql-bugs pgsql-sql seapug sfpug

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 wouldn't
generate any errors although I wouldn't want to test it out on important stuff.

Robert Bernier

On Wednesday, May 02, 2012 02:53:53 pm Kevin Grittner wrote:
> Mitesh Shah <mitesh(dot)shah(at)stripes39(dot)com> 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 everything in the newer server,
>
> -Kevin

In response to

Browse adelaide-au-pug by date

  From Date Subject
Next Message Christophe Pettus 2012-05-03 03:27:28 Re: [sfpug] pg_dump: aborting because of server version mismatch
Previous Message Kevin Grittner 2012-05-02 21:53:53 Re: [BUGS] pg_dump: aborting because of server version mismatch

Browse atlpug by date

  From Date Subject
Next Message Christophe Pettus 2012-05-03 03:27:28 Re: [sfpug] pg_dump: aborting because of server version mismatch
Previous Message Kevin Grittner 2012-05-02 21:53:53 Re: [BUGS] pg_dump: aborting because of server version mismatch

Browse austinpug by date

  From Date Subject
Next Message Christophe Pettus 2012-05-03 03:27:28 Re: [sfpug] pg_dump: aborting because of server version mismatch
Previous Message Kevin Grittner 2012-05-02 21:53:53 Re: [BUGS] pg_dump: aborting because of server version mismatch

Browse bostonpug by date

  From Date Subject
Next Message Christophe Pettus 2012-05-03 03:27:28 Re: [sfpug] pg_dump: aborting because of server version mismatch
Previous Message Kevin Grittner 2012-05-02 21:53:53 Re: [BUGS] pg_dump: aborting because of server version mismatch

Browse bwpug by date

  From Date Subject
Next Message Christophe Pettus 2012-05-03 03:27:28 Re: [sfpug] pg_dump: aborting because of server version mismatch
Previous Message Kevin Grittner 2012-05-02 21:53:53 Re: [BUGS] pg_dump: aborting because of server version mismatch

Browse pgsql-admin by date

  From Date Subject
Next Message Christophe Pettus 2012-05-03 03:27:28 Re: [sfpug] pg_dump: aborting because of server version mismatch
Previous Message Kevin Grittner 2012-05-02 21:53:53 Re: [BUGS] pg_dump: aborting because of server version mismatch

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-05-02 22:29:10 Re: BUG #6624: Tab completion of identifier containing single backslash triggers warnings
Previous Message Kevin Grittner 2012-05-02 21:53:53 Re: [BUGS] pg_dump: aborting because of server version mismatch

Browse pgsql-sql by date

  From Date Subject
Next Message Christophe Pettus 2012-05-03 03:27:28 Re: [sfpug] pg_dump: aborting because of server version mismatch
Previous Message Kevin Grittner 2012-05-02 21:53:53 Re: [BUGS] pg_dump: aborting because of server version mismatch

Browse seapug by date

  From Date Subject
Next Message Robert Bernier 2012-05-02 22:48:25 Re: Re: [BUGS] pg_dump: aborting because of server version mismatchT
Previous Message Kevin Grittner 2012-05-02 21:53:53 Re: [BUGS] pg_dump: aborting because of server version mismatch

Browse sfpug by date

  From Date Subject
Next Message Christophe Pettus 2012-05-03 03:27:28 Re: [sfpug] pg_dump: aborting because of server version mismatch
Previous Message Kevin Grittner 2012-05-02 21:53:53 Re: [BUGS] pg_dump: aborting because of server version mismatch