Pessoal,
Estou tendo um problema durante a instalação da contrib xml2. Os passos que
eu executei foram os seguintes:
1 - Instalei a libxml2 (via yum) -> libxml2-devel.x86_64
2.6.26-2.1.2.8.el5_5.1 installed
2 - Compilei o postgres com a opção --with-libxml (depois: make e make
install)
3 - Compilei a contrib (em /contrib/xml2 com make e make install) a extensão
foi adicionada na pasta $libdir (/usr/local/pgsql/lib)
4 - Ao Executar o comando de instalação da contrib: psql -f
/usr/local/pgsql/share/contrib/pgxml.sql -d teste1
Recebo o seguinte erro:
--------------------------------------------------------------------------------
SET
psql:pgxml.sql:10: ERROR: could not load library
"/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined
symbol: xml_ereport
psql:pgxml.sql:15: ERROR: could not load library
"/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined
symbol: xml_ereport
psql:pgxml.sql:19: ERROR: could not load library
"/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined
symbol: xml_ereport
psql:pgxml.sql:23: ERROR: could not load library
"/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined
symbol: xml_ereport
psql:pgxml.sql:27: ERROR: could not load library
"/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined
symbol: xml_ereport
psql:pgxml.sql:31: ERROR: could not load library
"/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined
symbol: xml_ereport
psql:pgxml.sql:35: ERROR: could not load library
"/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined
symbol: xml_ereport
psql:pgxml.sql:41: ERROR: could not load library
"/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined
symbol: xml_ereport
psql:pgxml.sql:45: ERROR: function xpath_list(text, text, unknown) does not
exist
LINE 2: AS 'SELECT xpath_list($1,$2,'','')'
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
psql:pgxml.sql:52: ERROR: function xpath_nodeset(text, text, unknown,
unknown) does not exist
LINE 3: AS 'SELECT xpath_nodeset($1,$2,'''','''')'
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
psql:pgxml.sql:57: ERROR: function xpath_nodeset(text, text, unknown, text)
does not exist
LINE 3: AS 'SELECT xpath_nodeset($1,$2,'''',$3)'
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
psql:pgxml.sql:64: ERROR: could not load library
"/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined
symbol: xml_ereport
psql:pgxml.sql:71: ERROR: could not load library
"/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined
symbol: xml_ereport
psql:pgxml.sql:77: ERROR: could not load library
"/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined
symbol: xml_ereport
--------------------------------------------------------------------------------
Perguntas:
I - Alguma coisa errada com os procedimentos executados?
II - O xml_ereport (mostrado no erro) está em algum outro módulo que eu
necessito instalar?
III - A versão da libxml2 está correta ou devo atualizá-la?
--------------------------------------------------------------------------------
-bash-3.2$ cat /proc/version
Linux version 2.6.18-238.9.1.el5xen ([email protected]) (gcc
version 4.1.2 20080704 (Red Hat 4.1.2-50)) #1 SMP Tue Apr 12 18:53:56 EDT
2011
-bash-3.2$ psql -c 'select version();'
PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20080704 (Red Hat 4.1.2-50), 64-
bit
(1 row)
--------------------------------------------------------------------------------
De já agradeço!
--
*Marcone Peres - DBA*
http://www.linkedin.com/in/marconeperes
*(61) 8146-0028*
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
