Re: Problems with pg_upgrade after change of unix user running db. - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Problems with pg_upgrade after change of unix user running db.
Date
Msg-id 20151130170107.GC20094@momjian.us
Whole thread Raw
In response to Re: Problems with pg_upgrade after change of unix user running db.  (Benedikt Grundmann <bgrundmann@janestreet.com>)
Responses Re: Problems with pg_upgrade after change of unix user running db.
List pgsql-general
On Mon, Nov 30, 2015 at 04:51:15PM +0000, Benedikt Grundmann wrote:
>     Are you able to compile from 9.4 git head and test that?  It seems
>     dumping inheriting constraints from parents has not worked properly for
>     some time.
>
>
> Do I need to get the latest/head 9.2 or the latest/head 9.4 or both?  For what
> it is worth I just tried after upgrading to the latest released 9.2 (and same
> 9.45) and that didn't work :-(

You actually need non-released 9.4.X code that is in pg_dump, and we use
9.4 pg_dump to dump the 9.2 database.

> I should certainly be able to compile from source.  But the upgrade to 9.4 is
> by far not high on my priority stack (other than maybe some speed wins there is
> nothing in 9.4 that we are eager for, there are some niceties but I can happily
> live without all of them for years) and has already consumed way more time than
> I had scheduled for it.  So I'll return to focus on other work for at least
> this week and maybe more depending on how that work goes.
>
> Thanks to everyone I'll certainly update this thread if / when I have more time
> to devote to this.

The simplest solution is to wait for 9.4.6 to be released and test that.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription                             +


pgsql-general by date:

Previous
From: Benedikt Grundmann
Date:
Subject: Re: Problems with pg_upgrade after change of unix user running db.
Next
From: David Kensiski
Date:
Subject: XID wraparound with huge pg_largeobject