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

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: "FATAL: role "postgres" does not exist" after recover
Date: 2011-07-17 09:19:19
Message-ID: CAGoODpcg+KLOnZgxWsM=OSxcNzS0V1D8LPvc+E0RdzQucmYOuw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-07-17 11:19:12 Re: "FATAL: role "postgres" does not exist" after recover
Previous Message Rick Genter 2011-07-16 23:40:10 Re: Slow query with sub-select