Re: unable to dump database, toast errors

so tom, do you ever sleep? :-) I know you're in Japan, but you're always
replying whenever I'm awake!

Tom Lane wrote:
>
> Lonni Friedman <lfriedman@vasoftware.com> writes:
> > So, i took down the DB, started it in standalone, and ran:
> > reindex INDEX pg_toast_302323_idx
>
> For a user table you didn't really need to take down the DB.
>
> > 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.
>
> That is a user-interface detail that is correct when running psql,
> but I don't think a standalone backend bothers with such fine points.
> If it didn't spit up an error message then it was happy.
>
> The real question is did pg_dump get any better after you did this?
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org