lost tables

From: "Josh Goldberg" <josh(at)4dmatrix(dot)com>
To: "postgres-admin" <pgsql-admin(at)postgresql(dot)org>
Subject: lost tables
Date: 2003-03-28 02:45:27
Message-ID: 04c601c2f4d4$16f90da0$6e02a8c0@4dmatrix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Soler 2003-03-28 08:32:38 About sorting rows randomly
Previous Message Osvaneo Ap. Ferreira 2003-03-27 23:57:34 [ Possible problem with Postgres ]