| From: | "Josh Goldberg" <josh(at)4dmatrix(dot)com> |
|---|---|
| To: | "Josh Goldberg" <josh(at)4dmatrix(dot)com>, "postgres-admin" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: lost tables |
| Date: | 2003-03-31 20:23:18 |
| Message-ID: | 069801c2f7c3$5e33c650$6e02a8c0@4dmatrix.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
bueller?
----- Original Message -----
From: Josh Goldberg
To: postgres-admin
Sent: Thursday, March 27, 2003 6:45 PM
Subject: [ADMIN] lost tables
I moved a few frequently used tables to a separate drive/partition with a symlink to my real data dir. Thank you Murphy, my other drive died yesterday and I hadn't been making backups of those tables. Now I have my db back up and running but those tables are hosed. I can't drop them using DROP TABLE, and I can't do a pg_dump anymore either. everything complains about pg_toast_xxxxxxxxxx where xxxxxxxx is the filename of the table. How do I clean this up so I can rebuild the tables?
thanks in advance,
Josh Goldberg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitry Morozovsky | 2003-03-31 21:11:31 | Re: pgAdmin II questions |
| Previous Message | mallah | 2003-03-31 19:14:04 | Re: bugs / feature list for 7.3.2 |