Postgres Pro
Downloads
Home   >   mailing lists

Re: Restore backup file "with oids" - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: Restore backup file "with oids"
Date
Msg-id CAFcNs+rze-Jd5+BZot2BpPB_RfCT4r3dXd2UBL6EtmBkZHiJuw@mail.gmail.com
Whole thread Raw
In response to Restore backup file "with oids"  (gmail Vladimir Koković <vladimir.kokovic@gmail.com>)
List pgsql-hackers
Tree view
On Wed, Dec 18, 2019 at 2:28 PM gmail Vladimir Koković <vladimir.kokovic@gmail.com> wrote:

Hi,

Is there somewhere a script that can do a restore backup file "with oids" in some newer DB where there is no term "with oids"?



Short answer: No!

Long answer: try use the pg_dump binary from your new version (12) connecting to your old version... is the best practice when you want to upgrade your PostgreSQL using dump/restore strategy.

Regards,

--
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Read Uncommitted
Next
From: Tom Lane
Date:
Subject: Re: client auth docs seem to have devolved