Re: Is my db dead ?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Is my db dead ?
Дата
Msg-id 20080205151941.GC4066@alvh.no-ip.org
обсуждение исходный текст
Ответ на Is my db dead ?  (dawmette@gmail.com)
Ответы Re: Is my db dead ?
Re: Is my db dead ?
Список pgsql-general
dawmette@gmail.com escribió:
> My server crashed yesterday, the hd was saved though and I was able to
> get a copy of the data directory of my pg cluster. On the server now,
> when I start pg, I can see only like 1% of my data, there are many dbs/
> tables and rows missing. But the data dir seems ok in size though. So
> I copied the whole data dir to a new serv, installed the same pg
> version but now I can't get it started at all. There are some weird
> things in the pg_controldata :
>
> pg_control last modified:             Tue 03 Sep 6869 17:57:36 CET
> Time of latest checkpoint:            Thu 11 Jan 1116953 03:46:31 CET
> LC_COLLATE:
> LC_CTYPE:

What's the full pg_controldata output?  Can you send the pg_control file
as a binary attachment?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Предыдущее
От: Larry Rosenman
Дата:
Сообщение: Re: Universal libpq.a ?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Universal libpq.a ?