Segue abaixo:
2011-06-29 03:50:05 BRT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-06-29 03:50:05 BRT FATAL: the database system is starting up 2011-06-29 03:50:05 BRT LOG: database system was interrupted; last known up at 2011-06-29 03:48:17 BRT 2011-06-29 03:50:05 BRT LOG: database system was not properly shut down; automatic recovery in progress 2011-06-29 03:50:05 BRT LOG: record with zero length at B8/CB5C4708 2011-06-29 03:50:05 BRT LOG: redo is not required 2011-06-29 03:50:06 BRT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-06-29 03:50:06 BRT FATAL: the database system is starting up 2011-06-29 03:50:07 BRT LOG: database system is ready to accept connections 2011-06-29 03:50:07 BRT LOG: autovacuum launcher started 2011-06-29 03:50:07 BRT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-06-29 07:01:12 BRT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-06-29 07:01:13 BRT FATAL: index "pg_class_oid_index" contains unexpected zero page at block 0 2011-06-29 07:01:13 BRT HINT: Please REINDEX it. 2011-06-29 07:01:56 BRT ERROR: index "pg_class_oid_index" contains unexpected zero page at block 0 2011-06-29 07:01:56 BRT HINT: Please REINDEX it. 2011-06-29 07:02:56 BRT ERROR: index "pg_class_oid_index" contains unexpected zero page at block 0 2011-06-29 07:02:56 BRT HINT: Please REINDEX it. 2011-06-29 07:03:56 BRT ERROR: index "pg_class_oid_index" contains unexpected zero page at block 0 2011-06-29 07:03:56 BRT HINT: Please REINDEX it. 2011-06-29 07:04:20 BRT LOG: received fast shutdown request 2011-06-29 07:04:20 BRT LOG: aborting any active transactions 2011-06-29 07:04:20 BRT LOG: autovacuum launcher shutting down 2011-06-29 07:04:20 BRT LOG: shutting down 2011-06-29 07:04:20 BRT LOG: database system is shut down 2011-06-29 03:24:09 BRT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-06-29 03:24:10 BRT FATAL: the database system is starting up 2011-06-29 03:24:10 BRT LOG: database system was interrupted; last known up at 2011-06-28 18:56:43 BRT 2011-06-29 03:24:10 BRT LOG: database system was not properly shut down; automatic recovery in progress 2011-06-29 03:24:10 BRT LOG: record with zero length at B8/C3409208 2011-06-29 03:24:10 BRT LOG: redo is not required 2011-06-29 03:24:11 BRT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-06-29 03:24:11 BRT FATAL: the database system is starting up 2011-06-29 03:24:12 BRT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-06-29 03:24:12 BRT FATAL: the database system is starting up 2011-06-29 03:24:12 BRT LOG: database system is ready to accept connections 2011-06-29 03:24:12 BRT LOG: autovacuum launcher started 2011-06-29 03:24:13 BRT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-06-29 03:25:33 BRT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-06-29 03:25:59 BRT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-06-29 03:26:14 BRT WARNING: index "pg_statistic_relid_att_index" contains 1853 row versions, but table contains 1937 row versions 2011-06-29 03:26:14 BRT HINT: Rebuild the index with REINDEX. 2011-06-29 03:26:14 BRT WARNING: index "pg_statistic_relid_att_index" contains 1853 row versions, but table contains 1937 row versions 2011-06-29 03:26:14 BRT HINT: Rebuild the index with REINDEX. 2011-06-29 03:26:17 BRT WARNING: index "id_acerto" contains 2832 row versions, but table contains 3011 row versions 2011-06-29 03:26:17 BRT HINT: Rebuild the index with REINDEX. 2011-06-29 03:26:17 BRT WARNING: index "id_acerto" contains 2832 row versions, but table contains 3011 row versions 2011-06-29 03:26:17 BRT HINT: Rebuild the index with REINDEX. 2011-06-29 03:27:33 BRT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-06-29 03:28:19 BRT NOTICE: table "pg_class" was reindexed 2011-06-29 03:28:19 BRT NOTICE: table "sql_features" was reindexed 2011-06-29 03:28:19 BRT NOTICE: table "sql_implementation_info" was reindexed 2011-06-29 03:28:19 BRT ERROR: could not create unique index "pg_statistic_relid_att_index" 2011-06-29 03:28:19 BRT DETAIL: Table contains duplicated values. 2011-06-29 03:28:19 BRT STATEMENT: reindex database postgres 2011-06-29 03:28:19 BRT WARNING: index "pg_statistic_relid_att_index" contains 1853 row versions, but table contains 1937 row versions 2011-06-29 03:28:19 BRT HINT: Rebuild the index with REINDEX. 2011-06-29 03:28:19 BRT WARNING: index "pg_statistic_relid_att_index" contains 1853 row versions, but table contains 1937 row versions 2011-06-29 03:28:19 BRT HINT: Rebuild the index with REINDEX. 2011-06-29 03:28:19 BRT WARNING: index "id_acerto" contains 2832 row versions, but table contains 3011 row versions 2011-06-29 03:28:19 BRT HINT: Rebuild the index with REINDEX. 2011-06-29 03:28:42 BRT NOTICE: table "pg_class" was reindexed 2011-06-29 03:28:42 BRT NOTICE: table "sql_features" was reindexed 2011-06-29 03:28:42 BRT NOTICE: table "sql_implementation_info" was reindexed 2011-06-29 03:28:42 BRT ERROR: could not create unique index "pg_statistic_relid_att_index" 2011-06-29 03:28:42 BRT DETAIL: Table contains duplicated values. 2011-06-29 03:28:42 BRT STATEMENT: reindex database postgres Em 29 de junho de 2011 09:44, Fábio Telles Rodriguez <[email protected] > escreveu: > Em 29 de junho de 2011 09:35, emerson lopes > <[email protected]>escreveu: > >> Opa Bruno! >> >> Esse banco em específico é 8.3 e o PGADMIN é 1.8.4. >> >> Realmente não sei como refazer o índice! Se puder me ajudar, fico grato, >> > > Bom, o problema parece estar no banco de dados, não no pgadmin. Mas isso é > fácil de verificar, já tentou se conectar com o psql do próprio servidor > onde o postgres está instalado? > > Tem como mandar o log do postgres? > > Se você estiver perdido, inseguro e esta base for importante, recomendo > contratar um DBA. Dependendo do que você fizer, você pode piorar a situação. > Se não for importante, mande o log e a gente vê se consegue lhe ajudar. > >> >> Emerson >> >> escreveu: >> >>> >>> > Senhores, >>> > >>> > Estou com o seguinte erro no meu banco de dados. Alguem pode me dar uma >>> luz >>> > ? Obs.: Não estou conseguindo acessar o PGADMIN, como proceder ? >>> > >>> > >>> > index "pg_class_oid_index" contains unexpected zero page at block 0 >>> > >>> > >>> > Obrigado, >>> > >>> > Emerson Lopes >>> >>> _______________________________________________ >>> pgbr-geral mailing list >>> [email protected] >>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>> >>> >> >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> > > > -- > Atenciosamente, > Fábio Telles Rodriguez > blog: http://www.midstorm.org/~telles/ > e-mail / gtalk / MSN: [email protected] > Skype: fabio_telles > > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > >
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
