Thread: Pg_upgrade error urgent help
Hi All,
We are planning upgrade of postgresql database clusters with TB of data on hundreds of servers from postgresql 9.0.19(Rhel5) to postgresql 9.4(Rhel 7.1). But my POC is failing and giving error. I tried on sever, where there is no symlink created for tablespace. Only one data directory and custom tablespace is inside this data directory and it is still failing with bellow error:
/opt/symcor-foa/pgsql/data/pg_tblspc/federator/PG_9.0_201008051/7041482/11838
linking "/opt/symcor-foa/pgsql/data/pg_tblspc/federator/PG_9.0_201008051/7041482/11838" to "/opt/symcor-foa/pgsql/data/pg_tblspc/federator/PG_9.4_201409291/16423/13013"
error while creating link for relation "pg_catalog.pg_largeobject" ("/opt/symcor-foa/pgsql/data/pg_tblspc/federator/PG_9.0_201008051/7041482/11838" to "/opt/symcor-foa/pgsql/data/pg_tblspc/federator/PG_9.4_201409291/16423/13013"): No such file or directory
Any help will greatly appreciate. Due to size of data, we can’t do backup restore method, we must upgrade using pg_upgrade link option.
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.