Re: 9.6 parameters messing up my 9.2 pg_dump/pg_restore

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: 9.6 parameters messing up my 9.2 pg_dump/pg_restore
Date: 2017-06-28 20:10:02
Message-ID: CAKFQuwY3xe3gKDiNYSmyMDYbSG21Hhw8sfPPiH1DY6zORpNKuQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, June 28, 2017, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
wrote:

> Ken Tanzer wrote:
>
> > I didn't see any options for dealing with this, though I'm hoping I'm
> > missing something easy or obvious. Any suggestions or help would be
> > appreciated. Thanks.
>
> pg_dump doesn't promise that its output is compatible with servers older
> than itself. I'm afraid you're stuck with filtering the output somehow
> to remove or maybe comment out those lines.
>
>
Or explicitly use the 9.2 pg_dump instead of finding the 9.6 one in your
path.

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-06-28 20:30:21 Re: 9.6 parameters messing up my 9.2 pg_dump/pg_restore
Previous Message Alvaro Herrera 2017-06-28 19:52:52 Re: 9.6 parameters messing up my 9.2 pg_dump/pg_restore