Re: Several problems with installation on FreeBSD - how to reinstall without loosing data

Поиск
Список
Период
Сортировка
От Jon Theil Nielsen
Тема Re: Several problems with installation on FreeBSD - how to reinstall without loosing data
Дата
Msg-id CABL6qKfeeNaKaVi2G9LZsyWiBeCeX-y0Kt59pDL_-EeherxgDA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Several problems with installation on FreeBSD - how to reinstall without loosing data  (Kevin Grittner <kgrittn@ymail.com>)
Ответы Re: Several problems with installation on FreeBSD - how to reinstall without loosing data  (Kevin Grittner <kgrittn@ymail.com>)
Re: Several problems with installation on FreeBSD - how to reinstall without loosing data  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-novice
Дерево обсуждения
> First, it started to complain about the role "root" did not
> exist. I don't think I have created anything that should refer to
> "root". Even though it's a potentially dangerous thing to do, I
> created the role. After that, the error message was that the
> "root" database did not exist. So I just created an empty
> database called "root". Then the server complained about loosing
> connection to a client.

To maximize your chances of getting suggestions which are most
helpful, it is better to copy and paste the specific error messages
with details about what led up to each error.

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Sure, I know that. It's a bit difficult though since a have used some commands that I can't really find in the history. But I'll give it a try.

First error message:
"postgres[15928]: [29993-1] FATAL:  role "root" does not exist"

Created user "root" with a command like "createuser -sdrP root" (not absolutely sure).

After restart, I got the error message:
"FATAL:  database "root" does not exist"

Then, from the webmin interface, I created an empty database called "root" owned by user "root" using no template.

After restart, I now got the error message:
"FATAL:  connection to client lost".

I don't know if this information is of any use in this context. Of course I can provide the content of some of my configuration files. I just don't know what to look for.

Regards,
Jon

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

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: Several problems with installation on FreeBSD - how to reinstall without loosing data
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Several problems with installation on FreeBSD - how to reinstall without loosing data