Re: pg_upgrade - Mailing list pgsql-admin

From Catalin Iacob
Subject Re: pg_upgrade
Date
Msg-id CAHg_5gqmSE8jpLaCyEQe-Y8jEGAittL0oTNc4BpC+2McLJbvSg@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade  (Jan Lentfer <Jan.Lentfer@web.de>)
List pgsql-admin
On Mon, Jun 22, 2015 at 11:36 AM, Jan Lentfer <Jan.Lentfer@web.de> wrote:
> You do either 1 + 2 OR 3. pg_upgrade is binary upgrade, where as pg_dump +
> pg_restore is "logical" (dump data and schemal to SQL instructions).

I was thinking (and could not find definite answer) if it is supported
to reuse the binary files (essentially what pg_upgrade does) across
diferent Windows versions. According to, for example,
http://superuser.com/a/643087/22951 this isn't supported across
different operating systems.

Streaming replication also suggests the same OS on both sides.

So is pg_upgrade actually supported in Rainer's case where he is
switching the Windows version?


pgsql-admin by date:

Previous
From: "Saravanan S"
Date:
Subject: ORACLE_FDW
Next
From: Scott Ribe
Date:
Subject: Re: backup software for postgresql