Em 3 de novembro de 2017 10:52, Flavio Henrique Araque Gurgel < fha...@gmail.com> escreveu:
> > > Em sex, 3 de nov de 2017 às 13:44, Neto pr <neto...@gmail.com> escreveu: > >> Daniel, >> sim estava no diretorio /etc/postgresql. Sempre instalei compilando os >> fontes, por isso me perdi nessa. >> >> Outro problema que está ocorrendo com este parametro do postgresql.conf >> >> shared_preload_libraries = 'pg_stat_statements, powa, pg_stat_kcache, >> pg_qualstats' >> >> Ao colocar as duas bibliotecas abaixo o SGBD não sobe. Ja tentei colocar >> somente 1 delas, mas realmente as duas dão erro. >> - pg_stat_kcache >> - pg_qualstats >> >> > Se alguém tiver alguma dica, será bem vinda. >> > > Eu tenho duas dicas: > Dica 1 - pare de fazer top post, você não é mais novato > OK, Sobre top post, mal ha'bito > Dica 2 - mande a mensagem de erro que sai > > Vi no log que nao estava encontrando as bibliotecas. Apos isso, instalei os pacote conforme tutorial abaixo e mesmo assim nao encontrava. Entao copiei e colei na pasta /usr/lib/postgresql/9.6/lib/ as bibliotecas (arquivos *.so). Agora o erro que ocorre e' que a de versao incompativel, ou seja, versao do SGBD e' 9.6 e a biblioteca e' da versao 10.0. O estranho e' que segui o tutuorial e o link que passaram estava informando que era da versao 9.6, vejam o link do arquivo o log de erro. Ja a outra biblioteca da erro de copy symbol. ====================== Log erro ==================== 2017-11-03 12:00:44.445 BRST [1610] FATAL: could not access file "pg_stat_kcache": No such file or directory 2017-11-03 12:00:44.445 BRST [1610] LOG: database system is shut down 2017-11-03 12:14:52.216 BRST [1672] FATAL: incompatible library "/usr/lib/postgresql/9.6/lib/pg_stat_kcache.so": version mismatch 2017-11-03 12:14:52.216 BRST [1672] DETAIL: Server is version 9.6, library is version 10.0. 2017-11-03 12:14:52.216 BRST [1672] LOG: database system is shut down 2017-11-03 12:18:56.311 BRST [1729] FATAL: could not load library "/usr/lib/postgresql/9.6/lib/pg_qualstats.so": /usr/lib/postgresq l/9.6/lib/pg_qualstats.so: undefined symbol: copyObjectImpl 2017-11-03 12:18:56.311 BRST [1729] LOG: database system is shut down 2017-11-03 12:27:10.895 BRST [1799] FATAL: incompatible library "/usr/lib/postgresql/9.6/lib/pg_stat_kcache.so": version mismatch 2017-11-03 12:27:10.895 BRST [1799] DETAIL: Server is version 9.6, library is version 10.0. 2017-11-03 12:27: ==================================================== ------------------------------------------------------ PoWA Documentation, Release 3.1.0 On Debian: apt-get install postgresql-server-dev-9.6 postgresql-contrib-9.6 Installation Download powa-archivist latest release: wget https://github.com/dalibo/powa-archivist/archive/REL_3_1_0.tar.gz A convenience script is offered to build every project that PoWA can take advantage of: #!/bin/bash # This script is meant to install every PostgreSQL extension compatible with # PoWA. ------------------> AQUUIII ---> wget https://github.com/dalibo/pg_qualstats/archive/1.0.2.tar.gz -O pg_ ˓ → qualstats-1.0.2.tar.gz tar zxvf pg_qualstats-1.0.2.tar.gz cd pg_qualstats-1.0.2 (make && sudo make install) > /dev/null 2>&1 cd .. rm pg_qualstats-1.0.2.tar.gz rm pg_qualstats-1.0.2 -rf ------------------> AQUUIII ---> wget https://github.com/dalibo/pg_stat_kcache/archive/REL2_0_3.tar.gz -O pg_ ˓ → stat_kcache-REL2_0_3.tar.gz tar zxvf pg_stat_kcache-REL2_0_3.tar.gz cd pg_stat_kcache-REL2_0_3 (make && sudo make install) > /dev/null 2>&1 cd .. rm pg_stat_kcache-REL2_0_3.tar.gz rm pg_stat_kcache-REL2_0_3 -rf (make && sudo make install) > /dev/null 2>&1 echo "" echo "You should add the following line to your postgresql.conf:" echo '' echo "shared_preload_libraries='pg_stat_statements,powa,pg_stat_kcache,pg_ ˓ → ============================== FIM ====================================== > Aí a gente vem com mais dicas quentinhas. > > []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
