[OPEN-ILS-DEV] xml_ereport undefined (was Re: Problem installing Evergreen 1.6.0.6)

[Dan Scott]

On Sat, 2010-07-03 at 23:40 +0800, Pravin Nowbuth wrote:
> Hi all,
> 
> I trying to install evergreen on Debian Lenny. I am getting the
> following error for the command given below.
> 
> 
> postgres at debian:~$ psql -f /usr/share/postgresql/8.3/contrib/pgxml.sql
> -d evergreen
> SET
> psql:/usr/share/postgresql/8.3/contrib/pgxml.sql:10: ERROR:  could not
> load library "/usr/lib/postgresql/8.3/lib/pgxml.so":

</snip>

> 
> 
> postgres at debian:~$ psql -c 'select version();'
>                                            version
> ----------------------------------------------------------------------------------------------
>  PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real
> (Debian 4.3.2-1.1) 4.3.2
> (1 row)
> 
> 
> 
> What could be the problem?

Hmm. Your server is reporting PostgreSQL 8.3.7, but the current version
of PostgreSQL listed for Debian Lenny is 8.3.11:
http://packages.debian.org/lenny/postgresql-8.3

One of the changes between 8.3.7 and 8.3.10 was the addition of a new
xml_ereport() function:
http://release.debian.org/proposed-updates/stable_diffs/postgresql-8.3_8.3.10-0lenny1.debdiff

My guess is that you already had PostgreSQL server on a fresh install of
Debian Lenny (running at 8.3.7), then updated your package list and
installed the PostgreSQL contrib file at the 8.3.11 level.

If you run (as root):

aptitude update && aptitude safe-upgrade

and then restart PostgreSQL:

/etc/init.d/postgresql restart

psql -c 'select version();' should show you 8.3.11 and you should be
able to get through these steps.

In theory, anyway.