| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Peter Darley <pdarley(at)kinesis-cem(dot)com> |
| Cc: | Pgsql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Stale temp tables |
| Date: | 2002-03-11 20:49:22 |
| Message-ID: | 200203112049.g2BKnMT13187@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Peter Darley wrote:
> Friends,
> I've got a whole bunch (8,000 or so) of old stale temp tables that were the
> result of a hung backend. I can see them using pgAdmin II, but not through
> psql. Is there any way to dump these guys, should I dump them, are they
> likely to be causing problems? What should I do about this?
Wow, that is a good question. You can stop the postmaster and start the
'postgres' binary with the -O option and drop them. -O is required
because they are system tables.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick L. Nolan | 2002-03-11 20:52:14 | Looking for information about rtree index |
| Previous Message | Bruce Momjian | 2002-03-11 20:47:42 | Re: If possible create a table (not temp) for every user using |