Re: Crashed DB and "base" folder files

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Crashed DB and "base" folder files
Дата
Msg-id 46D3CCEF.4040309@archonet.com
обсуждение исходный текст
Ответ на Crashed DB and "base" folder files  ("Franck Roubieu - AXCENTEO" <froubieu@axcenteo.com>)
Список pgsql-general
Franck Roubieu - AXCENTEO wrote:
> Hello,
>
> My DB crashed without any recent backup.

What happened to cause it to crash?

> I have old DB files.
>
> Can i use "base" folder files to restore ?

Yes, but it's only reliable if the file-backup was taken while the
database wasn't running.

I'm assuming PG won't restart with the current files? What do the logs show?

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: delete vs insert vs update due to primary key dups -> which is better
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Windows Download