Re: pg_upgrade error

On Mon, Dec 7, 2015 at 05:44:06PM +0000, Yogi Barot wrote:
> Hi,
>
>
>
> I am doing pg upgrade from postgresql 9.0.19 to postgresql 9.4 CE version.
>
>
>
> Database size is 300GB.
>
> Pg_upgade check runs fine but pg_upgrade fails with following error:
>
>
>
> linking "/opt/symcor-foa/pgsql/data/pg_tblspc/federator/PG_9.0_201008051/
> 10349572/11838" to "/opt/symcor-foa/pgsql/data/pg_tblspc/federator/
> PG_9.4_201409291/16434/13013"
>
>
>
> error while creating link for relation "pg_catalog.pg_largeobject" ("/opt/
> symcor-foa/pgsql/data/pg_tblspc/federator/PG_9.0_201008051/10349572/11838" to "
> /opt/symcor-foa/pgsql/data/pg_tblspc/federator/PG_9.4_201409291/16434/13013"):
> No such file or directory
>
> Failure, exiting
>
>
>
> How can I resolve this or resume upgrade?
>
> The directory "/opt/symcor-foa/pgsql/data/pg_tblspc/federator/PG_9.0_201008051/
> 10349572/11838” does not exist in old cluster, how can I change or remove
> reference to this directory?

My guess is that you have a mismatch between the symbolic links used in
data/pg_tblspc/ and pg_tablespace.spclocation.
pg_tablespace.spclocation. was removed in Postgres 9.2, but in older
releases you could have moved the tablespace without updating that
field, causing pg_upgrade failures.

--
Bruce Momjian <bruce(at)momjian(dot)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 +