Suresh Gupta VG wrote:
I had recently upgraded my pgsql 7.4.2 to pgsql 8.2.5 on Solaris 9
Sparc machine. All the installation went normally as per install
documents of Postgresql. In between the installation, I got the
following error. But at the end I could create database and can use
the DB as normal.
-------
ERROR: incompatible library "/usr/lib/pgsql_clcrypt.so": missing magic
block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
STATEMENT: CREATE FUNCTION blowfish_encrypt(text, text) RETURNS text
AS '/usr/lib/pgsql_clcrypt.so', 'blowfish_encrypt'
LANGUAGE c;
...
-----------
This problem is coming with all the versions of PGSQL. We had a good
experience with similar error when we were upgraded with 7.4.2 long
back. Can you pls advice what to do to rectify this error in
Postgresql 8.2.5.
this does not look like a postgres bug to me.
Offhand, it looks like your database loads custom functions from the
shared object library /usr/lib/pgsql_clcrypt.so which was probably built
for your older 7.4... you'd either need to rebuild that library to be
8.2 compatible, or remove the CREATE FUNCTION statements that reference
it (and modify any SQL code you have which calls these
blowfish_encrypt() etc functions...)
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
