Re: lost tables - Mailing list pgsql-admin

From Josh Goldberg
Subject Re: lost tables
Date
Msg-id 069801c2f7c3$5e33c650$6e02a8c0@4dmatrix.com
Whole thread Raw
In response to lost tables  ("Josh Goldberg" <josh@4dmatrix.com>)
Responses Re: lost tables
List pgsql-admin
bueller?
----- Original Message -----
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

pgsql-admin by date:

Previous
From:
Date:
Subject: Re: bugs / feature list for 7.3.2
Next
From: Dmitry Morozovsky
Date:
Subject: Re: pgAdmin II questions