Senhores, bom dia...
Ao consultar o log de uma base 8.3 em Windows, notei várias ocorrências do seguinte erro: %t ERROR: column "buffers_backend_fsync" does not exist at character 8 %t STATEMENT: select buffers_backend_fsync from pg_stat_bgwriter %t ERROR: column "state" does not exist at character 14 %t STATEMENT: select count(state) from pg_stat_activity where state = 'active' %t ERROR: column "state" does not exist at character 14 %t STATEMENT: select count(state) from pg_stat_activity where state = 'idle' %t ERROR: column "state" does not exist at character 14 %t STATEMENT: select count(state) from pg_stat_activity where state = 'idle in transaction' %t ERROR: column "state" does not exist at character 45 %t STATEMENT: select count(*) from pg_stat_activity where state = 'active' and now() - query_start > '10 sec'::interval and query ~* '^(insert|update|delete)' %t ERROR: column "state" does not exist at character 45 %t STATEMENT: select count(*) from pg_stat_activity where state = 'active' and now() - query_start > '10 sec'::interval Ao se deparar com o mesmo problema em um banco da mesma versão só que instalado em CentOS, realizei a instalação do postgresql-contrib e criei a extensão no database. Como posso solucionar essa questão? Att, Julio Romano.
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
