Olá, JotaComm, Sim, houve uma queda de energia.
Obrigado. Ronei ----- Original Message ----- From: JotaComm To: Comunidade PostgreSQL Brasileira Sent: Wednesday, January 25, 2012 1:11 PM Subject: Re: [pgbr-geral]Banco de dados não inicia serviço 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
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
