Re: pg_upgrade error
От | Bruce Momjian |
---|---|
Тема | Re: pg_upgrade error |
Дата | |
Msg-id | 20151207210455.GA28279@momjian.us обсуждение исходный текст |
Ответ на | pg_upgrade error (Yogi Barot <YBarot@symcor.com>) |
Ответы |
Re: pg_upgrade error
|
Список | pgsql-admin |
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@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-admin по дате отправления: