Re: 7.4 - data recovery

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7.4 - data recovery
Дата
Msg-id 4199.1156530991@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 7.4 - data recovery  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-admin
Peter Eisentraut <peter_e@gmx.net> writes:
> Bartosz Belter wrote:
>> 3. I've recovered some files and it looks to me they're from
>> $PGDATA/base/data/xxx (it looks this is the complete folder)
>> 4. No other files! (no pg_clog, pg_xlog etc)

> If you don't have a clog, then all your transactions will appear
> as "didn't happen yet", so your table data appears to be in the future.
> You can just commit dummy transactions until it appears again.  This is
> obvious not an official and approved way, but it's at least a shot
> before you're forced to get out your hex editor.

Less painfully, use pg_resetxlog to push the XID and WAL counters up
past what's in the database.  The problem is to know where to set them
:-(

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problem with PostgreSQL 8.1.4 Install (using RPMs)
Следующее
От: "Jeanna Geier"
Дата:
Сообщение: Issue With Restoring a Dump