Re: Postgresql 9.4 pg_upgrade issues - Mailing list pgsql-admin
From | Yogi Barot |
---|---|
Subject | Re: Postgresql 9.4 pg_upgrade issues |
Date | |
Msg-id | 622de7fb272e489292d5e6b41ae44c29@MX002.symprod.com Whole thread Raw |
In response to | Re: Postgresql 9.4 pg_upgrade issues (Albe Laurenz <laurenz.albe@wien.gv.at>) |
Responses |
Re: Postgresql 9.4 pg_upgrade issues
(Bruce Momjian <bruce@momjian.us>)
|
List | pgsql-admin |
Hi, I was able to manage upgrade testing with cluster which does not have plsh for now. But I have another problem. All my data TB is in the tablespace in PGData directory, I did the upgrade using link method,now I got this warning. Upgrade Complete ---------------- Optimizer statistics are not transferred by pg_upgrade so, once you start the new server, consider running: analyze_new_cluster.sh Could not create a script to delete the old cluster's data files because user-defined tablespaces exist in the old cluster directory. The old cluster's contents must be deleted manually. 1) Does This means , I can't delete old cluster data directory? Or I can delete it manually? 2) Deleting old data directory will effect any functionality of postgresql new cluster? 3) Also Need some clarification on link mode, what if I upgrade from 9.5. to future release using pg_upgarde link mode willstill work on same data directory? Thanks, Yogi -----Original Message----- From: Albe Laurenz [mailto:laurenz.albe@wien.gv.at] Sent: Tuesday, November 24, 2015 11:26 AM To: Yogi Barot; 'pgsql-admin@postgresql.org' Subject: RE: Postgresql 9.4 pg_upgrade issues Yogi Barot wrote: > I am running postgresql upgrade from postgresql 9.0.11 to postgresql > 9.4 using pg_upgrade link method and having some issues with upgrade on Reh hat 7.1. > > Here is the error message, that I am getting via pg_upgrade: > > /usr/pgsql-9.4/bin/pg_upgrade --old-bindir=/usr/local/pgsql/bin > --new-bindir=/usr/pgsql-9.4/bin --old- datadir=/opt/symcor-foa/data > --new-datadir=/opt/symcor-foa/data94 -v --user=pg_foa_c --link -p > 5432 -P 5433 > > cat loadable_libraries.txt > Could not load library "/opt/symcor-foa/pgsql//lib/pgplsh/pgplsh.so" > ERROR: could not load library > "/opt/symcor-foa/pgsql//lib/pgplsh/pgplsh.so": /opt/symcor- > foa/pgsql//lib/pgplsh/pgplsh.so: undefined symbol: DirectFunctionCall1 > > In the original cluster, I have removed function and language which > reference this library, I also took postgres dump using pg_dumpall and > it does not show any reference to this library plsh. Still pg_upgarde somehow reference this library. > > Any help greatly appricaited as I am stuck here, can not build library > on new Rhel 7 cluster, we don’t need library, but not sure how to > remove the reference of it completely. I dropped from all databases > and even from template1 database using droplib plsh; I guess you failed to remove PL/sh in the original cluster. Did you try the following in all databases: DROP LANGUAGE plsh CASCADE; DROP FUNCTION plsh_handler(); DROP FUNCTION plsh_validator(oid); Yours, Laurenz Albe CONFIDENTIALITY WARNING This communication, including any attachments, is for the exclusive use of addressee and may contain proprietary and/or confidentialinformation. If you are not the intended recipient, any use, copying, disclosure, dissemination or distributionis strictly prohibited. If you are not the intended recipient, please notify the sender immediately by returne-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’adresseet 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 contenuest strictement interdite. Veuillez avertir sur-le-champ l’expéditeur par retour de courrier électronique et supprimezce message ainsi que toutes les pièces jointes.
pgsql-admin by date: