On Fri, Jun 23, 2017 at 06:17:47PM +0300, Sergey Burladyan wrote:
> I successfully upgraded last night from 9.2 to 9.4 and find other issue :-)
> It is about hash index and promote:
> 1. create master
> 2. create standby from it
> 3. create unlogged table and hash index like:
> create unlogged table test (id int primary key, v text);
> create index on test using hash (id);
> 3. stop master
> 4. promote standby
> now, if you try to upgrade this new promoted master pg_upgrade will stop
> on this hash index:
> error while creating link for relation "public.test_id_idx"
> ("s/9.2/base/16384/16393" to "m/9.4/base/16422/16393"): No such file or
> Failure, exiting
> I touch this file (s/9.2/base/16384/16393) and rerun pg_upgrade from
> scratch and it complete successfully.
Sergey, can you please test if the table "test" is not unlogged, does
pg_upgrade still fail on the hash index file?
Bruce Momjian <br...@momjian.us> http://momjian.us
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
Sent via pgsql-hackers mailing list (firstname.lastname@example.org)
To make changes to your subscription: