From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Lonni Friedman <lfriedman(at)vasoftware(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: unable to dump database, toast errors |
Date: | 2003-04-03 05:08:15 |
Message-ID: | 20030403050815.GF28355@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Apr 02, 2003 at 09:02:48PM -0800, Lonni Friedman wrote:
> Thanks for your reply. Can pgfsck run on a live database, or does it
> need to be shutdown first?
While you could in theory run it on a live database I wouldn't recommend it
given it can't get a consitant snapshot. But if you're just scanning for
problems it should be fine. It's a read-only program, it never actually
writes to the postgres files.
> NOTICE: Index pg_toast_302323_idx: NUMBER OF INDEX' TUPLES (86316) IS
> NOT THE SAME AS HEAP' (86292).
> Recreate the index.
>
> So, i took down the DB, started it in standalone, and ran:
> reindex INDEX pg_toast_302323_idx
>
> but according to the REINDEX dox, i should see a 'REINDEX' if all is
> well, and i never do, i'm just dumped back to another backend> prompt.
> Any ideas?
No idea here sorry...
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
> - Samuel P. Huntington
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-04-03 05:09:33 | Re: Forcing use of indexes |
Previous Message | Lonni Friedman | 2003-04-03 05:02:48 | Re: unable to dump database, toast errors |