Re: [URGENT] Problems recovering database - Mailing list pgsql-admin

From Björn Metzdorf
Subject Re: [URGENT] Problems recovering database
Date
Msg-id 000f01c31a5b$fa923da0$0564a8c0@shock
Whole thread Raw
In response to [URGENT] Problems recovering database  (Bruno Mattarollo <bruno@web1.greenpeace.org>)
Responses Re: [URGENT] Problems recovering database
List pgsql-admin
> It complains
>
> DEBUG:  open of /usr2/pgsql/data/pg_xlog/0000000000000000 (log file 0,
> segment 0) failed: No such file or directory
> DEBUG:  invalid primary checkpoint record
> DEBUG:  open of /usr2/pgsql/data/pg_xlog/0000000000000000 (log file 0,
> segment 0) failed: No such file or directory
> DEBUG:  invalid secondary checkpoint record
>
> But these files were not present in the 'data' directory from this
> server, only these:
>
> $ ls
> 00000010000000B7  00000010000000B8  00000010000000B9  00000010000000BA
> 00000010000000BB  00000010000000BC  00000010000000BD  00000010000000BE
>
> Any ideas on how should I proceed?

try pg_resetxlog from contrib.

Regards,
Bjoern


pgsql-admin by date:

Previous
From: Bruno Mattarollo
Date:
Subject: [URGENT] Problems recovering database
Next
From: Bruno Mattarollo
Date:
Subject: Re: [URGENT] Problems recovering database