Hi Uwe! Uwe Steinmann [2005-10-13 10:48 +0200]: > I just realized that some of my old databases produce errors because > they still expect plpgsql.so at /usr/lib/postgresql/lib/ > > psql:semapp_upgrade_2.1-2.2_postgres.sql:3: ERROR: could not access > file "/usr/lib/postgresql/lib/plpgsql.so": Datei oder Verzeichnis nicht > gefunden > > Shouldn't the transition to 7.4 take care of such things?
It actually does care to adapt the path in postgresql.conf. Can you please check that "dynamic_library_path" in /etc/postgresql/7.4/main/postgresql.conf really points to the new location? It is much harder to actually adapt hardcoded path in the SQL data itself; the transition does not touch the SQL data, and it would not be right to change every path. However, since this seems to be a more common problem, I will just add a symbolic link to make the transition smoother. It will not be cleaned up automatically, but a single symbolic link does not hurt too bad either. Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org
signature.asc
Description: Digital signature
