Re: lost tables

Поиск
Список
Период
Сортировка
От Josh Goldberg
Тема Re: lost tables
Дата
Msg-id 069801c2f7c3$5e33c650$6e02a8c0@4dmatrix.com
обсуждение исходный текст
Ответ на lost tables  ("Josh Goldberg" <josh@4dmatrix.com>)
Ответы Re: lost tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: bugs / feature list for 7.3.2
Следующее
От: Dmitry Morozovsky
Дата:
Сообщение: Re: pgAdmin II questions