lost tables - Mailing list pgsql-admin

From Josh Goldberg
Subject lost tables
Date
Msg-id 04c601c2f4d4$16f90da0$6e02a8c0@4dmatrix.com
Whole thread Raw
List pgsql-admin
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: "Osvaneo Ap. Ferreira"
Date:
Subject: [ Possible problem with Postgres ]
Next
From: "Marc Soler"
Date:
Subject: About sorting rows randomly