Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux