Re: Recover databases from raw files (only exists the basedirectory)

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Recover databases from raw files (only exists the basedirectory)
Дата
Msg-id 14cc3f597bb2b4fc8067fda28db352a08e8cc54f.camel@cybertec.at
обсуждение исходный текст
Ответ на Recover databases from raw files (only exists the base directory)  (Carlos Martinez <camarti@gmail.com>)
Список pgsql-general
Carlos Martinez wrote:
> I have  been contacted for this interesting issue: on a standalone  postgresql 9.4
> server someone deleted all PostgreSQL files and directories  except the base directory
> and its content (/var/lib/pgsql/9.4-base/data/base).
> 
> So, the question is: there is any chance/procedure to recover the databases?
> 
> As usual, the last backup has "a few" weeks. So, this dump can be used to recover the recent data?

I'd cut the losses and take the backup.

You'd need a specialist to recover anything there.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




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

Предыдущее
От: Chris Morris
Дата:
Сообщение: Re: Lookup Primary Key of Foreign Server's Table
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: jsonb_set() strictness considered harmful to data