#1 Installation on Postgres 8.3 Doesn't work

[Anonymous]

Hi, When I compile and try and install this on Pg8.3 I get the following error :

< ./configure went AOK>

[root@server1 pgsendmail-1.6]# make all
make all-am
make[1]: Entering directory `/root/packages/postgres/pgsendmail/pgsendmail-1.6'
make[1]: Leaving directory `/root/packages/postgres/pgsendmail/pgsendmail-1.6'
Dexdyne [root@server1 pgsendmail-1.6]# make install
make[1]: Entering directory `/root/packages/postgres/pgsendmail/pgsendmail-1.6'
test -z "/usr/lib/pgsql" || mkdir -p -- "/usr/lib/pgsql"
/bin/sh ./libtool --mode=install /usr/bin/install -c 'libpgmail.la' '/usr/lib/pgsql/libpgmail.la'
/usr/bin/install -c .libs/libpgmail.so.1.0.6 /usr/lib/pgsql/libpgmail.so.1.0.6
(cd /usr/lib/pgsql && { ln -s -f libpgmail.so.1.0.6 libpgmail.so.1 || { rm -f libpgmail.so.1 && ln -s libpgmail.so.1.0.6 libpgmail.so.1; }; })
(cd /usr/lib/pgsql && { ln -s -f libpgmail.so.1.0.6 libpgmail.so || { rm -f libpgmail.so && ln -s libpgmail.so.1.0.6 libpgmail.so; }; })
/usr/bin/install -c .libs/libpgmail.lai /usr/lib/pgsql/libpgmail.la
/usr/bin/install -c .libs/libpgmail.a /usr/lib/pgsql/libpgmail.a
chmod 644 /usr/lib/pgsql/libpgmail.a
ranlib /usr/lib/pgsql/libpgmail.a
PATH="$PATH:/sbin" ldconfig -n /usr/lib/pgsql
----------------------------------------------------------------------
Libraries have been installed in:
/usr/lib/pgsql

If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the `-LLIBDIR'
flag during linking and do at least one of the following:
- add LIBDIR to the `LD_LIBRARY_PATH' environment variable
during execution
- add LIBDIR to the `LD_RUN_PATH' environment variable
during linking
- use the `-Wl,--rpath -Wl,LIBDIR' linker flag
- have your system administrator add LIBDIR to `/etc/ld.so.conf'

See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------
/usr/bin/install -c -m 644 mail.sql /usr/share/pgsql
Please run '/usr/bin/psql < /usr/share/pgsql/mail.sql' to install function
make[1]: Leaving directory `/root/packages/postgres/pgsendmail/pgsendmail-1.6'
[root@server1 pgsendmail-1.6]# su -l postgres
-bash-3.00$ /usr/bin/psql < /usr/share/pgsql/mail.sql
ERROR: incompatible library "/usr/lib/pgsql/libpgmail.so": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
ERROR: function mail(character varying, character varying, character varying, character varying) does not exist
ERROR: incompatible library "/usr/lib/pgsql/libpgmail.so": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
WARNING: nonstandard use of escape in a string literal
LINE 1: ...il(CURRENT_USER || '@localhost','Test pgsendmail','Test is O...
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
ERROR: function mail(text, unknown, text, unknown) does not exist
LINE 1: SELECT mail(CURRENT_USER || '@localhost','Test pgsendmail','...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

-bash-3.00$ psql --version
psql (PostgreSQL) 8.3.0