Re: REINDEX "is not a btree"

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: REINDEX "is not a btree"
Дата
Msg-id 200907100812.04294@hal.medialogik.com
обсуждение исходный текст
Ответ на Re: REINDEX "is not a btree"  (Vanessa Lopez <v.lopez@open.ac.uk>)
Список pgsql-general
On Friday 10 July 2009, Vanessa Lopez <v.lopez@open.ac.uk> wrote:
> What do you mean by we can't simply take a filesystem copy of a
> running database? :-O ... How should we then do the backups (so next
> time I will not have the same problem again) ?

There is extensive documentation on how to do backups. For filesystem
backups, see PITR.

You might also want to examine all your backup strategies  - most running
applications are not happy about being backed up without taking special
steps to ensure data consistency.

--
Anyone who believes exponential growth can go on forever in a finite world,
is either a madman or an economist.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: REINDEX "is not a btree"
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Checkpoint Tuning Question