From: Yogi Barot <YBarot@symcor.com>
To: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: pg_upgrade error
Date: Mon, 7 Dec 2015 17:44:06 +0000
Message-ID: <ca0484351b28481081e5692ff824f7b9@MX002.symprod.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
CONFIDENTIALITY WARNING
This communication, including any attachments, is for the exclusive use of addressee and may contain proprietary and/or confidential information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.
AVERTISSEMENT RELATIF À LA CONFIDENTIALITÉ
Ce message, ainsi que les pièces qui y sont jointes, est destiné à l’usage exclusif de la personne à laquelle il s’adresse et peut contenir de l’information personnelle ou confidentielle. Si le lecteur de ce message n’en est pas le destinataire, nous l’avisons par la présente que toute diffusion, distribution, reproduction ou utilisation de son contenu est strictement interdite. Veuillez avertir sur-le-champ l’expéditeur par retour de courrier électronique et supprimez ce message ainsi que toutes les pièces jointes.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: YBarot@symcor.com
Subject: Re: pg_upgrade error
In-Reply-To: <ca0484351b28481081e5692ff824f7b9@MX002.symprod.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox