Thread: "FATAL: role "postgres" does not exist" after recover
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.
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.
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/