Re: Restore live backup from posgtres/data/base/* gives PHPPGADMIN errors, works fine otherwise

Поиск
Список
Период
Сортировка
От Jo Voordeckers
Тема Re: Restore live backup from posgtres/data/base/* gives PHPPGADMIN errors, works fine otherwise
Дата
Msg-id pan.2004.02.12.21.09.02.980357@no_mail_from_usenet.be
обсуждение исходный текст
Ответ на Restore live backup from posgtres/data/base/* gives PHPPGADMIN errors, works fine otherwise  (Jo Voordeckers <jo@no_mail_from_usenet.be>)
Ответы Re: Restore live backup from posgtres/data/base/* gives PHPPGADMIN errors, works fine otherwise  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Op Thu, 12 Feb 2004 21:18:10 +0100, schreef Jo Voordeckers:

> restored from a live system backup. One CLOG file turned up to be
> missining according to syslog, however no database-transactions are used
> in this database application.

Hmm I think I misunderstood the transaction nature of the PG_CLOG files.
The one that seems to be missing 0023 is also giving those errors in the
application at some specific point. Should I restore this file also from
the backup tape? On the tape there are 2 files in PG_CLOG, currently
there are 2 files also but with different names. That's why I'm affraid
that restoring the 0023 it's missing could mess up the other DB's. Am I
correct?

What exactly are these PG_CLOG files for... they seem pretty important and
not corresponding to a single DB. What I don't understand is that some
query's error on this while others run fine... And again how can you
identify the PG_CLOG files's corresponding DB's.

-- 
Kind Regards,

Jo Voordeckers


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

Предыдущее
От: Jo Voordeckers
Дата:
Сообщение: Restore live backup from posgtres/data/base/* gives PHPPGADMIN errors, works fine otherwise
Следующее
От: ramirez@idconcepts.org (Edwin S. Ramirez)
Дата:
Сообщение: Re: Transaction aborts on syntax error.