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
