Re: BUG #13911: pg_upgrade from 8.4 to 9.5 broken

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13911: pg_upgrade from 8.4 to 9.5 broken
Date: 2016-02-04 18:32:12
Message-ID: 24393.1454610732@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

John R Pierce <pierce(at)hogranch(dot)com> writes:
> On 2/4/2016 10:03 AM, Tom Lane wrote:
>> Before 9.2, pg_upgrade never worked at all for setups with config-only
>> data directories, since it couldn't figure out where the real data
>> directory was. Now it does work, but only if the old postmaster supports -C.

> would a (hacky) workaround be to copy the 8.4 postgresql.conf and
> pg_hba.conf to the actual data directory, then point to that as the source ?

Yeah, something like that is the solution. You need to make it look like
a traditional data directory setup.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Geoghegan 2016-02-04 20:43:15 Re: BUG #13891: Deparsed arbiter WHERE clauses cannot be parsed by Postgres
Previous Message John R Pierce 2016-02-04 18:10:12 Re: BUG #13911: pg_upgrade from 8.4 to 9.5 broken