pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Ooops ! :( Recovery techniques
2+ messages / 2 participants
[nested] [flat]

* Ooops ! :( Recovery techniques
@ 2003-12-01 04:41  Richard Sydney-Smith <richard@ibisaustralia.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Richard Sydney-Smith @ 2003-12-01 04:41 UTC (permalink / raw)
  To: pgsql-sql

My machine just crashed in the middle of an update.

When I restart the postgresql server the database engine appears ok and then tells me that a file /data/pg_clog/0697 is not there. 

I presume that these are the transaction log files. 
I would like to truncate the old logfiles, re-index and keep going.
I that possible with postgres of do I have to do a full rebuild?

thanks verymuch

Richard Sydney-Smith

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Ooops ! :( Recovery techniques
@ 2003-12-02 16:25  Christoph Haller <ch@rodos.fzk.de>
  parent: Richard Sydney-Smith <richard@ibisaustralia.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Christoph Haller @ 2003-12-02 16:25 UTC (permalink / raw)
  To: richard@ibisaustralia.com; +Cc: pgsql-sql

> 
> My machine just crashed in the middle of an update.
> 
> When I restart the postgresql server the database engine appears ok and the=
> n tells me that a file /data/pg_clog/0697 is not there.=20
> 
> I presume that these are the transaction log files.=20
> I would like to truncate the old logfiles, re-index and keep going.
> I that possible with postgres of do I have to do a full rebuild?
> 
> thanks verymuch
> 
> Richard Sydney-Smith
> 
> 
Sorry, your presumption is wrong. In contrary to what the name might 
suggest this file is not a log file at all. 
Your dbase is probably seriously damaged. 
If you haven't made a dbase dump using "pg_dump" before, 
you'd better do that full rebuild you mentioned. 

Regards, Christoph 

PS I recommend to read the chapter 'Backup and Restore' of the 
fine manual to be prepared when your machine crashes again. 




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2003-12-02 16:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-12-01 04:41 Ooops ! :( Recovery techniques Richard Sydney-Smith <richard@ibisaustralia.com>
2003-12-02 16:25 ` Christoph Haller <ch@rodos.fzk.de>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox