Olá, Flavio, O último log existente, do dia que deu problema está a seguir. Hoje não está criando novos logs.
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. Muito obrigado. Ronei ----- Original Message ----- From: "Flavio Henrique Araque Gurgel" <[email protected]> To: "Comunidade PostgreSQL Brasileira" <[email protected]> Sent: Friday, January 27, 2012 11:10 AM Subject: Re: [pgbr-geral]Banco de dados não inicia serviço > Coloquei a pasta global com a mesma estrutura, não é a mesma que estava no > dia que deu problema, mas de um backup de alguns dias antes. Mesmo assim, > o > serviço não iniciou. Qual o erro no log? > Há algo mais que se possa tentar? Com o erro podemos tentar ajudar ;) []s Flavio Gurgel _______________________________________________ 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
