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

Поиск
Список
Период
Сортировка
От Jon Theil Nielsen
Тема Several problems with installation on FreeBSD - how to reinstall without loosing data
Дата
Msg-id CABL6qKfZfiaeqZeNKOajB_=7du1-QMtE3yPWidD3TR+n2M0HWw@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  ("Christofer C. Bell" <christofer.c.bell@gmail.com>)
Список pgsql-novice
Hi list,

Even though I have had PostgreSQL for years, I think I am in fact a true novice. :-)

I have installed postgresql-server-9.2.4 on FreeBSD 9.1-Release.
A couple of month ago, I had a break-down of my server and since then, I have had problems with a lot of things. But at least I can see that pgsql is not configured correctly.

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.

I think that the best solution would be to reinstall pgsql. But it would be very inconvenient to loose at least one of the databases (I use it as part of at calendar server). Can I reinstall following a tutorial like this one and get the vital databases back? 

PS
I am not completely sure that pgsql is my only problem. I am using davical as a CalDAV server which can/could be accessed from both Thunderbird and an iPhone.

Regards,
Jon Theil Nielsen

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

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