Re: How do I recover from>> pg_xlog/0000000000000000 (log

From: pw <p(dot)willis(at)telus(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How do I recover from>> pg_xlog/0000000000000000 (log
Date: 2004-10-19 22:49:04
Message-ID: 417599E0.7080405@telus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

>peter Willis <peterw(at)borstad(dot)com> writes:
>
>
>>[postgres(at)web2 /]$ LOG: database system shutdown was interrupted at
>>2004-10-18 11:41:55 PDT
>>LOG: open of /web2-disk1/grip/database/pg_xlog/0000000000000000 (log
>>file 0, segment 0) failed: No such file or directory
>>LOG: invalid primary checkpoint record
>>LOG: open of /web2-disk1/grip/database/pg_xlog/0000000000000000 (log
>>file 0, segment 0) failed: No such file or directory
>>LOG: invalid secondary checkpoint record
>>PANIC: unable to locate a valid checkpoint record
>>LOG: startup process (pid 2803) was terminated by signal 6
>>LOG: aborting startup due to startup process failure
>>
>>
>
>pg_resetxlog would probably get you to a point where you could start
>the server, but you should not have any great illusions about the
>consistency of your database afterward.
>
>How did you get into this state, anyway? And what PG version is it?
>
> regards, tom lane
>
>

The server was running with postgres on terabyte firewire 800 drive.
A tech decided to 'hot-plug' another terabyte drive into the system
without downing the server, umounting the first drive, and then remounting
both drives.
Since ohci drivers tend to enumerate and mount without using the
hardware ID of
the drive , the poor kernel got confused and decided that the new drive
was first in line....clang!

I had a database backup from the previous day. I just used that.

I set up a cron job to pg_dump and gzip every hour and
dump any backup gz files older than 1 week.
I love that 'date' command .. :)

date +%F-%H%M%S

nice............ :)

Peter

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roberts, Adam 2004-10-19 23:42:01 Re: Database Disappeared
Previous Message Josh Close 2004-10-19 22:35:14 Re: how much ram do i give postgres?