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

From decibel
Subject Re: REINDEX "is not a btree"
Date
Msg-id 7D6BC9CA-C4FB-46DF-8D34-507163199802@decibel.org
Whole thread Raw
In response to Re: REINDEX "is not a btree"  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: REINDEX "is not a btree"
List pgsql-general
On Jul 4, 2009, at 8:06 AM, Craig Ringer wrote:
> On Fri, 2009-07-03 at 15:00 +0100, Vanessa Lopez wrote:
>> I don't know much about postgre, I have no clue what else I can do.
>> Please, please any help is very very much appreciated I have lots of
>> databases and months of work in postgre (also lots of backups for the
>> data in /data)
>
> When you say "in /data", do you mean the directory that contains the
> directories "pg_xlog", "base", "global", "pg_clog", etc ?
>
> Did you back up and restore the WHOLE data directory at once? Or
> did you
> restore only parts of it?


And how exactly did you make the backups? You can't simply take a
filesystem copy of a running database; that won't work.
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



pgsql-general by date:

Previous
From: decibel
Date:
Subject: Re: cache reads vs. disk reads
Next
From: m_lists@yahoo.it
Date:
Subject: Re: Performance problem with low correlation data