Re: REINDEX "is not a btree" - Mailing list pgsql-general

From Alan Hodgson
Subject Re: REINDEX "is not a btree"
Date
Msg-id 200907100812.04294@hal.medialogik.com
Whole thread Raw
In response to Re: REINDEX "is not a btree"  (Vanessa Lopez <v.lopez@open.ac.uk>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: REINDEX "is not a btree"
Next
From: Simon Riggs
Date:
Subject: Re: Checkpoint Tuning Question