Re: [URGENT] Problems recovering database

From: Björn Metzdorf <bm(at)turtle-entertainment(dot)de>
To: "Bruno Mattarollo" <bruno(at)web1(dot)greenpeace(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [URGENT] Problems recovering database
Date: 2003-05-14 21:01:22
Message-ID: 000f01c31a5b$fa923da0$0564a8c0@shock
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-05-14 21:40:16 Re: [URGENT] Problems recovering database
Previous Message Bruno Mattarollo 2003-05-14 20:42:00 Re: [URGENT] Problems recovering database