Re: "FATAL: role "postgres" does not exist" after recover

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: "FATAL: role "postgres" does not exist" after recover
Date: 2011-07-17 11:19:12
Message-ID: 4E22C530.9050909@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 17/07/2011 5:19 PM, AI Rumman wrote:
> I am using database Postgresql 9.0.1.
>
> For some reasons, my database was crashed.
> At first I found:
> DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 0,
> but the server was compiled with PG_CONTROL_VERSION 903.

First, read and act on this:

http://wiki.postgresql.org/wiki/Corruption

--
Craig Ringer

POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris McCormick 2011-07-17 11:44:00 Error in restoring a large object
Previous Message AI Rumman 2011-07-17 09:19:19 "FATAL: role "postgres" does not exist" after recover