| From: | Yogi Barot <YBarot(at)symcor(dot)com> |
|---|---|
| To: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | pg_upgrade error |
| Date: | 2015-12-07 17:44:06 |
| Message-ID: | ca0484351b28481081e5692ff824f7b9@MX002.symprod.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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?
Thanks,
Yogi
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Johansen | 2015-12-07 18:22:40 | Replication with partitions? |
| Previous Message | Mark Steben | 2015-12-04 13:38:22 | Documentation on hacker prevention (continued) |