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. > > > postg...@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> > > > postg...@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.
