Re: lost tables

----- 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