Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore
Date
Msg-id CAKFQuwY3xe3gKDiNYSmyMDYbSG21Hhw8sfPPiH1DY6zORpNKuQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
On Wednesday, June 28, 2017, Alvaro Herrera <alvherre@2ndquadrant.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. 

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore