Rode um: reindexdb -s postgres E mandar os logs gerados neste período. Veja se as coisas se normalizam.
Se o postgres cair antes de concluir o teste, você vai ter de subir o postgres sem utilizar os índices do catálogo, com a opção -P. Aí começa a complicar um pouco... Veja no log que houve uma queda abrupta por aí: 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 Por outro lado, parece que outra pessoa já andou tentando um REINDEX por aí, não? Foi você mesmo? Outra pessoa já andou tentando algo? []s 2011/6/29 emerson lopes <emerson.pal...@gmail.com> > > 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 <fabio.tel...@gmail.com> > escreveu: >> >> Em 29 de junho de 2011 09:35, emerson lopes <emerson.pal...@gmail.com> >> 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 >>>> 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 >>> >> >> >> >> -- >> Atenciosamente, >> Fábio Telles Rodriguez >> blog: http://www.midstorm.org/~telles/ >> e-mail / gtalk / MSN: fabio.tel...@gmail.com >> Skype: fabio_telles >> >> _______________________________________________ >> 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 > -- Atenciosamente, Fábio Telles Rodriguez blog: http://www.midstorm.org/~telles/ e-mail / gtalk / MSN: fabio.tel...@gmail.com Skype: fabio_telles _______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
