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

Поиск
Список
Период
Сортировка
От AI Rumman
Тема "FATAL: role "postgres" does not exist" after recover
Дата
Msg-id CAGoODpcg+KLOnZgxWsM=OSxcNzS0V1D8LPvc+E0RdzQucmYOuw@mail.gmail.com
обсуждение исходный текст
Ответы Re: "FATAL: role "postgres" does not exist" after recover  (Craig Ringer <craig@postnewspapers.com.au>)
Список 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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Rick Genter
Дата:
Сообщение: Re: Slow query with sub-select
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: "FATAL: role "postgres" does not exist" after recover