| From: | Lonni J Friedman <lfriedman(at)vasoftware(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: unable to dump database, toast errors |
| Date: | 2003-04-03 14:42:25 |
| Message-ID: | Pine.LNX.4.44.0304030641490.28169-100000@beefcake.hdqt.vasoftware.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 3 Apr 2003, Tom Lane wrote:
> Lonni Friedman <lfriedman(at)vasoftware(dot)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.
attempting to drop pg_toast_302323_idx failed with an error that it was a
system index.
> > 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?
unfortunately, no.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Hihn | 2003-04-03 14:48:26 | Help with array constraints |
| Previous Message | Peter Haworth | 2003-04-03 14:40:59 | Re: this date format thing. |