[root@servidor2 9.1]# /usr/bin/psql -U postgres -d meubanco < /usr/share/postgresql/extension/metaphoneptbr--1.34.sql Use "CREATE EXTENSION pair" to load this file.
Em 7 de dezembro de 2015 07:49, Flavio Henrique Araque Gurgel < fha...@gmail.com> escreveu: > Boa noite, estou tentando instalar a extensão metaphoneptbr, mas sem >> sucesso abaixo segue o passo a passo >> >> >> >> [root@servidor2 9.1]# make all >> Makefile:16: aviso: impondo comandos para o alvo `clean' >> /usr/lib64/postgresql/pgxs/src/makefiles/pgxs.mk:208 >> <http://pgxs.mk:208>: aviso: ignorando comandos antigos para o alvo >> `clean' >> gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith >> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute >> -Wformat-security -fno-strict-aliasing -fwrapv -fpic -I. -I. >> -I/usr/include/postgresql/server -I/usr/include/postgresql/internal >> -D_GNU_SOURCE -c -o metaphoneptbr.o metaphoneptbr.c >> gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith >> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute >> -Wformat-security -fno-strict-aliasing -fwrapv -fpic -L/usr/lib64 >> -Wl,--as-needed -Wl,-rpath,'/usr/lib64',--enable-new-dtags -shared -o >> metaphoneptbr.so metaphoneptbr.o >> >> [root@servidor2 9.1]# make install >> Makefile:16: aviso: impondo comandos para o alvo `clean' >> /usr/lib64/postgresql/pgxs/src/makefiles/pgxs.mk:208 >> <http://pgxs.mk:208>: aviso: ignorando comandos antigos para o alvo >> `clean' >> /bin/mkdir -p '/usr/share/postgresql/extension' >> /bin/mkdir -p '/usr/share/postgresql/extension' >> /bin/mkdir -p '/usr/lib64/postgresql' >> /usr/bin/install -c -m 644 ./metaphoneptbr.control >> '/usr/share/postgresql/extension/' >> /usr/bin/install -c -m 644 ./metaphoneptbr--1.34.sql >> '/usr/share/postgresql/extension/' >> > > Note nesta linha o arquivo que foi criado. > > /usr/bin/install -c -m 755 metaphoneptbr.so '/usr/lib64/postgresql/' >> >> [root@servidor2 9.1]# /usr/bin/psql -U postgres -d meubanco >> psql (9.3.9) >> Type "help" for help. >> >> meubanco=# CREATE EXTENSION metaphoneptbr; -- *Pede um arquivo que não >> esta na versão de que baixei e compilei* >> ERROR: could not stat file >> "/usr/share/postgresql/extension/metaphoneptbr--1.36.sql": Arquivo ou >> diret▒rio n▒o encontrado >> meubanco=# >> >> meubanco=# CREATE EXTENSION metaphoneptbr with version '1.34'; -- >> *Informando a versão o erro muda* >> ERROR: could not access file "$libdir/metaphone_ptbr": Arquivo ou >> diret▒rio n▒o encontrado >> meubanco=# >> > > O que acontece se executar direto o script, sem CREATE EXTENSION: > /usr/bin/psql -U postgres meubanco < > /usr/share/postgresql/extension/metaphoneptbr--1.34.sql > > ? > > []s > Flavio Gurgel > > _______________________________________________ > pgbr-geral mailing list > pgbr-geral@listas.postgresql.org.br > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral