Alguém teria alguma idéia? encontrei mais esse dado no arquivo de log?
2008-02-12 08:32:52 LOG: server process (PID 1604) exited with exit code -1073741819 Obrigado. Malcus escreveu: > Boa Tarde, > > Estava fazendo um dump da base de dados pelo PgAdmin e resultou no > seguinte problema: > > pg_dump: dumping contents of table tabela > pg_dump: Dumping the contents of table "tabela" failed: PQgetCopyData() > failed. > pg_dump: Error message from server: server closed the connection > unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > pg_dump: The command was: COPY public.tabela (campo1,campo2,campo3) TO > stdout; > pg_dump: *** aborted because of error > Process returned exit code 1. > > Porém o serviço do banco permanecia ativo. > Porém se fosse executado um comando com "SELECT campo1,campo2 FROM > public.tabela" da a seguinte no pg_log e o serviço desativa a ativa > novamente. > > > 2008-02-12 13:57:05 WARNING: terminating connection because of crash of > another server process > 2008-02-12 13:57:05 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. > 2008-02-12 13:57:05 HINT: In a moment you should be able to reconnect > to the database and repeat your command. > 2008-02-12 13:57:06 LOG: all server processes terminated; reinitializing > 2008-02-12 13:57:06 LOG: database system was interrupted at 2008-02-12 > 13:54:36 Hora oficial do Brasil > 2008-02-12 13:57:06 LOG: checkpoint record is at E/D13B6208 > 2008-02-12 13:57:06 LOG: redo record is at E/D135A8F8; undo record is > at 0/0; shutdown FALSE > 2008-02-12 13:57:06 LOG: next transaction ID: 0/1675210; next OID: 9969388 > 2008-02-12 13:57:06 LOG: next MultiXactId: 1; next MultiXactOffset: 0 > 2008-02-12 13:57:06 LOG: database system was not properly shut down; > automatic recovery in progress > 2008-02-12 13:57:06 LOG: redo starts at E/D135A8F8 > 2008-02-12 13:57:09 LOG: record with zero length at E/D2D88448 > 2008-02-12 13:57:09 LOG: redo done at E/D2D883F8 > 2008-02-12 13:57:26 FATAL: the database system is starting up > > > > Alguém já passou por essa situação? > > Windows 2003 Server > PostgreSQL 8.2.4 > > Obrigado > > > Malcus > _______________________________________________ > 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
