Olá, Em 25 de janeiro de 2012 14:53, Ronei Heck <[email protected]>escreveu:
> Olá, Juliano, > > O log do último dia que funcionou e deu problema está a seguir: > > 2011-12-25 15:52:35 BRT LOG: database system was shut down at 2011-12-24 > 19:55:20 BRT > 2011-12-25 15:52:35 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-12-25 15:52:35 BRT FATAL: the database system is starting up > 2011-12-25 15:52:35 BRT LOG: database system is ready to accept > connections > 2011-12-25 15:52:36 BRT LOG: autovacuum launcher started > 2011-12-25 15:52:36 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-12-25 15:57:19 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-12-25 15:58:14 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-12-25 15:58:27 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-12-25 15:58:34 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-12-25 15:58:40 BRT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > 2011-12-25 19:56:14 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:56:20 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:35 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:36 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:36 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:37 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:38 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:38 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:39 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:39 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:40 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:41 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:41 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:42 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:42 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:43 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:44 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:44 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:45 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:45 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:46 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:47 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:47 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:48 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:49 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:49 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:50 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:50 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:51 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:52 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:52 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:53 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:53 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:54 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:55 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:55 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:56 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:56 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:57 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:58 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:59 BRT PANIC: could not fsync control file: Bad file > descriptor > > > This application has requested the Runtime to terminate it in an unusual > way. > Please contact the application's support team for more information. > > 2011-12-25 19:57:59 BRT LOG: background writer process (PID 2960) exited > with exit code 3 > 2011-12-25 19:57:59 BRT LOG: terminating any other active server processes > 2011-12-25 19:57:59 BRT WARNING: terminating connection because of crash > of > another server process > 2011-12-25 19:57:59 BRT DETAIL: The postmaster has commanded this server > process to roll back the current transaction and exit, because another > server process exited abnormally and possibly corrupted shared memory. > 2011-12-25 19:57:59 BRT HINT: In a moment you should be able to reconnect > to the database and repeat your command. > 2011-12-25 19:57:59 BRT WARNING: terminating connection because of crash > of > another server process > 2011-12-25 19:57:59 BRT DETAIL: The postmaster has commanded this server > process to roll back the current transaction and exit, because another > server process exited abnormally and possibly corrupted shared memory. > 2011-12-25 19:57:59 BRT HINT: In a moment you should be able to reconnect > to the database and repeat your command. > 2011-12-25 19:57:59 BRT WARNING: terminating connection because of crash > of > another server process > 2011-12-25 19:57:59 BRT DETAIL: The postmaster has commanded this server > process to roll back the current transaction and exit, because another > server process exited abnormally and possibly corrupted shared memory. > 2011-12-25 19:57:59 BRT HINT: In a moment you should be able to reconnect > to the database and repeat your command. > 2011-12-25 19:57:59 BRT LOG: could not open temporary statistics file > "global/pgstat.tmp": No such file or directory > 2011-12-25 19:57:59 BRT LOG: all server processes terminated; > reinitializing > 2011-12-25 19:58:00 BRT FATAL: pre-existing shared memory block is still > in > use > 2011-12-25 19:58:00 BRT HINT: Check if there are any old server processes > still running, and terminate them. > Alguma queda de energia? Desligamento abrupto do PostgreSQL? > > Muito obrigado. > > Ronei > > > ----- Original Message ----- > From: "Juliano Benvenuto Piovezan" <[email protected]> > To: "Comunidade PostgreSQL Brasileira" < > [email protected]> > Sent: Wednesday, January 25, 2012 12:39 PM > Subject: Re: [pgbr-geral]Banco de dados não inicia serviço > > > 2012/1/25 Ronei Heck <[email protected]>: > > Senhores(as), > > > > Tenho um banco de dados de um cliente que não quer abrir. Acredito que > > esteja corrompido. Tenho o Postgres 8.3 instalado, e com a minha pasta > > \data > > normal, inicia o serviço e abre normalmente. Mas quando paro o serviço, > > troco a pasta \data pela do meu cliente, e tento iniciar o serviço, ele > > não > > inicia, fica pondo pontinhos na tela indefinidamente. > > > > Necessito pegar as vendas de um período pra passar para o cliente. Estas > > ficaram fora do backup que já foi restaurado lá. Então, pergunto: existem > > uma forma de acessar este banco de dados? Quais os passos que devo > seguir? > > Existe algum tutorial que ensine os passos? > > > > Muito obrigado por qualquer ajuda. > > > > Antes de mais nada, veja os logs do servidor se há alguma informação > que possa auxiliar. Podem ter ocorrido inúmeros fatos que estejam > acarretando esse comportamento, com os logs fica mais fácil > identificar. > _______________________________________________ > 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 > Abraços -- JotaComm http://jotacomm.wordpress.com
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
