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

Started by AI Rummanover 14 years ago2 messagesgeneral
Jump to latest
#1AI Rumman
rummandba@gmail.com

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.

I solved it by copying pg_control from a new cluster

Then I got,
FATAL: could not open directory "pg_notify": Not a directory

Same thing I did here.

Now the db is up. But I can't connect to the db.
It says,
FATAL: role "postgres" does not exist

No roles in the db.
When I use createuser it says the same.

Any idea please.

#2Craig Ringer
craig@2ndquadrant.com
In reply to: AI Rumman (#1)
Re: "FATAL: role "postgres" does not exist" after recover

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/