Pessoal,
to com problema pra subir meu banco,
meu ambiente é linux ,minha versao é 8.2
log do postgres referente ao erro:
2009-08-21 10:45:37 BRT ip= user= pid=4541 transacao= tag= LOG: database
system was interrupted at 2009-08-21 10:45:06 BRT
2009-08-21 10:45:37 BRT ip= user= pid=4541 transacao= tag= LOG: checkpoint
record is at DAF/ECFF1C80
2009-08-21 10:45:37 BRT ip= user= pid=4541 transacao= tag= LOG: redo
record is at DAF/ECFF1C80; undo record is at 0/0; shutdown TRUE
2009-08-21 10:45:37 BRT ip= user= pid=4541 transacao= tag= LOG: next
transaction ID: 6/2980385045; next OID: 909312
2009-08-21 10:45:37 BRT ip= user= pid=4541 transacao= tag= LOG: next
MultiXactId: 50725291; next MultiXactOffset: 144309558
2009-08-21
10:45:37 BRT ip= user= pid=4541 transacao= tag= LOG: database system
was not properly shut down; automatic recovery in progress
2009-08-21 10:45:37 BRT ip= user= pid=4541 transacao= tag= LOG: record with
zero length at DAF/ECFF1CD0
2009-08-21 10:45:37 BRT ip= user= pid=4541 transacao= tag= LOG: redo is not
required
2009-08-21 10:45:37 BRT ip= user= pid=4541 transacao= tag= FATAL: could not
access status of transaction 2980385045
2009-08-21 10:45:37 BRT ip= user= pid=4541 transacao= tag= DETAIL:
Could not read from file "pg_clog/0B1A" at offset 81920: Sucesso.
2009-08-21 10:45:37 BRT ip= user= pid=4539 transacao= tag= LOG: startup
process (PID 4541) exited with exit code 1
2009-08-21 10:45:37 BRT ip= user= pid=4539 transacao= tag= LOG: aborting
startup due to startup process failure
2009-08-21 10:45:37 BRT ip= user= pid=4540 transacao= tag= LOG: logger
shutting down
Achei o provavel erro no arquivo do pg_clog
-rw------- 1 postgres postgres 72K Ago 21 11:11 0B1A
que esta com tamanho inferior aos demais, como faço contorna este arquivo e
starta o banco sem maiores problemas.
att
____________________________________________________________________________________
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
